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

[String]

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]

Hi,

Scripted REST API is created in ServiceNow and it will be consumed by 3rd party API.

In that you can create record in import set staging table so that the transformation beings automatically

Regards
Ankur

[String]

okay, but my requirement is, we have to hit the 3rd party API.So we can also phase the response JSON and insert that info(a record) into the staging table. So that it automatically inserts into the respective table. Is my understanding right?

[Ankur Bawiskar · Accepted solution]

@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

[String]

Thanks @Ankur Bawiskar