From a plugin, I would like to fetch all the data formatted as in the csv export.
When I say “formatted”, I mean that dates should be respecting the date format, numbers should have the currency if they are defined as currencies etc.
Is there a way to get this without the user explicitly providing an API Key ? Indeed, I’d like to avoid asking each user to enter their API key, since they should have (for the plugin to work) already granted to the plugin “Full access” to the table of interest.
What I have tried so far
- the widget-API “fetchSelectedTable” returns the date in iso-format and raw numbers regardless of the user-provided format
- the “/docs/{docId}/download/csv” require an API Key for authentication.
- There is a wiget-API “getAccessToken” function, and the comments suggest that it can be passed as an
auth
query parameter, but I could not get it to work, and I suspect the comments are outdated.
Thanks in advance !