ServiceNow Integration to pull the data from one instance to another instance using Rest Api Explore
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-24-2023 12:02 AM - edited 05-24-2023 01:21 AM
How to pull data from one instance to another instance using staging table through Outbound Rest Api Explorer "Retrieve records from a table (GET)" method.
for ex: I have two instances, instance A and instance B, now I want to pull the incident data from instance B to instance A using Rest Api Explorer "Retrieve records from a table (GET)" method.
And when I pull the data into instance A, so whatever response we receive in response body I want to load that into a staging table of instance A and then after that using transform, I want to put in incident table of instance A.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-24-2023 03:14 AM
you can do this in instance A
1) create an import set API and have transform map, field map etc
2) create a rest message to consume table API of instance A and once you get the records in response, insert data into staging table and transformation will start automatically
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-13-2023 12:48 AM
Hello,
I'm triyng to achieve the same thing using this method.
Can you explain how to do the step 2 that you describe with more details please?
thanks and regards