ingest that Incident data to an Incident Tab in a Dashboard Using Table API

ONASSIS MONYE O
Tera Contributor

I have a project that I want to work on, I have Incident data in ServiceNow instance A and I want to stream/or ingest that Incident data to an Incident Tab in a Dashboard in a ServiceNow Instance B using table API.

 

I need help with getting the Table API and the main steps in getting this done, thanks

4 REPLIES 4

vitthalude
Tera Contributor

If you are going to use the aggregated data to send to instance B then

Solution 1): 

1) Create Scripted REST API to send this aggregated data from instance A to instance B.

2) You can make use of Decision Table to send the corresponding data only. Ex. a) If you want to send only P1 incident which resolved in this month, configure the corresponding decision for this.

 

else

Solution 2):

1) Create a normal or data stream action in Sn instance B with table API of Sn Instance A in its REST step.

2) use output of that data to store in custom table to use in dashboard

 

Note: if volume of data is huge better to aggregate that in Sn instance A and then use that in instance B. or use filter condition in action to pull only required data.

 

Please mark answer useful

 

Thanks 

Vitthal

 

ONASSIS MONYE O
Tera Contributor

I am looking at using a Rest Endpoint with Table API, the Primary ServiceNow Instance A, is where the Dashboard that will be displaying the incident data for use, whey the Secondary ServiceNow instance B, will continue to be where the Incident table resides, my goal is that any NEW, UPDATE, or DELET of Incident record will reflex on the Dashboard in the Primary ServiceNow Instance A.

 

I am looking to see if anyone have done this, or if you know about this, I will appreciate if you can give me detail steps to go about this.

 

I am also working on it, if I succeed before then, I will post it here. Thanks

For your approach simple solution as below:

  1. Create a Scripted REST API in SN Instance A. Add the logic to receive data into any custom table from which dashboard will be generated. Configure the requested body with required details of Incident record.
  2. In SN Instance B- Configure Flow which will be triggered on any NEW, UPDATE, or DELET of Incident record.
    1. In Flow call the Scripted REST API Endpoint of SN Instance A.
    2. Pass on the required request body to Scripted REST API Endpoint which you configured in Step 1.

Note: Rate Limit will be applicable for number of API hit. You can configure it as per your need.

 

Please mark my answer helpful if it help you.

 

Thanks 

Vitthal 

ashishdevsingh
Tera Expert

If i understood correctly, you want to send the data from instance A to instance B to perform CRUD opration so that dashboard can be updated. If yes, my approach would be : 

1. Use flow which will be triggered on basis of operation. you can create multiple flow on basis of complexity or conditions involved. 

2. go to instance B and use rest explorer to get the proper table API. Use the same API to configure the outbound services which will be added in flow (if scripting is involved you need to create custom action.)

3. write the logic inbound services in instance B, to receive the data from instance A and perform the needful. 

4. If data flow is high use import set table before performing any action. there you can write the logic to manipulate the data before processing.