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

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

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

@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.

2 Likes

@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.

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.

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

Update:

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

Any update on this?

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:

Cheers,
Jon

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

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.

@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.