Currently exploring the API integration functionality to pull-in Exchange and the Countries they operate-in data into an AppSheet solution from an external service. I think I read somewhere that this functionality is not possible. Only AppSheet sharing data via the API will work.
Can anyone confirm if this is correct?
You can use webhooks to invoke external web services but you cannot retrieve data from external web services via webhooks.
Others in the community may have suggestion on how to accomplish this through other means.
If your data is sitting in data source, not Google Sheet, but you want to use that on Google Sheet? Tips & Tricks ?
Majority of Appsheet users are based on Google drive and sheet as default data source. If your data is sitting outside that, and need to access those data on Google sheet, I recommend combination of Apsheet GET API pluc this google chrome extension, called API Connector. https://gsuite.google.com/marketplace/app/api_connector/95804724197 There is bunch of similar service, like Supermetrix etc, but this extension is simple and easy to handle. For non-coder, we dont need to type GAS or any oth…
This might help.
Thank you for the clarification on web-hooks; it is what I suspected and many thanks for the API Connector info, I’ll give the API Connector a go.
The data I have is held in a MySQL Database as I am one the individuals looking to port-across an application from AppMaker. Ideally we wouldn’t want to leave any data in a spreadsheet and as far as I am aware AppSheet doesn’t offer an ‘import’ routine other than an action to copy rows.
Something to explore further.