I've created a data table chart that I'd like to use as source to export data using the Dashboard API (GET https://amplitude.com/api/3/chart/chart_id/query). The issue I'm currently facing is that the number of rows I'm getting on the response varies depending on interval I query for. When specifying 12 months in the data table interval I get an API response with 13k rows but if I change the date interval for only a single month (so that I'd get the most amount of data per month) I get only 1000 rows.
Am I missing a parameter on the API endpoint to configure this? Otherwise what would be the API request to get all of the data from a data table (in this case filtering the event of interest) without using the export API which would export all events.
Thanks in advance
