I’m running into an issue with a scenario in Make where I fetch a list of receivable accounts from Bling’s API. The API response contains a data array, and I use an Iterator to go through each item. Each item is then passed to a Parse JSON module to extract fields like id, value, etc.
The flow is structured like this:
HTTP (GET from Bling) → Iterator (data) → Parse JSON → Filter (id > lastId from Data Store)
The problem is that the filter only seems to evaluate the first item in the list, even after going through the Iterator and JSON parsing. It’s not correctly applying the condition id > lastId on each item individually.
I have the last receivable account with an Id greather than the Id in the data store, but the filter consider only the first receivable account and ignores the rest (Others)
In the Parse JSON, I’m setting the source as the Value from the Iterator and generating the structure using a single-item JSON (not an array). However, in the filter, the mapped field still appears as data.id, and it ends up evaluating id = 22455xxxxx instead of 22881xxxxx, which is the newest item.
What I’m trying to achieve:
I need the filter to properly compare the id of each individual item against the lastId saved in the Data Store, and only allow new entries to pass.
It would have been easier to use a webhook, but Bling (the erp tha im fetching data from) does not allow creation of webhook.
Question:
Has anyone faced this issue before?
How can I make sure the filter uses the parsed field id from each item (not data.id)?
Any insight or workaround is greatly appreciated!