JSON roadblock

Hi Alex,
So sorry to reply off-thread, but newbie here - and I’ve run into a JSON roadblock. How or where can I post my question, please?
Thanks,
Chetan

Hi @Chetan,

Could you share screenshots of your Automations canvas and record a Loom of a sample run? Please include the Debugger in the recording so we can take a closer look at what might be causing the issue.

Resending:

Hi Alex,

I’m still in the process of making the agent, so I don’t have much of what you’ve asked,

But here’s where I’m getting stuck.

First thing: The Agent I’m making is on daily Air Quality Index (AQI) data that is released at around 4 pm, local time (I’m in India.)

The agent is meant to ask the user to input the city name for which they want the latest AQI data, and then provide this.

Then it should parse the URL for the daily AQI report. This URL is standard except for the date.

Original: https://cpcb.nic.in//upload/Downloads/AQI_Bulletin_20250710.pdf
What I’ve put in the Scrape Url block: https://cpcb.nic.in//upload/Downloads/AQI_Bulletin_{{date}}.pdf
The date is always in the YYYYMMDD format.

Where I’m stuck:

The daily URL has 5 column heads + 1 health advisory, linked to the AQI number or category, that I need for the output. And I need to create a JSON array for this.
Where and how do I do this?

City: {{city}}
AQI: {{AQI}} ({{category}})
Main Pollutant: {{main_pollutant}}
Health Advisory: {{health_advisory}}
Reporting Stations: {{stations_reporting}}
Date: {{today’s date}}

My question is- how do I go about this?

I’m building 2 workflows. The scarpeAQIurl is a workflow that can be used for multiple workflows eventually.

Thanks,
Chetan