Array within an array

Questions
1

:bullseye: What is your goal?

I have an array (Events) that is returned with multiple arrays (eventFields) which contain various information. One of the elements is logTime. I am wanting to fine the latest logtime to see the last date and time. I have created an iterator that reads the events array followed by another iterator to pull out the evenFields. This returns 19 bundles. I have also tried to put an array aggregator after the iterator to pull out the logTimes but it still returns 19 bundles. How can I find the latest date.

:thinking: What is the problem & what have you tried?

I have tried an array aggregator and also a text aggregator, but it still returns 19 bundles.

:clipboard: Error messages or input/output bundles

[
{
“body”: {
“Events”: [
{
“eventFields”: [
{
“name”: “logTime”,
“value”: “2026-02-09T19:18:19.6029086Z”
},
{
“name”: “Source”,
“value”: “api”
},
{
“name”: “Action”,
“value”: “Registered”
},
{
“name”: “Language”,
“value”: “english”
}
]
},
{
“eventFields”: [
{
“name”: “logTime”,
“value”: “2026-02-09T19:18:25.8048997Z”
},
{
“name”: “Source”,
“value”: “api”
},
{
“name”: “Action”,
“value”: “Sent Invitations”
},
{
“name”: “Language”,
“value”: “english”
}
]
},
{
“eventFields”: [
{
“name”: “logTime”,
“value”: “2026-02-09T19:27:41.6969351Z”
},
{
“name”: “Source”,
“value”: “web”
},
{
“name”: “Language”,
“value”: “english (us)”
}
]
},

3

Hey Steve,

you don’t need iterators or aggregators to pull a specific item from an array, you need a map() function. This one to be precise:

{{first(map(first(map(1.body.Events; "eventFields")); "value"; "name"; "logTime"))}}

just replace 1.body.Events with your specific Events array.

4

Thank you!!! That worked