How to load rest api response into import set table?

nthumma · ‎07-19-2018

I have a requirement to a call a third party rest API and load the data into ServiceNow custom table.

Rest API returns bulk data.

I want to parse the data and load data into import sets table and run the transform maps to load the data to store in the actual table.

How do I create an import set table? and if I insert the data using GildeRecord API into import sets table would the transform map gets triggered?

Pradeep Sharma · ‎07-19-2018

Hello Nthumma,

You can create import set table web as mentioned in the below link.

https://docs.servicenow.com/bundle/jakarta-platform-administration/page/administer/import-sets/concept/c_CreatingANewWebService.html

To answer your second question, yes the transformation will kick off automatically the moment you insert a record in import set table via GlideRecord.

-Pradeep Sharma

View solution in original post

grr · ‎10-24-2019

Hello Shelly, Are you still facing this problem. If yes, I have a solution to a similar type of requirement. Pleaase let me know if you still need help on this question...

Arjun Yuva Teja · ‎06-04-2020

Hi,
Did this issue resolved.Anyone reply.I also have same question to get answered.Can anyone who knows it give me explanation ?

Thanks,

Arjun.

adwitiya · ‎02-07-2020

hello,

how to mak transform map kick automatically after the update on staging table?