Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Reading first occurrence of the repeating element column from the JSON file — Cloud Customer Connect
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
41
Views
10
Comments

Summary:

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.

Register

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