question Re: How to load rest api response into import set table? in Developer forum

How to load rest api response into import set table?

nthumma — Thu, 19 Jul 2018 16:02:33 GMT

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?

Re: How to load rest api response into import set table?

Pradeep Sharma — Thu, 19 Jul 2018 16:07:50 GMT

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

Re: How to load rest api response into import set table?

nthumma — Thu, 19 Jul 2018 16:21:27 GMT

@Pradeep_Sharma,

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

Update: it's all working, Thanks again.

Thanks,

Re: How to load rest api response into import set table?

Pradeep Sharma — Thu, 19 Jul 2018 16:53:01 GMT

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

-Pradeep Sharma

Re: How to load rest api response into import set table?

shellypoeckes — Wed, 11 Sep 2019 20:14:15 GMT

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

Re: How to load rest api response into import set table?

grr — Thu, 24 Oct 2019 11:27:45 GMT

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...

Re: How to load rest api response into import set table?

adwitiya — Fri, 07 Feb 2020 11:09:06 GMT

hello,

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

Re: How to load rest api response into import set table?

Arjun Yuva Teja — Fri, 05 Jun 2020 06:36:58 GMT

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.