I wish I saw these blog posts when they were published, but I guess better late than never :-) I really like the idea of using Google Spreadsheets for data manipulation. It’s a hack, but a really nice one. 👍🏻
Also wanted to point out that:
- You can find the API key from the menu:
- Each query has a permanent URL that returns always the latest results. If to use your example, it will be: https://your.redash.io/api/queries/827/results.csv?api_key=9352fd37f2f4ce923932c9c6328829a5be7093ea3d
We have this documented now in the user guide, but we should also improve its discoverability in the UI. I thought of maybe showing the results URL when opening the API key window.
(Luis Novo FYI)