JSON file import to ServiceNow

[askari125]

Hi Everybody,

I have requirement regarding JSON File Import in ServiceNow.

The file is exported from AWS. And its all about EC2.

Please suggest me a solution to import a file in ServiceNow, it can be that JSON file can be inserted into Mid Server and from there the data can be fetched into ServiceNow.

Please give me a solution to this.

Thank you.

Kind Regards.

#JSON #Import

[Dave Oshinsky]

You can try Import Set API insertMultiple:

Import Set API | ServiceNow Developers

There is another variant of Import Set API that can import only one row per REST call, and Table API can also only POST one row per REST call. For my application, inserting one row per REST call would be much too slow.

Regarding Import Set API insertMultiple, it is not well documented IMHO. For example, this excellent post fills in a lot of details:

insertMultiple Import set API - ServiceNow Community

I'm having a LOT of trouble using insertMultiple to insert multiple JSON rows, and you may find the same thing when you try to use it. I've recently posted multiple queries about the problems I'm having using insertMultiple:

blank fields imported Import Set insertMultiple - ServiceNow Community

how can a program create a staging table for impor... - ServiceNow Community

difficulty running Import Set insertMultiple REST ... - ServiceNow Community

So far, the more details questions about insertMultiple haven't been getting replies. Perhaps you'll have better luck.