Reading first occurrence of the repeating element column from the JSON file
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.