How to convert nested json array in collection to json

[nanditaradhakrishna]

Hi,

I have a requirement to convert nested Json array in collection to Json,

I have attached the reference collection image,

I need to convert the nested JSON arrays into a flat structure so that all nested elements are stored in one collection. So, I can convert the collection to Json to push to elastic index.

Storing individually is time consuming where I have more data,

Kindly suggest solution to achieve this.

Thanks,

Nandita

[shashank.kumar280]

You can consider using the JSON utility available on DX to convert the nested json into collection

https://digitalexchange.blueprism.com/cardDetails?id=115182

[nanditaradhakrishna]

Hi shashank.kumar28,

Thank you for replying, I have used this, but this will only convert outer Array to collection, but again there are multiple array's within the collection (Action: json to collection (skipping array)) is converting the outer array to collection.