topic Re: How to convert nested json array in collection to json in Digital Exchange

How to convert nested json array in collection to json

nanditaradhakrishna — Wed, 11 Mar 2026 06:01:40 GMT

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

Re: How to convert nested json array in collection to json

shashank.kumar280 — Wed, 11 Mar 2026 06:14:25 GMT

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

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

Re: How to convert nested json array in collection to json

nanditaradhakrishna — Wed, 11 Mar 2026 06:59:18 GMT

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.