Help with loop node

moshi · March 27, 2024, 5:08pm

I am looking to loop through each day one by one, but it outputs everything entirely. How would I fix this problem?

n8n · March 27, 2024, 5:08pm

It looks like your topic is missing some important information. Could you provide the following if applicable.

n8n version:
Database (default: SQLite):
n8n EXECUTIONS_PROCESS setting (default: own, main):
Running n8n via (Docker, npm, n8n cloud, desktop app):
Operating system:

moshi · March 27, 2024, 5:11pm

Just found the split node! It solves it!

liam · March 27, 2024, 5:30pm

remember to mark the post as solved, you can mark your own comment

liam · March 27, 2024, 5:33pm

Also! Sorry for double comment

You don’t need the loop over node. Nodes run once for each item by default. The Loop over items node is rarely actually needed

moshi · March 27, 2024, 6:27pm

Thank you for that! You just saved me a lot of headaches. Is there a way to reference the last item in an array?

I want to have an IF node that always checks the last item of an array: {{ $json.availableTimeSlotList }}

moshi · March 27, 2024, 6:32pm

I want to always check for the last “startTime” of a given day, and compare it with a value. Would I need a loop for that? @liam

[

{

“date”: “2024-04-09”,

“dayOfWeek”: “Tuesday”,

“isOpen”: true,

“availableTimeSlotList”: [

{

“startTime”: “2024-04-09T08:00:00”,

“endTime”: “2024-04-09T10:00:00”,

“dropOffTime”: “2024-04-09T07:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-09T09:00:00”,

“endTime”: “2024-04-09T11:00:00”,

“dropOffTime”: “2024-04-09T08:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-09T10:00:00”,

“endTime”: “2024-04-09T12:00:00”,

“dropOffTime”: “2024-04-09T09:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-09T13:00:00”,

“endTime”: “2024-04-09T15:00:00”,

“dropOffTime”: “2024-04-09T12:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-09T14:00:00”,

“endTime”: “2024-04-09T16:00:00”,

“dropOffTime”: “2024-04-09T13:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

}

]

},

{

“date”: “2024-04-10”,

“dayOfWeek”: “Wednesday”,

“isOpen”: true,

“availableTimeSlotList”: [

{

“startTime”: “2024-04-10T16:00:00”,

“endTime”: “2024-04-10T18:00:00”,

“dropOffTime”: “2024-04-10T15:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d76028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-10T17:00:00”,

“endTime”: “2024-04-10T19:00:00”,

“dropOffTime”: “2024-04-10T16:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d76028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-10T18:00:00”,

“endTime”: “2024-04-10T20:00:00”,

“dropOffTime”: “2024-04-10T17:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d76028dd-453a-ed11-8103-0050569839a7”

}

]

},

{

“date”: “2024-04-16”,

“dayOfWeek”: “Tuesday”,

“isOpen”: true,

“availableTimeSlotList”: [

{

“startTime”: “2024-04-16T08:00:00”,

“endTime”: “2024-04-16T10:00:00”,

“dropOffTime”: “2024-04-16T07:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-16T09:00:00”,

“endTime”: “2024-04-16T11:00:00”,

“dropOffTime”: “2024-04-16T08:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-16T10:00:00”,

“endTime”: “2024-04-16T12:00:00”,

“dropOffTime”: “2024-04-16T09:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-16T13:00:00”,

“endTime”: “2024-04-16T15:00:00”,

“dropOffTime”: “2024-04-16T12:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-16T14:00:00”,

“endTime”: “2024-04-16T16:00:00”,

“dropOffTime”: “2024-04-16T13:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

}

]

},

{

“date”: “2024-04-17”,

“dayOfWeek”: “Wednesday”,

“isOpen”: true,

“availableTimeSlotList”: [

{

“startTime”: “2024-04-17T08:00:00”,

“endTime”: “2024-04-17T10:00:00”,

“dropOffTime”: “2024-04-17T07:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-17T09:00:00”,

“endTime”: “2024-04-17T11:00:00”,

“dropOffTime”: “2024-04-17T08:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-17T10:00:00”,

“endTime”: “2024-04-17T12:00:00”,

“dropOffTime”: “2024-04-17T09:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-17T13:00:00”,

“endTime”: “2024-04-17T15:00:00”,

“dropOffTime”: “2024-04-17T12:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-17T14:00:00”,

“endTime”: “2024-04-17T16:00:00”,

“dropOffTime”: “2024-04-17T13:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-17T15:00:00”,

“endTime”: “2024-04-17T17:00:00”,

“dropOffTime”: “2024-04-17T14:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d86028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-17T16:00:00”,

“endTime”: “2024-04-17T18:00:00”,

“dropOffTime”: “2024-04-17T15:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d86028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-17T17:00:00”,

“endTime”: “2024-04-17T19:00:00”,

“dropOffTime”: “2024-04-17T16:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d76028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-17T18:00:00”,

“endTime”: “2024-04-17T20:00:00”,

“dropOffTime”: “2024-04-17T17:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d76028dd-453a-ed11-8103-0050569839a7”

}

]

},

{

“date”: “2024-04-18”,

“dayOfWeek”: “Thursday”,

“isOpen”: true,

“availableTimeSlotList”: [

{

“startTime”: “2024-04-18T08:00:00”,

“endTime”: “2024-04-18T10:00:00”,

“dropOffTime”: “2024-04-18T07:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-18T09:00:00”,

“endTime”: “2024-04-18T11:00:00”,

“dropOffTime”: “2024-04-18T08:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-18T10:00:00”,

“endTime”: “2024-04-18T12:00:00”,

“dropOffTime”: “2024-04-18T09:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-18T13:00:00”,

“endTime”: “2024-04-18T15:00:00”,

“dropOffTime”: “2024-04-18T12:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-18T14:00:00”,

“endTime”: “2024-04-18T16:00:00”,

“dropOffTime”: “2024-04-18T13:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

}

]

},

{

“date”: “2024-04-19”,

“dayOfWeek”: “Friday”,

“isOpen”: true,

“availableTimeSlotList”: [

{

“startTime”: “2024-04-19T16:00:00”,

“endTime”: “2024-04-19T18:00:00”,

“dropOffTime”: “2024-04-19T15:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d76028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-19T17:00:00”,

“endTime”: “2024-04-19T19:00:00”,

“dropOffTime”: “2024-04-19T16:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d76028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-19T18:00:00”,

“endTime”: “2024-04-19T20:00:00”,

“dropOffTime”: “2024-04-19T17:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d76028dd-453a-ed11-8103-0050569839a7”

}

]

},

{

“date”: “2024-04-20”,

“dayOfWeek”: “Saturday”,

“isOpen”: true,

“availableTimeSlotList”: [

{

“startTime”: “2024-04-20T08:00:00”,

“endTime”: “2024-04-20T10:00:00”,

“dropOffTime”: “2024-04-20T07:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d86028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-20T09:00:00”,

“endTime”: “2024-04-20T11:00:00”,

“dropOffTime”: “2024-04-20T08:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d86028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-20T10:00:00”,

“endTime”: “2024-04-20T12:00:00”,

“dropOffTime”: “2024-04-20T09:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d86028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-20T13:00:00”,

“endTime”: “2024-04-20T15:00:00”,

“dropOffTime”: “2024-04-20T12:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d86028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-20T14:00:00”,

“endTime”: “2024-04-20T16:00:00”,

“dropOffTime”: “2024-04-20T13:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d86028dd-453a-ed11-8103-0050569839a7”

}

]

},

{

“date”: “2024-04-21”,

“dayOfWeek”: “Sunday”,

“isOpen”: true,

“availableTimeSlotList”: [

{

“startTime”: “2024-04-21T09:00:00”,

“endTime”: “2024-04-21T11:00:00”,

“dropOffTime”: “2024-04-21T08:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d86028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-21T10:00:00”,

“endTime”: “2024-04-21T12:00:00”,

“dropOffTime”: “2024-04-21T09:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d86028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-21T13:00:00”,

“endTime”: “2024-04-21T15:00:00”,

“dropOffTime”: “2024-04-21T12:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d86028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-21T14:00:00”,

“endTime”: “2024-04-21T16:00:00”,

“dropOffTime”: “2024-04-21T13:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d86028dd-453a-ed11-8103-0050569839a7”

}

]

},

{

“date”: “2024-04-22”,

“dayOfWeek”: “Monday”,

“isOpen”: true,

“availableTimeSlotList”: [

{

“startTime”: “2024-04-22T08:00:00”,

“endTime”: “2024-04-22T10:00:00”,

“dropOffTime”: “2024-04-22T07:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-22T09:00:00”,

“endTime”: “2024-04-22T11:00:00”,

“dropOffTime”: “2024-04-22T08:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-22T10:00:00”,

“endTime”: “2024-04-22T12:00:00”,

“dropOffTime”: “2024-04-22T09:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-22T13:00:00”,

“endTime”: “2024-04-22T15:00:00”,

“dropOffTime”: “2024-04-22T12:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-22T14:00:00”,

“endTime”: “2024-04-22T16:00:00”,

“dropOffTime”: “2024-04-22T13:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

}

]

},

{

“date”: “2024-04-23”,

“dayOfWeek”: “Tuesday”,

“isOpen”: true,

“availableTimeSlotList”: [

{

“startTime”: “2024-04-23T08:00:00”,

“endTime”: “2024-04-23T10:00:00”,

“dropOffTime”: “2024-04-23T07:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-23T09:00:00”,

“endTime”: “2024-04-23T11:00:00”,

“dropOffTime”: “2024-04-23T08:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-23T10:00:00”,

“endTime”: “2024-04-23T12:00:00”,

“dropOffTime”: “2024-04-23T09:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-23T13:00:00”,

“endTime”: “2024-04-23T15:00:00”,

“dropOffTime”: “2024-04-23T12:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

},

{

“startTime”: “2024-04-23T14:00:00”,

“endTime”: “2024-04-23T16:00:00”,

“dropOffTime”: “2024-04-23T13:45:00”,

“pickUpTime”: “”,

“bayGuid”: “d66028dd-453a-ed11-8103-0050569839a7”

}

]

}

]

moshi · March 27, 2024, 6:36pm

I added a loop node after the switch node to loop through each day, now I just need a way to check for the last item in the array. When I copy the item path I get - {{ $json[“availableTimeSlotList”][“4”][“startTime”] }}

The problem is that it won’t always be index “4” everytime.

Is there a way to change it to something like {{ $json[“availableTimeSlotList”][“last-item”][“startTime”] }}

liam · March 27, 2024, 6:41pm

Very easy!

try this {{ $json[“availableTimeSlotList”].last()[“startTime”] }}

.last() is an array methof to get the last item.

If you want to share your workflow i can look over the whole thing

just highlight the entire workflow and copy and paste the code as shown below with the tick marks `

```
paste your workflow code here
```

moshi · March 27, 2024, 6:53pm

I’m having trouble getting the last item still, I pasted the workflow below. Thanks for your help Liam

UXcfV2vAao2KE9Nm

I don’t think I did that right, where do I get the workflow code?

liam · March 27, 2024, 8:26pm

Please see this video

moshi · March 30, 2024, 3:09pm

Wow! I had no idea you could do that. Thank you so much! I actually ended up solving the issue, that you so much for your help @Liam .

Random question, what video editing software did you use for that video? I loved how it zoomed in and out, super cool.

liam · March 31, 2024, 2:59pm

It’s called screen studio

system · April 7, 2024, 3:00pm

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.