Mapping Nested Arrays inside Nested Arrays on date field

[Gary_H]

Hello, I’m trying to automate a data pull from an API endpoint and the data format is as follows. as you can see I have multiple nested arrays and I will be pulling thousands of these (potentially) per day. Each call log in an entry under data and then each seperate note is in a nested array in notes. I need to map AssignedTo and CustomerNumber from the first array and then the reason and employeeID for just yesterday’s note from the nested array. I can’t seem to get the map() function to do this. Any help would be appreciated.

{{map(51.data; “AssignedTo”)}} works, so does {{map(51.data; “CustomerNumber”)}}. but when I try to pull the note data everything gopes wrong. I need to minimize the operations limit on these as I can’t throw thousands of operations at one data pull every day.

“data”: [
{
“ID”: ,
“CustomerNumber”: 123456789,
“EnterDate”: “2025-06-09T13:30:00”,
“DueDate”: “2025-06-09T00:00:00”,
“Resolved”: false,
“Viewed”: true,
“AlarmSet”: false,
“Name”: “”,
“Company”: “”,
“Phone”: “”,
“Status”: “1 Call Returned, No Answer”,
“EnteredBy”: " ",
“AssignedTo”: "Employee Call Log ",
“notes”: [
{
“id”: ,
“headerID”: ,
“date”: “2025-06-09T13:30:00”,
“reason”: " Sold ",
“note”: " ",
“employeeID”: “EmpID”
},
{
“id”: ,
“headerID”: ,
“date”: “2025-07-09T13:52:13”,
“reason”: " ",
“note”: " ",
“employeeID”: " "
}
],
“CallTopic”: [
“Upsell Campaign”
]
}
]

[Stoyan_Vatov]

Hey Gary,

what are you trying to pull from the Notes? Can you show screenshots of your setup and which step you are struggling with?

[Gary_H]

I’m trying to pull employeeID and reason from the note who’s date matches yesterday.

So far I have a set multiple variable node mapping CustomerNumber and AssignedTo already. That worked well. I can’t provide any sensitive data like customer info or our notes as this is to keep tabs of upsell attempts from our sales department. I was able to get the info with iterators, but my operation count ballooned out of control. I will be running this on a repeat through 8 different databases and probably receive a thousand call log entries or more from each one.

[Gary_H]

I tried to map the notes array like this

All the results are empty

I also tried to grab just the notes entry with yesterday’s date.

and I get this error:
Failed to map ‘2.value’: Function ‘map’ finished with error! Function ‘formatDate’ finished with error! ‘notes.date’ is not a valid date.