Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

ImportSet REST API insertmultiple Creating Empty Records

RahulY00040
Tera Contributor

Hello team, 

 

I have created a simple staging table in PDI with single column as u_name. When I am trying insertMultiple against the staging table, its creating empty records. Does anyone have tested? Can share sample input?

 

Thanks,
Rahul 

1 ACCEPTED SOLUTION

Kieran Anson
Kilo Patron

Hi Rahul,

One step people often skip is creating a record in sys_rest_insert_multiple to inform the system on whether the incoming keys of the payload are field names or field labels.

 

Create a record in sys_rest_insert_multiple for your import set table, and then an entry in the related list for column mapping

View solution in original post

5 REPLIES 5

RahulY00040
Tera Contributor

Thanks @Kieran Anson I missed that too. Appreciate your help and have a Happy New Year !