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 !