I think this may have been discussed on github but I can’t find it.
I’d like to have a virtual table that can be refernecd from with Grist. An example would be to look up a list of customer names from a table (actually a view) in a postgreSQL database.
Excel can do this via ODBC as can LibreOffice via the postgres connector (using base as an intermediary). Google sheets can’t, but I’ve managed to get around this by using postgrest which surfaces tables as api endpoints.
It’d be REALLY cool if you could just point grist at an external api endpoint and get data back that could be integrated into an existing document.
Martyn