Insert data into servicenow table from a Rest call via flow designer to a 3rd party Application

[Rochel hans]

Hello Team,

@Chuck Tomasi @Ankur Bawiskar 

We want to do a "GET" call from flow designer's REST to a 3rd party tool to extract data , process and then insert the same into servicenow.

What's the best way to do this , either save the response as an attachment and do via import set's or use the "script" step on flow designer.

Kindly guide with a sample script.

Regards

Rochel Hans

[Hitoshi Ozawa]

BTW, if the response is large, paging would also be necessary to get the response into a import set table via REST API.

[Hitoshi Ozawa]

Hi again,

When using import set, Integration Hub may be used to save the data into the import set table or the script I've provided may be used to save the data into the import set instead of directly inserting into the target table.

 Once the records are inserted into the import set table, transformation map and coalesce can executed to insert into the ServiceNow target table.

Followings are documentation on import set. Check "ServiceNow REST (Integration Hub).

Integration Hub would require a different license but make it easier for non-programmer to set up and maintain.

https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/administer/import-set...

https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/administer/import-set...

[Rochel hans]

hello Hitoshi , 

thanks for the response .

IT worked.

Regards

Rochel

[Ankur Bawiskar]

Hi,

it all depends on how you get the response

You can use script step to parse the response and insert data into your target table

OR

If you are receiving huge response then I would suggest to use import set staging table, transform map, field map etc

Once you insert record into staging table the transformation would run in background.

Regards
Ankur

[Rochel hans]

hello Ankur , 

Thanks for quick response , we are getting response in JSON format .

We have not used the 2nd option could you suggest how the flow or action might look like if we could test this method.?

Regards,

Rochel Hans