Hi everyone,
I’m receiving the following collection from an incoming webhook:
[
{
"Contact": "Test Person",
"Value": "€ 3,000",
"Terms": "3",
"Email": "info@test.nl",
"Date": "2025-06-27 12:53"
}
]
What I’m trying to achieve is to automatically generate a new array of collections based on the number of installments (Term) and split the total amount (Value) evenly across those terms. Additionally, each installment should be assigned a date — recurring monthly from the original date provided.
Here’s an example of the desired output:
[
{
"Term": [
{
"Contact": "Test Person",
"Value": "€ 1,000",
"Email": "info@test.nl",
"Date": "2025-06-27 00:00"
},
{
"Contact": "Test Person",
"Value": "€ 1,000",
"Email": "info@test.nl",
"Date": "2025-07-27 00:00"
},
{
"Contact": "Test Person",
"Value": "€ 1,000",
"Email": "info@test.nl",
"Date": "2025-08-27 00:00"
}
]
}
]
If, for example, the total value is €12,000 and the terms are 12, then I would expect 12 monthly entries of €1,000 each, with the date increasing by one month per entry.
I’ve tried several approaches using Iterators, Aggregators, and Set Variable modules in Make, but I haven’t been able to get it to work properly. I’ve been stuck on this for a few days now and starting to wonder if it’s even possible with the tools in Make.
If anyone could point me in the right direction (or share a working example or blueprint), I’d really appreciate it!
Thanks so much in advance