Automatically export data table

Works great thanks a lot!!

Hi @Saish Redkar, how can I use this endpoint? It is not clear to me. Should I use the same endpoint to get results from an existing chart?

Hey @Cecilia 

The results from an existing chart endpoint will work for a data table too. You will have to use the chart id of your data table in the api call.

@Cecilia Definitely check out the article that @Saish Redkar linked for you! And it looks like @jarren.patao replied via email. Posting his answer here in case it helps other members with the same question:

This should be possible to export a Data Table, you can do so with the Results From Existing Chart endpoint and exclude the date parameters. Here is a snippet from our documentation:

You can use the Dashboard REST API to export data from data tables. Just query any Data Table chart type, and don't include start or end dates in the query.

 
This could look something like 

curl --location 'https://amplitude.com/api/3/chart/{CHART_ID}/query' \
--header 'Authorization: Basic {REDACTED}'

 
Otherwise, I hope this helps! Please let me know if you have any questions.

i’ve got data export to bigquery turned on for every 10 minutes, but i notice the upload times are not continuous and so a bunch of data never gets synced

for instance, i’ll see server UTC upload times with gaps between them, like this: 

how do i fix this?

SERVER TIME UTC

3:00-3:10 pm
2:40-2:50 pm
2:10-2:20

(not looking to use the api, want to keep it synced to bigquery)