External Web Service Mapping

External Web Service Mapping helps Administrators to configure data flow from SummitAI to Client Web Services and vice versa. You can configure the following configurations:

  • Incident creation from SummitAI to Client Web Service

  • Incident creation from Client Web Service to SummitAI

  • Incident update from SummitAI to Client Web Service

  • Incident update from Client Web Service to SummitAI

  • Service Request creation from SummitAI to Client Web Service

  • Service Request creation from Client Web Service to SummitAI

  • Service Request update from SummitAI to Client Web Service

  • Service Request update from Client Web Service to SummitAI

  • Word Order creation from SummitAI to Client Web service

  • Word Order creation from Client Web Service to SummitAI

  • Word Order update from SummitAI to Client Web Service

  • Word Order update from Client Web Service to SummitAI

  • User Master creation from Client Web Service to SummitAI

  • User Master update from Client Web Service to SummitAI

To Configure External Web Service Mapping:

  1. Select Admin > Basic > Infrastructure > External Web Service Mapping.
  2. The EXTERNAL WEB SERVICE MAPPING LIST page is displayed. Click ADD NEW on the ACTIONS panel.
  3. On the EXTERNAL WEB SERVICE MAPPING page, fill in all the required information and click SUBMIT

    External Web Service Configuration page
    Figure: External Web Service Configuration page

The following three tabs are available on the EXTERNAL WEB SERVICE CONFIGURATION page:

 CONFIGURATION Tab

The CONFIGURATION tab has the following sections:

  • CONFIGURATION DETAILS
  • WEB SERVICE DETAILS
  • ATTACHMENT DETAILS
  • JOB DETAILS
CONFIGURATION DETAILS

Under this section, configuration details, such as Configuration Name, Configuration Description, etc., are specified. For more information about the fields on the CONFIGURATION DETAILS section, see Field Description.

WEB SERVICE DETAILS

Under this section, Web Service details for both the Source and the Target fields are specified. For more information about the fields on the WEB SERVICE DETAILS section, see Field Description.

ATTACHMENT DETAILS

Under this section, the attachment configurations for Incidents, Service Requests, and Work Orders are specified. For more information about the fields on the ATTACHMENT DETAILS section, see Field Description.


Note:

The ATTACHMENT DETAILS section is only available when the Include Attachment check box is selected under the CONFIGURATION DETAILS section.

JOB DETAILS

Job details, such as Job schedule, Frequency, and universal time can be specified under this section. For more information about the fields on the JOB DETAILS section, see Field Description.

Note:

The JOB DETAILS fields are disabled on the edit page. You can revise these fields for an existing configuration from the CUSTOM SCHEDULER page (see: Configuring Custom Scheduler).



Figure: Configuration tab 

Field Description

The following table describes the fields under the CONFIGURATION tab:

Field

Description

CONFIGURATION DETAILS
Configuration NameSpecify the configuration name.
DescriptionSpecify the description of the configuration.
SummitAI as SourceSelect this check box when you want to configure the data flow from SummitAI to the Client web services.
Batch Process

Select this check box when you want to configure the data flow from Client Web Services to SummitAI.

The Batch Process only applies in the following two scenarios:

  • User Master creation from Client Web Service to SummitAI
  • User Master update from Client Web Service to SummitAI

Note: When the SummitAI as Source check box is not selected, the Batch Process check box appears below it.

No. of Records (in a Batch) 

Specify the number of records you want to create or update in a single batch.

Note:

  • When the Batch Process check box is selected, a new field, No. of Records (in a Batch) appears below it.
  • You can specify a maximum of 100 records in the No. of Records field.
Include AttachmentSelect this check box if you want to include attachment of Incident/ Service Request/ Work Order for the data flow configuration. Upon selecting Include Attachment check box, a separate ATTACHMENT DETAILS section is displayed below the WEB SERVICE DETAILS section.
WEB SERVICE DETAILS
Service URLSpecify the Web Service URL for both the Source and the Target.
Service DescriptionSpecify the Web Service description for both the Source and the Target.

Configure API Authentication

 Select the pre-defined authentication values of the list. The listed values are:
  1. No Authentication

  2. API Key - Specify the API key details.


    Figure: API Key

  3. Bearer Token

    1. Static Bearer Token


      Figure: Static

    2. Dynamic Bearer Token


      Figure: Dynamic Bearer Token

  4. Basic - Specify the credentials for the authentication.



  5. OAuth 2.0 - Enter the required auth details.


    Figure: OAuth 2.0
Authorization Key/ Token

Provide Authorization details to authenticate API for both the Source and the Target.

HeadersSelect the Web Service type from the drop-down list for both the Source and the Target.

To pass any additional information in the API call you make, provide the key and value in Additional Header(s). 
Request BodyProvide the Input data for both the Source and the Target.
Response JSON Key

Specify the JSON path from where want to consume the response.

Get ResponseClick Get Response button to get the response for specified JSON key.
Response Template

Response for specified JSON key gets auto filled in this field after clicking on Get Response button.

Map Data

Select this check box to configure columns and their values to exchange the data between the two web services.

View/Edit Data Mapping

Click View/Edit Data Mapping button to configure the Column Names and their values to exchange the data between two Web Services. Upon clicking the View/Edit Data Mapping button, the MAP DATA pop-up page is displayed.

Figure: MAPPING FIELDS

The Source Response Field contains an array with three elements: "value1", "value2", and "value3". You can access the values within the array using the appropriate object parameters and values.

The Target Input Field contains an "input" field. When passing this JSON object as the input to the field, make sure to provide the necessary formatting and parsing based on the value name and attribute you are using to Map.


Note: The View/Edit Data Mapping button is displayed while editing only when the Map Data check box is selected.

Once you check the Map Data check box, you will see the page to map the data as shown below: 

Figure: Default check box 

Once you check the Default Check box, the value entered in the Source/Target column will be considered as a Default value. This means that when there is no matching value in the Third-Party system this default value will be considered for all future transactions.


New Column named Collection addition under View/Edit Field Mapping

There is a new column named Collection, where three new options have been introduced namely First, Last and All in the source field.

Figure: Collection Column


Figure: First, Last, All options

First: Choose this option to map only the first attribute of the array mentioned in the Source Field to the Target Field.

For example, if we have the below input in the source field,

Source: Fields.comment.comments.0.body

and we select the First option under collections, then only the First comment in that array will be mapped to the Target Field.

Last: Choose this option to map only the Last attribute of the array mentioned in the Source Field to the Target Field.

For example, if we have the below input in the source field,

Source: Fields.comment.comments.0.body

and we select the Last option under collections, then only the First comment in that array will be mapped to the Target Field.


All: Choose this option to map all the attributes of the array mentioned in the Source Field to the Target Field which will be comma separated.

For example, if we have the below input in the source field,

Source: Fields.comment.comments.0.body

and we select the All option under collections, then all the comments (Comma separated) in that array will be mapped to the Target Field.


Note
In case there is no array matching with the input provided in the Source Field, this option will be greyed out.

Confidential Key Value Protection Changes in External Web service Configuration

While mapping with a third-party application, to gain access we need to enter the credentials such as an API Key which is confidential information. To protect such confidential information, we have implemented Confidential Key Value Protection.

While entering confidential information such as the API Key in the request body, the platform has been updated so that the API key can be mentioned along with $$ as prefix and suffix as shown below:


 “APIKey”: $$APIKEY$$

After entering this in the request body, on clicking SUBMIT, user will be prompted to enter the Actual API Key (which is confidential) under PLACEHOLDER INPUTS as shown below:

Figure: API Key

On clicking the eye Icon next to the field, you can hide the confidential information as shown below:

Figure: Confidential information hidden using Eye Icon

Similarly, while entering any information while configuring an API key, any confidential information can be suffixed and prefixed with $$ as shown below, to protect the confidentiality of the information. The user will be prompted to enter the confidential information separately. The same has been implemented for the following fields:

  • Request Body:

In the request body, enter the $$ symbol before and after the API Key to protect the confidential information as shown below:

Figure: Request Body

  • Additional Headers

  • URL

Figure: $$ before and after the Target URL

You will get a prompt and the Target URL will be hidden as shown below:

MAP DATAThe MAP DATA pop-up page consists of four sections, namely, FILTERS, IMPORT/EXPORT, CONFIGURATION, and LIST.
FILTERSThe FILTERS section contains the following fields.
Search BySelect one of the Search By criteria that are Source Column Name, Source Column Value, Target Column Name, or Target Column Value.
Search ValueSpecify the Search Value based on selected search by criteria.
IMPORT/EXPORTThe IMPORT/EXPORT section contains the following fields.
Import/Export OptionSelect the Import/Export option, that is, either JSON or XML
Download Template

Click the Download Template button to download the JSON or XML template for import configure columns and their values to exchange data between the two web services.

Upload Web Service Mapping

Browse a Web Service mapping and click Upload to import the columns and their values to exchange data between the two Web Services.

CONFIGURATIONThe CONFIGURATION section contains the following fields.
Source Column NameSelect a Source Column Name from drop-down list.
Source Column ValueSpecify the Source Column Value based on the selected Source Column Name.
Target Column NameSelect a Target Column Name from drop-down list.
Target Column ValueSpecify the Target Column Value based on the selected Target Column Name.
LISTThe LIST section contains the following fields.
Source Column NameThe Source Column Name column displays list of configured Source Column Names.
Source Column Value The Source Column Value column displays list of configured Source Column Values.
Target Column NameThe Target Column Name column displays list of configured Target Column Names.
Target Column ValueThe Target Column Value column displays list of configured Target Column Values.
Action

Clickadd new field mappingadd new field mapping andremove any existing field mappingto remove any existing field mapping.

View/Edit Fields MappingClick View/Edit Fields Mapping button to map request and response fields accordingly. Upon clicking the View/Edit Fields Mapping button, the MAPPING FIELD pop-up page is displayed.
MAPPING FIELDThe MAPPING FIELD pop-up page contains the following fields.
Source Response FieldSpecify a Source Response field.
Target Input FieldSpecify a Target Input Field to which you want to map the Source Field.
Action

Clickadd new field mappingadd new field mapping andremove any existing field mappingto remove any existing field mapping.

format JSON

Click to format JSON.

Original JSON

Click to revert JSON format to original format.

Click to view/Edit JSON.

ATTACHMENT DETAILS

Note: ATTACHMENT DETAILS section displayed only after selecting Include Attachment check box on the CONFIGURATION DETAILS section. Configure ATTACHMENT DETAILS section to include attachment of Incident/ Service Request/ Work Order for the data flow configuration.

Service URLSpecify the Web Service URL for both the Source and the Target.
HeadersSelect the Web Service type from the drop-down list for both the Source and the Target.
Request BodyProvide the Input data for both the Source and the Target.
Response JSON Key

Specify the JSON path from where you want to consume the response.

Response TemplateProvide a sample output data.
File Data TypeSelect a file data type under the File Data Type drop-down field.
  • Base64: Select to represent binary data in an ASCII string format by translating it into a radix-64 representation.
  • Byte Array: Select byte array to store a collection of binary data, for example, the contents of a file.
  • Multipart/form data: Select Multipart/form data for request payloads that contain files, non-ASCII, and binary data. 
Response DataSpecify the Response Data.
View/Edit Fields MappingClick View/Edit Fields Mapping button to map request and response fields accordingly. Upon clicking the View/Edit Fields Mapping button the MAPPING FIELD pop-up page is displayed.
MAPPING FIELDThe MAPPING FIELD pop-up page contains the following fields.
Source Response FieldSpecify the Source Response Field.
Target Input FieldSpecify the target input field to which you want to map the Source Field.
Action

Clickadd new field mappingadd new field mapping andremove any existing field mappingto remove any existing field mapping.

format JSON

Click icon to format JSON.

Original JSON

Click to revert JSON format to the original format.

Click icon to view/edit JSON.
JOB DETAILS
Run At

Selected the Server type under the drop-down field. Following two servers types are available under the Run At drop-down field: Summit Server and Proxy Server.

Schedule Start Date (UTC)

Specify a start date and time according to UTC zone for the Web Service configuration.

Frequency (In Mins)

Specify a time interval in minutes.

Note: If the No. of Records under the Configuration Details tab is more than 500 for Batch processing, the job will run for longer period of time to process all the records. Please increase the Job Frequency.
ActiveIf selected, the configuration becomes active. 
 SUCCESS Tab

The SUCCESS tab configuration is optional. You can configure the Success tab to capture information about the successful data flow of data from SummitAI to client web services and vice versa. If configured, the success details are recorded in the SummitAI or client database accordingly. For more information about the fields under the SUCCESS tab, see Field Description.

Success tab - No Action Required
Figure: Success tab - No Action Required

Success tab - Action Required
Figure: Success tab - Action Required

Field Description

The following table describes the fields under the SUCCESS tab:

Field

Description

Actions RequiredSelect actions required as Yes or No
RESPONSE DETAILSThe RESPONSE DETAILS section contains the following fields.
Service URLSpecify the Web Service URL for both the Source and the Target.
Service DescriptionSpecify the Web Service description for both the Source and the Target.
Authorization Key/ Token

Provide Authorization details to authenticate API for both the Source and the Target.

HeadersSelect the Web Service type from the drop-down list for both the Source and the Target.
Request BodyProvide the Input data for both the Source and the Target.
Response JSON Key

Specify the JSON path from where you want to consume the response.

Response TemplateProvide a sample output data.
Map Data

Select this check box to configure columns and their values to exchange the data between the two Web Services.

View/Edit Data Mapping

Click View/Edit Data Mapping button to configure the Column Names and their values to exchange the data between two Web Services. Upon clicking the View/Edit Data Mapping button, the MAP DATA pop-up page is displayed.

Note: The View/Edit Data Mapping button is displayed while editing only when the Map Data check box is selected.
MAP DATAThe MAP DATA pop-up page consists of four sections namely FILTERS, IMPORT/EXPORT, CONFIGURATION, and LIST.
FILTERSThe FILTERS section contains the following fields.
Search BySelect one of the Search By criteria that are Source Column Name, Source Column Value, Target Column Name, or Target Column Value
Search ValueSpecify the Search Value based on the selected search by criteria.
IMPORT/EXPORTThe IMPORT/EXPORT section contains the following fields.
Import/Export OptionSelect Import/Export Option, that is either JSON or XML
Download Template

Click the Download Template button to download the JSON or XML template for import configure columns and their values to exchange data between the two web services.

Upload Web Service Mapping

Browse a Web Service mapping and click Upload to import configure columns and their values to exchange data between the two web services.

CONFIGURATIONThe CONFIGURATION section contains the following fields.
Source Column NameSelect a Source Column Name from drop-down list.
Source Column ValueSpecify the Source Column Value based on the selected Source Column Name.
Target Column NameSelect the Target Column Name from drop-down list.
Target Column ValueSpecify the Target Column Value based on the selected Target Column Name.
LISTThe LIST section contains the following fields.
Source Column NameSource Column Name column displays list of configured Source Column Names.
Source Column Value Source Column Value column displays list of configured Source Column Values.
Target Column NameTarget Column Name column displays list of configured Target Column Names.
Target Column ValueTarget Column Value column displays list of configured Target Column Values.
Action

Clickadd new field mappingadd new field mapping andremove any existing field mappingto remove any existing field mapping.

View/Edit Fields Mapping

Click View/Edit Fields Mapping button to map request and response fields accordingly. Upon clicking the View/Edit Fields Mapping button, the MAPPING FIELD pop-up page is displayed.

MAPPING FIELDThe MAPPING FIELD pop-up page contains the following fields.
Source Response FieldSpecify a Source Response Field.
Target Input FieldSpecify a Target Input Field to which you want to map the source field.
Action

Clickadd new field mappingadd new field mapping andremove any existing field mappingto remove any existing field mapping.

format JSON

Click icon to format JSON.

Original JSON

Click to revert JSON format to the original format.

Click icon to view/edit JSON.
 FAILURE Tab

The Failure configuration is the system-created configuration when SummitAI is the target and few tickets (Incidents, Service Requests, and Work Orders) failed to process. All the failed tickets are picked up for re-processing based on the FAILURE tab configuration. Also, you can configure e-mail notification for failed tickets (Incidents, Service Requests, and Work Orders). For more information about the fields under the FAILURE tab, see Field Description.


Figure: Failure tab

Field Description

The following table describes the fields under the FAILURE tab:

Field

Description

Retry Count

Select retry count to process the Job again when tickets (Incidents, Service Requests, and Work Orders) are failed.

Note:

  • The Retry count is the number of times the Job retries to process the tickets (Incidents, Service Requests, and Work Orders) that have failed to process.
  • A maximum value of 100 can be set in the Retry Count field.
Failure Configuration

If selected, all the failed tickets are picked up for re-processing.

Note:

  • Failure configuration is a system-created configuration when SummitAI is the target and few tickets (Incidents, Service Requests, and Work Orders) failed to process.
  • The Failure Configuration check box appears only when the SummitAI as Source check box is not selected on the CONFIGURATION tab.
Attempts for (in hrs)

Specify the attempts (in time) to process the failed tickets (Incidents, Service Requests, and Work Orders). 

Note:

The Attempts for (in hrs) field appear only when SummitAI as Source check box is not selected on the CONFIGURATION tab.
NOTIFICATIONThe NOTIFICATION section contains the following fields.
Set NotificationIf selected, you can configure an e-mail template to notify the user about ticket failure.
To ListSpecify the e-mail recipients for the notification related to ticket failure.
CC ListSpecify the Cc e-mail recipients for the notification related to ticket failure.
SubjectSpecify the subject for the e-mail notification.
BodySpecify the e-mail body of the e-mail notification. 

Quick Help

Click Quick Help Quick Help Icon icon to open the QUICK HELP pop-up page. The QUICK HELP pop-up page consists of four different tabs, namely,  Incident, Service Request, Work Order, Name, and User Master along with the search text box .

You can search for a particular key word under search box and the respective results are displayed on the related tab.


Figure: QUICK HELP pop-up page

ACTIONS

This section explains all the icons displayed on the ACTIONS panel of the EXTERNAL WEB SERVICE CONFIGURATION page.

ADD NEW

Click ADD NEW to configure a new External Web Service.

Following icons displayed on the ACTIONS panel of the new External Web Service configuration page:

SHOW LIST
Click SHOW LIST to display the LIST table showing all the EXTERNAL WEB SERVICES that are configured in the SummitAI application.

IMPORT CONFIGURATION
Click IMPORT CONFIGURATION to import configuration from JSON/XML file.

Following icons are displayed on the ACTIONS panel while editing External Web Service configuration:

SHOW LIST
Click SHOW LIST to display the LIST table showing all the EXTERNAL WEB SERVICES that are configured in the SummitAI application.

IN QUEUE
Click IN QUEUE to display the list of records in queue for data syncing between the two Web Services.

SYNCED RECORDS
Click SYNCED RECORDS to view the list of records that are synced up between the two Web Services.

RETRY
Click RETRY to sync up the records that failed to sync up between the two Web Services.

EXPORT CONFIGURATION
Click EXPORT CONFIGURATION to export the configuration to a JSON/XML file.

COPY CONFIGURATION
Click COPY CONFIGURATION to copy details from this configuration to a new configuration.