Post data from webcall JSON string

Hey all,

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:

https://samples.openweathermap.org/data/2.5/weather?lat=35&lon=139&appid=b6907d289e10d714a6e88b30761...

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.

Solved Solved
1 12 1,417
1 ACCEPTED SOLUTION

@teambelair

View solution in original post

12 REPLIES 12
Top Labels in this Space