ServiceNow Integration to pull the data from one instance to another instance using Rest Api Explore

Anshul12
Tera Contributor

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.

Anshul12_0-1684911662527.png

 

 

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.

Anshul12_1-1684911662533.png

 

 

 

@shloke04  @Ankur Bawiskar 

2 REPLIES 2

Ankur Bawiskar
Tera Patron
Tera Patron

@Anshul12 

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

 

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

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