Thanks again for your creative thoughts.
It would actually be totally transparent to the AppSheet creator once the connection to the web service is made.
Appsheet already use web service interface to the Smartsheet API but it is not generic.
The generic version would implement an interface to retrieve the column names and types and from there everything is basically just generic CRUD operations.
This would be a limited task on Appsheet side and would need simple integration work on the web service side. That being done you could use that data source in all Appsheet apps fully transparently using the standard AppSheet way.
My data IS in Smartsheet so I have no choice to store it elsewhere.
I m with your idea, REST API, as a data source, get data from an external source and consume data within Appsheet.
Reading data (GET) should be easy-peasy one, but other verbs sounds bit tricky. All the API should have own setting, how to pass the value to params, body to conduct CRUD operation. In that sense, still we need to instruct Appsheet how to pass the value to whichend point etc. So technically, it sounds difficult for any service to natively fill those to the API call to the external service.
In the meantime, all of my appsheet data are originated from my SQL server. Sometime, I wish to consume those data for other purpose. (aprat from Appsheet)
Then we can use GAS, google app script, to get the data from sql to googlesheet, but to save my time, I m using Google Sheet extension, like this.
I put the appsheet url endpoint with auth, and get the data from Appsheet (redirected to my sql). The beauty calling Appsheet api rather than directly retrieve data from SQL is we can get even value from virtual column.
Sorry, Ole, we are talking about the same/similar subject you posted in other place, but use this googlesheet something like a virtual table to bridge a service and b service.
I have not tested before, but we refer to this virtual table on googlesheet, then combining the Appsheet api to do CRUD, it might work.
I know this is not ideal and perfect though.