Get a first look at what's coming. The Developer Passport Australia Release Preview kicks off March 12. Dive in! 

How to Configure Staging Table When Setting Up Import Set API

Tetsuya3
Tera Guru

Hi,

 

I would like to use the Import Set API - POST /now/import/{stagingTableName}/insertMultiple.
https://www.servicenow.com/docs/r/en-US/washingtondc/api-reference/rest-apis/c_ImportSetAPI.html

However, I'm having trouble understanding how to configure the data source. I've been trying to figure it out through trial and error, but the JSON fields are not being mapped to the staging table columns properly, and I'm stuck.
Could you please advise how to configure this correctly?
For your reference, I've attached the current data source configuration I'm working with.

 

Thank you for your assistance.

 

Tetsuya

1 ACCEPTED SOLUTION

Tetsuya3
Tera Guru
 

 Resolved: I figured it out on my own. The solution was to match the JSON data field names with the staging table labels (column labels), and then it worked successfully.
Sorry for the trouble, and thank you for your attention.

View solution in original post

1 REPLY 1

Tetsuya3
Tera Guru
 

 Resolved: I figured it out on my own. The solution was to match the JSON data field names with the staging table labels (column labels), and then it worked successfully.
Sorry for the trouble, and thank you for your attention.