ServiceNow Integration

You must import and schedule each data feed that you want to use.

Task 1: Import a data feed

1. From the menu, click > Integration > Data Feeds.

2. Import them following the steps below.

   1. On the data feed listing page, click .

   2. Locate and select the .dfx5 file for the data feed.

3. Select the data feed you want to configure.

4. On the General tab, in the General Information section, select Active.

5. On the Source Connection tab, follow the set of steps below based on the transport type. All these feeds are JavaScript transport type.

JavaScript transport type

Before you upload a JavaScript file, you must configure the JavaScript Transporter settings in the Archer Control Panel. For more information, see "JavaScript Transporter Settings" in the Archer Control Panel Help.

1. In the Transport Configuration section, select the JavaScript file supplied with the package, all the feeds uses the same file. 

   1. From the Transport Configuration section, click

   2. In the Upload JavaScript File dialog, click Add New.

   3. Navigate to and select the servicenow JavaScript file and click Open.

   4. In the Upload JavaScript File dialog, and click OK.

2. If the JavaScript Transporter has been set up in the Archer Control Panel to only allow digitally signed JavaScript files from trusted sources, you can only select digitally signed JavaScript files from trusted sources. For more details, see "Configuring JavaScript Transporter Settings" in the Archer Control Panel Help.

3. In the Custom Parameters section, enter the following custom parameters you want to reference within the selected JavaScript file.

The following table lists the data feed required custom parameters for ingest configuration.

The following table lists the data feed required custom parameters for export configuration.

Note: The Archer Professional Services team also provides services to export Archer data to populate ServiceNow data tables. Please contact your Account Representative for additional information regarding these services.

The following table lists additional optional valid custom parameters.

4. Click the Data Map tab, then click the Field Map and Key Field Definitions tabs.

5. The data feed might map to objects and key fields in applications that you do not have licensed. Clicking on the Field Map and Key Field Definitions tabs allows the system to resolve these mappings.

6. Verify that the key field value is not missing from the data feed setup window:

7. Do one of the following:

   1. To continue configuring the data feed, go to the next task.

   2. To finish setting up the feed later, click Save or Save and Close.

A data feed must be active and valid to successfully run. A successful data feed run processes all input data, completes all expected record updates, and does not report any failures in the Run Details Report.

Validating a data feed

The Data Feed Manager validates the information when a data feed is scheduled. If any information is invalid, the data feed displays an error message. You can save the data feed and correct the errors later, but the data feed does not process until you make corrections.

Running a data feed

You can set up data feeds to run automatically at regular intervals. This reduces the time and effort required to import data from an external file.

You can initiate data feeds at various times and configure them to run in regular increments for an indefinite period of time.

You can run the data feed immediately.

To prevent excess server load, schedule data feeds on a staggered basis. You can schedule a maximum of 10 data feeds to run at a time. If more than 10 data feeds are scheduled, each remaining data feed runs as the previous one completes.

Setting up a reference data feed

A reference feed allows you to specify another feed. This indicates to the Data Feed Service that this feed will start running as soon as the referenced feed completes successfully.

1. Go to the Run Configuration tab > Schedule section.

2. Do one of the following to schedule your data feed.

   • Run on Schedule. You can configure your data feed to run on a defined schedule.

   • Run After. The Data Feed Services starts the current data feed after the referenced data feed completes successfully.

   • Run Now.

3. To save the data feed, click Save or Save and Close

Run The feed to check if data is being populated or not.

To create a data feed to export data from any ServiceNow table to any application in Archer, complete the steps below.

1. Create data feed.

2. Follow the steps as mentioned above. (Do not upload edited JS file that will disrupt the signature)

3. To get the xml structure to set up the source definition do the following:

   1. Copy the js file provided in the package.

   2. Open the file in text editor.

   3. Set generateFieldDefinitions to true line number 10077.

   4. Set the filePathand filename to fieldDefinitionFilePath line number 10078.

   5. Set ServiceNowUrl, ServiceNowUsername, ServiceNowPassword,ServiceNowTable in line 10139 to 10142.

   6. Uncomment Line number 4, 5and 6174.

   7. Run the code in NodeJs.

4. Once the field definition generated use that to populate the field definition Tab.

5. Map the data according to your need. Select "ServiceNow Global Id" field (the field created in Archer which is mapped to source sys_id ) as key field in Key Field Definition and schedule the feed.

To create a data feed to export data from any Archer application to any table in ServiceNow, complete the following steps.

Note: The Archer Professional Services team also provides services to export Archer data to populate ServiceNow data tables. Please contact your Account Representative for additional information regarding these services.

Step 1 - Export the configuration

1. Create the data feed.

2. Select the Target Application from which you want to export data to ServiceNow.

3. Follow the steps in the Set up data feeds section to upload the js file and set up the custom parameters for export feed.

Step 2 - Identify the fields to export

Create a report with all the fields you want to export values from including Content id and ServiceNow Global Id. Provide the report guid as ExportReportsList value in data feed custom parameter section.

The description of the reports used as source needs to update with a specific JSON format as shown here.

{

        "ExportMode": "Update",

        "ArcherSysIDField": "ServiceNow_Global_Id",

        "ServiceNowTable": "incident",

        "SerivceNowIncludeRefs":"false",

        "FieldMap": {

            "impact": {

                "FieldName": "impact",

                "FieldType": "Static",

                "StaticValue": "3"

            },

            "urgency": {

                "FieldName": "urgency",

                "FieldType": "Static",

                "StaticValue": "1"

            },

            "Description": {

                "FieldName": "description"

            }

        }

    }

JSON Configuration Information

JSON Field Map Description

Step 3 - Set up the source definition

Set up the source definition for the xml structure.

1. Copy the js file provided in the package.

2. Open the file in text editor.

3. Set generateFieldDefinitions to true line number 10077.

4. Set the filePathand filename to fieldDefinitionFilePath line number 10078.

5. Set ServiceNowUrl, ServiceNowUsername, ServiceNowPassword,ServiceNowTable in line 10104 to 10106. Set ArcherUrl, ArcherUserName, ArcherInstance,ArcherPassword in line number 10115 to 10118.

6. Set ExportReportsList values in line number 10130.

7. Uncomment Line number 4, 5 and 6174.

8. Run the code in NodeJs.

Step 4 - Complete the configuration

1. Once the field definition is generated use that to populate the field definition Tab.

2. Map contentid to Archer Content ID and SysId with ServiceNow Global Id.

3. Select Content ID field as key field in Key Field Definition, select "Update existing record, if a matching record is found" in Run Configuration and schedule the feed.