Workflow Loop node: Grouping batches

[JuNijland]

1. My goal: Query 10k records from DB, group in batches of 100 for API batch insert.
2. Issue: How do I group all records in ‘one batch’, so I can aggregate these before inserting them in HubSpot via API call? I would expect to either have access to an array values or to have some kind of aggregation node that I can use to combine multiple values.
3. Steps I've taken to troubleshoot: I can only access a single ‘value’ in a function
4. Additional info: Cloud

[Tobias_Sell]

You can use a js codeblock to create batches and then loop with the hubspot query:

function chunkArray(array, size = 100) {
return array.reduce((acc, _, index) => {
if (index % size === 0) {
acc.push(array.slice(index, index + size));
}
return acc;
}, [] );
}