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

Hi, I'm having a few issues getting an expression which can obtain data from a 2nd tier of nested objects.
Essentially I have a collection of "Parents" where the data for children can be described using ad-hoc data structure as:

= {
{
ParentName: "Amanda",
children: {
{
Child: {
ChildName: "Emma"
}
},
{
Child: {
ChildName: "Abi"
}
}
}
},
{
ParentName: "Kyle",
children: {
{
Child: {
ChildName: "Ethan"
}
}
}
}
}

What I'm after is an array of text values for all the ChildNames - but I can't seem to make use of the apply, merge or union functions to achieve this. Any Ideas?...

OriginalPostID-124332

OriginalPostID-124332