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}.

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

I'd like to correct my previous message. The endpoint I want to use is Import Set - POST /now/import/{stagingTableName}/insertMultiple.

View solution in original post

2 REPLIES 2

Tetsuya3
Tera Guru

I'd like to correct my previous message. The endpoint I want to use is Import Set - POST /now/import/{stagingTableName}/insertMultiple.

Tetsuya3
Tera Guru

I'm opening a new thread for this question as the details in my previous post were inaccurate.