You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Reading first occurrence of the repeating element column from the JSON file

Accepted answer


Hi Team,

I am trying to read a JSON file ( sample content pasted below ) via OIC. My requirement -

Pick the single/first occurrence of the repeating 'additionaldataelement' column from the JSON file (source) and put it in a single column in an ADW DB Table(target). We already have a For-each loop-based approach to read these repeating elements from the additionalDataElements column of the JSON File. But, we are looking for an easy alternate approach to read this column.

The main reason for looking for a different approach is because the Looping is causing performance issues while inserting the records to ADW DB table.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!