How to use Import Set API to Transform Data

Meloper
Kilo Sage

Hi,

i know how to write Datas in the Staging Table.

But what Endpoint do i need to call to Transform the Data?
What Roles need the User which is calling the API?

 

After writing the Data in the Staging Table ein get the response of the Import set right?
Whats next?


I have existing data sources and would like to keep the logic of the existing transform maps and especially the import set table

5 REPLIES 5

Viraj Hudlikar
Tera Sage

Hello @Meloper 

Check this video - https://youtu.be/XM6DWMu2jA8?si=MyaQ_5MTdDx1Jr5C

Check this article - Import Set API - Goodbye SRAPIs? - ServiceNow Community

https://www.servicenow.com/docs/csh?topicname=c_ImportDataUsingImportSets.html&version=latest

 

If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.

 

Thanks & Regards
Viraj Hudlikar.

Setup an ServiceNow inbound integration using the import set API. In this video we look at how to create an inbound web service, import set, transform map and map the fields to our target table in order to use REST POST to update an incident from a 3d party system. We then use the REST API ...

Thank you, my question was poorly described...
I have existing data sources and would like to keep the logic of the existing transform maps and especially the import set table

Ankur Bawiskar
Tera Patron
Tera Patron

@Meloper 

the endpoint will be staging table's endpoint

The API user you share with 3rd party should have import_admin role in ServiceNow instance

everything is explained here

Import Set API 

Using Import Sets for REST Integration in ServiceNow 

#3 Rest Inbound Integration| Import Set API - ServiceNow Integration with 3rd Party tool using Rest 

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

@Meloper 

Thank you for marking my response as helpful.

If my response helped please mark it correct and close the thread so that it benefits future readers.

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