I have an issue with an automation. I want to filter the data retrieved from the “HTTP” module and then associate two data points (URL and the corresponding city) for later use.
From the HTTP module, I parse the JSON to get structured data. Then, I set the variables I’m interested in: “City” and “URL”. After that, I use an iterator and an aggregator, followed by a filter on the desired city before sending the data to a Google Sheet.
I am able to get only the desired city. However, the URL is incorrect.
For example, if the data looks like this:
London | URL 1
London | URL 2
Leeds | URL 3
At the end, if I want to get “Leeds” in the sheet, I would get Leeds | URL 1.
So, I am getting the URL in the order of the data’s appearance, not connected to the city filter at all.
In the HTTP module, I receive events that include “City” and “URL”. In each call to the module, I receive about 500 events, each with a city name and a URL.
I want to filter these events to only get those from a specific city like “London” and retrieve the associated URL for each London event, which are different.
It seems that in your example, I need to know the URL to filter