Problem:
- I’m running an API to fetch a large JSON file cached on a server: https://data.vatsim.net/v3/vatsim-data.json
- Using a Custom Request (via Webhooks By Zapier) to GET the desired file, it fetches it, and natively decodes and groups the headers across the whole JSON into a single text string, as below:
- However, this removes the native grouping in the cached JSON;
- This causes an issue because I want to parse the data in a further step using AI to interpret and extract what I want. At present I can’t reference the entire collection as a single text response (formatted as above in the html version).
- Storing the result as a single variable would work, but I do not know how to do that (I’m a new user)
- Ideally, I’d like to only save the “Controllers” section (as below) of the JSON to then move on and parse, as the full file is approx. 66,000 lines. My aim is to parse the online ‘controllers’ taking their station callsign and frequency to use in a further step;
Thanks in advance :)