Hi, I'm having a few issues getting an expression which can obtain data from

Jarrod,

Try using the index function, for your example above it would look like this:

index(index(index(index(local!data, 1,""), "children", ""), "Child", ""), "ChildName"))

Here is an example you can try in the expression editor:

with(
local!data: {
{
ParentName: "Amanda",
children: {
{
Child: {
ChildName: "Emma"
}
},
{
Child: {
ChildName: "Abi"
}
}
}
},
{
ParentName: "Kyle",
children: {
{
Child: {
ChildName: "Ethan"
}
}
}
}
},
index(index(index(index(local!data, 1,""), "children", ""), "Child", ""), "ChildName")
)

Thats only returning Emma and Abi, its not picking up Ethan from the second parent in the collection - I was hoping to get Emma, Abi, Ethan returned as the one collection.

To do that you will need two rules. The inner rule will put out the child names from each parent and the outer rule will apply that inner rule to each parent. It will look like this:

***PARENT RULE***

with(
local!data: {
{
ParentName: "Amanda",
children: {
{
Child: {
ChildName: "Emma"
}
},
{
Child: {
ChildName: "Abi"
}
}
}
},
{
ParentName: "Kyle",
children: {
{
Child: {
ChildName: "Ethan"
}
}
}
}
},
apply(
rule!Child_Rule,
enumerate(length(local!data)) + 1,
local!data
)
)


***CHILD RULE***

Inputs:

index (int)
data (any type)

index(index(index(index(ri!data, ri!index,""), "children", ""), "Child", ""), "ChildName")

ok great thats working, thanks for your help Michael!