WeatherAPI extraction issue

[trhaseeb]

Hello Everyone, First time asking a question.

So I am using weatherAPI to extract Date/Time and Precipitation in Inches).

The link works, Date/Time is extracted with no issues, but Precipitation gives me the error that table is not found. I have tried everything, and Im at my wits end.

location.localtime, gives me localtime

location.name. give me the name

forecast.forecastday gives me an empty 'list', doesnt work as text

forecast.forecastday.0.day.totalprecip_in doesnt work.

forecast.forecastday.1.day.totalprecip_in doesnt work.

Would love it if someone can point me in the right direction.

here is a screenshot of the JSON

[Suvrutt_Gurjar]

Please note that AppSheet does not support complex nested arrays for return values as mentioned in the help article below. Please go towards the end of the article.

Use return values from webhooks - AppSheet Help

[trhaseeb]

I feel like the link you provided seems to suggest my query should work.

if this is not the case, can someone recommend a weather service (API) that is more compatible with appsheet?

[TeeSee1]

The array of the key forecastday is not a flat array of the same type and therefore it is not supported.

I would try to use an Apps Script step in which you make a call to this service, reformat the response and return it to the bot.

[trhaseeb]

I'll try this tonight, and post my results on the forum. thanks