I’m trying to run a query through the rest api - https://redash.io/help/user-guide/integrations-and-api/api.
Maybe I’m not seeing something obvious but I can’t find any thing on paginating the results? Is there a recommended approach for this?
The API does not paginate results. Since Redash is a data visualisation tool, it is not expected that results would be sizable enough to require pagination. If you need to pull significant amounts of data, you are better served accessing your database directly through a suitable connector.
Hey @jesse , thanks for the reply. Makes sense. To be honest I’ve been tempted to use redash as a centralized, documented, rest api for my web apps. That’s why I was interested in pagination. Since redash caches results, I was just missing 2 things: pagination to fetch results, and having total number of records in the query_result response.
I’m suffering from sql query spread chaos…