how to use Scripted API and import set API in one integration

String · ‎01-18-2021

Hi Team,

we are using scripted API to hit the endpoint of 3rd party, after we catch the response from 3rd party, we have to send that response JSON to import set API and in import set API will parse that JSON parameter(ON before script) and insert it into respective tables(Mapping table). So can we use scripted API to extends the import set API..?

Please guide me

Ankur Bawiskar · ‎01-18-2021

@String

So you will have to use this

1) Create REST Message to consume the 3rd party endpoint

2) Consume it via daily schedule job etc

3) you will get the response in JSON and then parse it and insert row in staging table so that the transform beging

Regards
Ankur

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

View solution in original post

Pratima G · ‎09-11-2023

Hi @Ankur Bawiskar ,

Instead of having a scheduled job, what if we call the api from onBefore transform script and insert/update the records in staging table depending on the response that we received..
Can you help me with the required script that we can write in the tranform script ?

Ankur Bawiskar · ‎01-18-2021

Hi,

Mostly used in this scenario

1) 3rd party wants to send data in chunks and you want to load that by inserting into staging table

Regards
Ankur

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