Hello , I would like to use the OpenWeatherMA...

[Simon_Wagner]

Hello , I would like to use the OpenWeatherMAP web-service in order to determine the local temperature at my place and fill it into an input field of a form. What options do I have? Is the

appsheet API functionality able to handle it? Any hint / help appreciated. Simon

[Simon_Wagner]

openweathermap.org - Current weather data - OpenWeatherMap Current weather data - OpenWeatherMap openweathermap.org

[pravse]

@Simon_Wagner, you’ll have to get this data via a spreadsheet formula. Later this year, we hope to have actions in the app itself that can fetch live from a web service.

[David_Joyce]

Any update on this?

[Jonathon]

Hey David. I have been doing something similar using Zapier. The gist of it is:

1. AppSheet sends a POST with relevant data (pkey, latlong, etc) to Zapier
2. Zapier parses the data, performs an HTTP GET to openweathermap
3. Zapier POSTS data back to the AppSheet record

As it is a multi-step trigger, it falls under Zapier’s paid subscription model. The service is about 25USD/mo on the lowest tier.

---

Also, refer to this related topic:

Post data from webcall JSON string Questions

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 n…

Cheers,
Jon

[David_Joyce]

Thanks for that not @Jonathon. I was preparing to go down the Zapier route to integrate with Appsheet. But given that a) there is no direct way to get the results of a web service call in AppSheet b) I cannot see a way to create json from multiple records in an appsheet table and c) Zapier is not free, as youve informed us.

I going to try to find another way to trigger / call the webservice

[Jonathon]

Best of luck with your investigations! Please post back here if you come up with a solution as I and others may be interested.

One small note though: I believe it is possible to generate a JSON string which includes multiple records in appsheet.

[LeventK]

@David_Joyce
@Jonathon
With constructing a Google Apps Script project, you can create your own webhook endpoint for AppSheet which will make a call to any REST API service and record the response back to your gSheet.

[David_Joyce]

Hello @Jonathon
After a holiday break and other things, Ive finally turned my attention to this and I believe I have something that works. @LeventK is correct in saying that Google Apps Script is the way to go. You need to call the web service using the google function UrlFetchApp, passing it the url and options, which itself can include authorization strings and an optional payload (JSON-format data).

Inside the script, you should also be able to call AppSheet API to update spreadsheet (Google sheets). I dont think you can update a rdbms datastore via the appsheet api.

It works, and there should be examples, etc. on the web, but if you get stuck I’ll see what I can do in the way of example code

[Jonathon]

Glad that there is a way to do this ‘natively’ with Google app scripts!

Unfortunately I backend my apps to SQL Server, so google app script isn’t quite as convenient

[LeventK]

@Jonathon
You can create a standalone Google Apps Script, deploy it as a web-app and use its URL as a webhook endpoint which can connect to your SQL database thru ODBC.

[Jonathon]

David_Joyce:

ps Script is the way to go. You need to call the web service using the google function UrlFetchApp, passing it the url and options, which itself can include authorization strings and an optional payload (JSON-format data).

Inside the script, you should also be able to call AppSheet

Sounds like a fun way to spend a wednesday night

[Bhadriraju_THAT]

praveen:

fetch

Is this feature now available praveen? Fetch response from an API and use it in APPSHEET.

[APiCC_Conor]

I would also really like to see this!

[Jonathan_S]

Has this been implemented yet?

[Steve]

Nope.

[Simon_Wagner]

@praveen

OK, thx -> I’ve tried to go via EXCEL: Unfortunately the spreadsheet function

WEBSERVICE is not supported* and hence there doesn’t seem to be an easy solution (within EXCEL) Would that work on google sheets? * Error: The spreadsheet for ‘Weather-584403:1.000001:Weather’ uses an unsupported formula : Excel function ‘_xlfn.WEBSERVICE’ is not supported in formulas.

[Simon_Wagner]

I found a solution using the google sheets function IMPORTXML. Synchronizing seem to be slow but it works. I wonder if WEBSERVICE in EXCEL not working is related to dropbox.

[Simon_Wagner]

I start to understand the interdependencies given the data provider & spread sheet platform & available functionality. Given the missing AppSheet get webservice API function one needs to chose either google sheets or ( excel + Office 365 ) if one needs to integrate a webservice like OpenWeatherMap.

The help document below helps.

help.appsheet.com - Improving the Speed of Sync Improving the Speed of Sync help.appsheet.com

[Simon_Wagner]

Update:

Based on a professional AppSheet access one may work with google sheets and excel on dropbox in parallel. Problem solved.

[Fabian_Weller]

@Jonathon @David_Joyce @LeventK
If you don’t mind: I would be very happy with some Script examples

[Ron_Mansolo]

Please do

[Songwutk]

I’m agree with Simon_Wagner, If Appsheet can fetch json from php script, this endgame. Appsheet winner !

[Info_Blackpear]

Hello, it’s an interesting topic here, Wil it be some plans to appsheet can catch data native as webhook endpoint someday?