Hi there! I’ve got an HTTP request downloading a JSON file and parsing it into an Excel table on a regular basis. However, the data is not filtered in the JSON, so a recurring task would just re-add the same entries to the end of the file forever, leaving me stuck.
Today, I’m pulling the JSON in via an HTTP request, pushing it into an Arragy aggregator, then pulling in the Excel worksheet rows into an Array aggregator so I have both datasets. I’ve attempted to filter the data from there before it goes into an Iterator where the field “id” matches the arrate of ID in the rows of the Excel file. Then the iterator creates the worksheet rows in Excel as planned.
When I filter, I’ve created one where the JSON aggregator value of the field “id” does not contain (array type) the value of field “ID” in the Excel rows (see below).
Running the setup this way results in 0 every time I run, with the following display.
If I hover over the left side of the bundle, it shows the ID of the first JSON result. If I hover over the right side it shows {collection] in the tooptip.
Am I missing something here?