How to get full chart result without pruning in REST API?

Currently I am using REST API like -

curl -u API_Key:Secret_Key 'https://amplitude.com/api/3/chart/CHART_ID/query'

by passing CHART_ID.

When I am looking at chart table data it is showing full data and even when I am exporting csv data it is returning file with full data. But when I am doing same thing with REST API, it is pruning data and not returning full data.

Can you please help me to get full data without pruning using REST API?

Find more posts tagged with

API

Accepted answers

belinda.chiu

Hi dadasaheb.patil ! Welcome to the Amplitude Community and I’m happy to help!

What kind of chart are you trying to download? The Return Existing Chart API aka the query you are using will have responses vary by chart type. For Event Segmentation and Funnel charts, the maximum groupby/row limit is 1000: https://developers.amplitude.com/docs/dashboard-rest-api#:~:text=Full%20description.-,limit%20(optional),Group%20By%20values%20returned%20(default%3A%20100).%20The%20maximum%20limit%20is%201000.,-formula%20(optional%2C%20required

On the other hand, the CSV download has 10K row limit: https://help.amplitude.com/hc/en-us/articles/115002923888#h_23368329-5147-4369-9d91-6a1d552eab36

Due to the row limitation for the API, you may not get all of the data that you expected to get.

But, if you are exporting an Event Segmentation chart, you can recreate the chart through the Event Segmentation query and change the “limit” parameter to 20K (undocumented): https://developers.amplitude.com/docs/dashboard-rest-api#event-segmentation This increase in the row limit should help you get the data you are looking for given that you got the data you need through the CSV 10K limit.

Hope this helps!

All comments

Saish Redkar

Hey dadasaheb.patil

There could be a possibility of charts results getting pruned in the Dashboard REST API responses and it may vary depending on the chart type. We sometimes get a prunedResult key in that response, but not sure how that gets set.

Denis Holmes Jeremie Gluckman

Can we understand from the Engineering Team how pruning happens on the REST API responses ? I couldn’t find any mention of pruning in the API docs. This issue was also brought up in another post before. It’d be nice if we can get to know this one in depth.

belinda.chiu

Hi dadasaheb.patil ! Welcome to the Amplitude Community and I’m happy to help!

On the other hand, the CSV download has 10K row limit: https://help.amplitude.com/hc/en-us/articles/115002923888#h_23368329-5147-4369-9d91-6a1d552eab36

Due to the row limitation for the API, you may not get all of the data that you expected to get.

Hope this helps!

dadasaheb.patil

Hi belinda.chiu ,

Thanks for your quick response.

I am more looking over Breakdown Table where I get data in tabular format, which is more relevant than any type of chart. I am ok with any kind of chart, but need full data without prune for Breakdown Table data shown on UI.

My report condition is simple as below -

How to get full result for this condition, either using https://amplitude.com/api/3/chart/CHART_ID/query API or https://amplitude.com/api/2/events/segmentation either way is fine.

Denis Holmes

Hi dadasaheb.patil ,

I see Belinda answered your question and as she said

“Due to the row limitation for the API, you may not get all of the data that you expected to get. “

This is especially true if there is a lot of results. You can find information on how to build charts API calls here. If you are still having trouble, do let me know the chart URL and I will try to do my best to construct it for you.

dadasaheb.patil

Hi Denis Holmes ,

Thanks for quick response.

chart URL is https://analytics.amplitude.com/blueshift-labs-inc/chart/196n9qw

query api I tried which has row limitation, Can you please create event segment API request payload for above condition so that I can get same data, at least 20k result which is much better than 1k result. If this works fine, I’ll try for other chart and ask for help if needed.

And is this row limit applicable irrespective of subscription?

I am more interested in Breakdown Table data than actual shown any chart.

Denis Holmes

dadasaheb.patil ,

I went through our Help Center article here and use the API without issue, I would recommend reading through it fully and understanding each of the parameters to help you.

Regardless, I am using the below chart, the only difference being using specific dates.

https://analytics.amplitude.com/blueshift-labs-inc/chart/196n9qw/edit/5o2czx0

I used Basic Authorization with Postman. I hope this helps.

Saish Redkar

Thanks for jumping in on this Denis Holmes belinda.chiu

Denis Holmes

Saish Redkar Anytime! Hope you’re keeping well

Quick Links

Unanswered Questions

Error in Amplitude React Native SDK - "Cannot set property 'cookie' of undefined"
Hello! In React-Native mobile project we have error: Amplitude Logger [Error]: Failed to set cookie for key: AMP_TEST. Error: Cannot set property 'cookie' of undefined Error Component Stack: ``` The package version is "@amplitude/analytics-react-native": "1.5.1", Steps to Reproduce: * Initialize Amplitude with our API key…
Send IP on native events for first party tracking
We implemented first party tracking using the basic JS SDK on the browser and pointing the payload to our servers like this: amplitude.init(AMPLITUDE_API_KEY, { serverUrl: serverUrl, autocapture: { attribution: { excludeReferrers: [/domain1\.com$/, /domain2\.com$/], }, formInteractions: false, fileDownloads: false, }, });…
Events for an Android background app
My Android app is primarily a background app. Does Amplitude track events for such an app? Please let me know.
Modifed the Change over time retantion graph
here is the referance graph: https://app.amplitude.com/analytics/demo/chart/new/363tk5og In this graph, retention is currently being calculated based on the next day, but I want to analyze it based on the previous day instead. Example: For July 27, we should compare retention against July 26, not July 28. * So for 1-day…
Landing page analysis data table
Hi everybody! I need your help with a client request: my client is used to analyze landing pages performance with the standard report from GA4 and I need to create something similar in Amplitude. What I already have: * session entries grouped by page URL * purchase event calculated as session totals grouped by page URL and…