Need to get the existing records of a table from one instance to other using integration

[Bruce lee]

Hi,

Need to get the existing records of a table from one instance to other using integration

[Dipen Wadhwana]

Hi @Bruce lee ,

migrating records from one ServiceNow instance to another through integration. Here’s a breakdown of the methods you can use:

Import Set Table:
Export records from the source instance into a CSV file.
In the target instance, utilize the Import Set Table feature to bring in the records from the CSV file. This feature allows you to stage records before integration, providing validation and transformation capabilities.
REST API:
Develop a script or application to interact with the ServiceNow REST API.
Retrieve records from the source instance using the API.
Transmit the retrieved records to the target instance by making REST API calls to create or update records as needed.
Scripted Web Services:
Within the source instance, establish a Scripted Web Service to expose the desired records.
In the target instance, develop a client-side script or application to consume this web service.
Utilize the web service endpoint to retrieve records from the source instance and create corresponding records in the target instance.
These methods provide flexibility and efficiency for integrating data between ServiceNow instances

[Community Alums]

Hi @Bruce lee ,

You can do this on your Source instance 

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

Also, follow this article : https://www.servicenow.com/community/now-platform-articles/data-integrations-from-and-to-servicenow-...

[dgarad]

Hi @Bruce lee 

Please refer below link

https://www.servicenow.com/community/developer-articles/ebonding-servicenow/ta-p/2312922

[Tai Vu]

Hi @Bruce lee 

You can utilize the OOTB Table API to pull data from a specific table in an instance.

The Table API provides endpoints that allow you to perform create, read, update, and delete (CRUD) operations on existing tables.

Cheers,

Tai Vu