I’m wanting to get data from openweathermap api or similar web services and use a webhook / Appsheets api to record the weather based upon user input timestamps and lat/long.
Openweathermap makes this easy, and returns a variety of formats (json, etc) based upon a preformatted HTML string. For example:
Is it possible to retrieve/read this json string in appsheet natively? Do I need to lean on an external service (Zapier) to perform this integration? I would like to avoid that if possible.