What "External services and REST API's" means?

[Henrique_Vieir2]

It is on the Advanced data of the pricing page. I did not find more information about that.

Thanks!

[WillowMobileSys · Accepted solution]

You can link your AppSheet app to other cloud-based services through API's - Application Programming Interface.  More specifically through REST API's.  API's are simply a way to connect and communicate with another service/process.  REST is a certain kind of API that adheres to specific standards of protocol.

In an AppSheet app, you can create an Integration within another EXTERNAL service as long as that service supports a REST API and then send information to that service from AppSheet.  Additionally, other EXTERNAL services can connect to the Appsheet API to ADD/Update data rows in your AppSheet app.

There is a limitation.  Some API calls are simply a request for information to be returned (e.g. the weather forecast for the week).  This information would be sent from the external service in whatever format they have designed.  AppSheet does not currently support the capability of taking an external services formatted response and transforming it into your apps rows of data.  However, there are ways to work around this limitation such using Google Scripts to get the data, transform it and place it into a sheet used by your app.  Integromat might also be an option as they do support the AppSheet API.

[Kevin_Ra_CEO]

@WillowMobileSys You may want to look into having Make/Integromat and/or Zapier connect to GOOGLE SHEETS (or Airtable or Big Query or whatever cloud-connected data source you are using). Most of them offer way more features to connect to Sheets, and you can easily have AppSheet listen for changes to a row in Sheets.

Even if you are going to write an AppScript, it still can be bounded to a table in Sheets and push/pull AppSheet data.