Iterating JSON response which has nested depths. - CIS Studio 7.0.04

[devendra sanepai]

Hi,

Our requirment is to call one external API that will send an JSON response in a tree strcture from Composite tool and parse this response to check if there are more records and then it in loop until no records returned.

We need to hold the data until the total count is reached.

extract the elements only that need(these elements will have one-may relationship) as well

I found JSON_TABLE works butfor one level but not nested depth like, customer.account.identifier.

Is there any we can handle this in composite tool

Appreciate your help!

Thanks,

Devendra.