Rest API Explorer - Insert multiple records

[Andr_1]

Hello.

I am testing the insert multiple records on the Rest API Explorer module.

with this body

{
"records":[
{"u_code":"1","u_external_id":"1","u_opco_name":"test"},
{"u_code":"2","u_external_id":"2","u_opco_name":"test2"},
{"u_code":"3","u_external_id":"3","u_opco_name":"test3"},
{"u_code":"4","u_external_id":"4","u_opco_name":"test4"},
{"u_code":"5","u_external_id":"5","u_opco_name":"test5"},
{"u_code":"6","u_external_id":"6","u_opco_name":"test6"},
{"u_code":"7","u_external_id":"7","u_opco_name":"test7"}
]
}

And it is working well:

But when I try the same thing on postman... it inserts empty fields on my staging table

Can someone help me please?

Thank you

André Ramos

[tharun_kumar_m]

Hi Andr,

Please check if the integration user has necessary permissions to write on the table and record (please check the role of user and ACL of these fields and table).

If you didn't find any issue there, please check the KB article - https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0596738 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumbs up.

Best regards,

Tharun Kumar

[Andr_1]

hi @tharun_kumar_m 

I checked the ACL and user permission and everything looks normal

Regards,

André Ramos