Access Nested Array

I’m trying to access the data of a nested array that looks like this:

I want to access the PhoneNumber array. I’ve tried both via a function node and itemlist node, but am struggling to figure out how to access that nested array. Thanks in advance! - Jon

Figured this out, here’s how I got it to work using multiple ItemList nodes in case someone has a similar data structure in the future. Also to note, I had to add the option Explicit Root for the XML to JSON node and leave it disabled, otherwise the next node to aggregate items fails.

First, AggregateItems ItemList Node

Then SplitItems ItemList Node
SplitOutItems

Now we are able to access that nested array. Another SplitItems ItemList Node

1 Like