Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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 !