ImportSet REST API insertmultiple Creating Empty Records

[RahulY00040]

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 

[Kieran Anson · Accepted solution]

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

[RahulY00040]

Also, if I may ask...how to make this Import Set Asynchronous ? I set the entry as an Asynchronous but still its getting processed as soon as records get inserted.

Also, how do we run the transform maps against the Async Import Sets ?Any idea?

Thanks,
Rahul

[Kieran Anson]

By Async, SN is referring to the fact there is a scheduled job that will auto-process imported records. It'll do so against all active transform maps that are related to the import set. 

The scheduled runs frequently, so you're unlikely to see a delay in processing on a PDI/dev environment

[RahulY00040]

Hello @Kieran Anson , Is it processed by this job: Import Set Transformer Job ? If so, what this scheduled job Asynchronous Import Set Transformer does?

Thanks,
Rahul