insertMultiple REST API inserting empty records

Varun Monga · ‎06-01-2022

Unable to populate the staging table using InsertMultiple Import Set API.

Rows are generating in the table but no field is populating in the system

Chandu Telu · ‎06-02-2022

Hi,

As Tony said we need the details to the correct answer

Check the below link looks like it's similar issue

https://community.servicenow.com/community?id=community_question&sys_id=d416b7a01b3b3090d01143f6fe4bcbae

Please Mark the answer if correct/helpful , if it helps

Thanks

Chandu Telu

View solution in original post

Luke Turner1 · ‎11-25-2022

This link is now unavailable, does anyone know what the solution is or can link to another post, I feel like this is becoming an increasing issue on the community site.

Hugo14 · ‎01-12-2023

Had the same issue, but unlike the normal POST, the insertMultiple uses column labels instead of names in the JSON. By creating a record in sys_rest_insert_multiple this can be changed. The documentation mentions it, but it is easy to look over.

Community Alums · ‎02-08-2023

Thanks, this answer helped me. I created a record in the 'sys_rest_insert_multiple' table, and added a record to use the column name in the Column mappings related list

Omar Rahim1 · ‎04-23-2023

This worked for me also. Thanks.