How to load rest api response into import set table?

[nthumma]

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 · Accepted solution]

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

[nthumma]

@Pradeep_Sharma,

Thanks for quick response, I will try out above method and keep you posted.

Update: it's all working, Thanks again. 

Thanks,

[Pradeep Sharma]

You are very welcome. Thanks for participating in the community!

-Pradeep Sharma

[shellypoeckes]

I have the same question. I have the import set created per Pradeep instructions, but how did you get the REST API to put the JSON data into the import set so the transform map can process it?  Any help would be greatly appreciated.

Thanks.

Shelly