Selecting columns from the payload dynamically

[darshthakkar]

Hi Team,

I’m uncertain of the no. of columns in the payload that I would be receiving from upstream system, how can I ensure that I’m fetching all those columns dynamically? Rationale behind this is that I need to ingest this dynamic payload into a database so fixing a structure in snapLogic (using mapper snap) and creating a table in my database wouldn’t help.

For instance, in today’s payload, I have 10 columns, tomorrow it may be 12, day after tomorrow it may be 8 so how can I handle this dynamic behavior?

Thanking in advance for your inputs.

Regards,
Darsh

[darshthakkar · Accepted solution]

Tested with a sample file and with the mapper settings as below:

Closing this thread as the solution worked.