ingest that Incident data to an Incident Tab in a Dashboard Using Table API
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-19-2023 05:10 PM
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
- Labels:
-
Architect
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-21-2023 09:46 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-26-2023 08:42 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-27-2023 07:22 AM
For your approach simple solution as below:
- 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.
- In SN Instance B- Configure Flow which will be triggered on any NEW, UPDATE, or DELET of Incident record.
- In Flow call the Scripted REST API Endpoint of SN Instance A.
- 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-29-2023 11:26 AM
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.