How to use Import Set API to Transform Data
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2025 02:58 AM - edited 02-06-2025 03:53 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2025 03:30 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2025 03:52 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2025 03:42 AM
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
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-06-2025 03:50 AM
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader