Built something you're proud of? Tell the story. A quick G2 review of App Engine or Build Agent helps other developers see what's possible on ServiceNow. Share your experience.

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.