How to tell if a response has multiple pages

Hi! I’m new to amplitude so please bear with me while I assimilate to the lingo

I’m trying to do an API call to a chart that I have already created. This is the following GET URL I am using:

https://amplitude.com/api/3/chart/xxxxxx/query

In the response, I don’t see an attribute telling me how many pages I have. This is what I see at the bottom of the response. Can someone help me with this? In Amplitude, I have 1200 results but in the API, it’s capped at 1000

"timeComputed": 1706812263267,<br />    "wasCached": true,<br />    "cacheFreshness": "FRESH",<br />    "novaRuntime": 47,<br />    "novaRequestDuration": 79,<br />    "novaCost": 0,<br />    "throttleTime": 0,<br />    "minSampleRate": 1.0,<br />    "transformationIds": [],<br />    "backend": "novaV2",<br />    "realtimeDataMissing": false,<br />    "timedOutRealtimeData": false,<br />    "missedCacheAndNotComputed": false,<br />    "partialMergedAndNewUserInformation": false,<br />    "prunedResult": true,<br />    "hitChunkGroupByLimit": false,<br />    "subcluster": 9,<br />    "millisSinceComputed": 2440356,<br />    "earliestServerReceivedTime": 9223372036854775807,<br />    "queryIds": [<br />        "xxxxxx"<br />    ],<br />    "novaRequestStartAndEndTimes": [<br />        [<br />            1706814703525,<br />            1706814703604<br />        ]<br />    ],<br />    "perQueryMetadata": [<br />        {<br />            "queryId": "xxxxxx",<br />            "queryType": "MULTI_SEGMENTATION",<br />            "cached": true,<br />            "cacheFreshness": "FRESH",<br />            "throttleTime": 0,<br />            "novaCost": 0,<br />            "minSampleRate": 1,<br />            "realtimeDataMissing": false,<br />            "externalDataMissing": false,<br />            "timedOutRealtime": false,<br />            "missedCacheAndNotComputed": false,<br />            "prunedResult": true,<br />            "hitChunkGroupByLimit": false<br />        }<br />    ],<br />    "prunedAmpIds": [],<br />    "dashRequestDuration": 481.92405700683594,<br />    "dashRuntime": 402.92405700683594

Find more posts tagged with

API

Accepted answers

Saish Redkar

Hi Mattics Phi

Here’s a post which can help you navigate pruned results via Dashboard REST API

https://community.amplitude.com/building%2Dand%2Dsharing%2Dyour%2Danalysis%2D58/how%2Dto%2Dget%2Dfull%2Dchart%2Dresult%2Dwithout%2Dpruning%2Din%2Drest%2Dapi%2D1021?postid=3475#post3475

Hope this helps.

All comments

Saish Redkar

Hi Mattics Phi

Here’s a post which can help you navigate pruned results via Dashboard REST API

https://community.amplitude.com/building%2Dand%2Dsharing%2Dyour%2Danalysis%2D58/how%2Dto%2Dget%2Dfull%2Dchart%2Dresult%2Dwithout%2Dpruning%2Din%2Drest%2Dapi%2D1021?postid=3475#post3475

Hope this helps.

Mattics Phi

Hi Saish Redkar ! IThanks for the help! I was able to produce a response with this HTTP

https://amplitude.com/api/2/events/segmentation?e={"event_type":"caller_info_popup_triggered"}&start=20240101&end=20240131

but I was unable to actually get the events for the time period. In the response, I just got the days that events happened. How would I go about getting all of the events that are returned in the web? ChartID got me to this, but it was limited to only 1000

{<br />    "data": {<br />        "series": [<br />            [<br />                138,<br />                1564,<br />                1756,<br />                1770,<br />                1711,<br />                330,<br />                147,<br />                1851,<br />                1895,<br />                1957,<br />                1888,<br />                1809,<br />                314,<br />                148,<br />                1544,<br />                1886,<br />                1986,<br />                2006,<br />                1872,<br />                333,<br />                145,<br />                1895,<br />                1970,<br />                1979,<br />                1939,<br />                1801,<br />                313,<br />                170,<br />                1928,<br />                1985,<br />                2030<br />            ]<br />        ],<br />        "seriesCollapsed": [<br />            [<br />                {<br />                    "setId": "",<br />                    "value": 3950<br />                }<br />            ]<br />        ],<br />        "seriesLabels": [<br />            0<br />        ],<br />        "xValues": [<br />            "2024-01-01",<br />            "2024-01-02",<br />            "2024-01-03",<br />            "2024-01-04",<br />            "2024-01-05",<br />            "2024-01-06",<br />            "2024-01-07",<br />            "2024-01-08",<br />            "2024-01-09",<br />            "2024-01-10",<br />            "2024-01-11",<br />            "2024-01-12",<br />            "2024-01-13",<br />            "2024-01-14",<br />            "2024-01-15",<br />            "2024-01-16",<br />            "2024-01-17",<br />            "2024-01-18",<br />            "2024-01-19",<br />            "2024-01-20",<br />            "2024-01-21",<br />            "2024-01-22",<br />            "2024-01-23",<br />            "2024-01-24",<br />            "2024-01-25",<br />            "2024-01-26",<br />            "2024-01-27",<br />            "2024-01-28",<br />            "2024-01-29",<br />            "2024-01-30",<br />            "2024-01-31"<br />        ]<br />    },<br />    "timeComputed": 1707344797344,<br />    "wasCached": false,<br />    "cacheFreshness": "FRESH",<br />    "novaRuntime": 759,<br />    "novaRequestDuration": 782,<br />    "novaCost": 1000,<br />    "throttleTime": 3,<br />    "minSampleRate": 1.0,<br />    "transformationIds": [],<br />    "backend": "novaV2",<br />    "realtimeDataMissing": false,<br />    "timedOutRealtimeData": false,<br />    "missedCacheAndNotComputed": false,<br />    "partialMergedAndNewUserInformation": false,<br />    "prunedResult": false,<br />    "hitChunkGroupByLimit": false,<br />    "subcluster": 9,<br />    "millisSinceComputed": 2,<br />    "earliestServerReceivedTime": 9223372036854775807,<br />    "queryIds": [<br />        "ZPLJP3Wf7V"<br />    ],<br />    "novaRequestStartAndEndTimes": [<br />        [<br />            1707344796563,<br />            1707344797345<br />        ]<br />    ],<br />    "perQueryMetadata": [<br />        {<br />            "queryId": "ZPLJP3Wf7V",<br />            "queryType": "MULTI_SEGMENTATION",<br />            "cached": false,<br />            "cacheFreshness": "FRESH",<br />            "throttleTime": 3,<br />            "novaCost": 1000,<br />            "minSampleRate": 1,<br />            "realtimeDataMissing": false,<br />            "externalDataMissing": false,<br />            "timedOutRealtime": false,<br />            "missedCacheAndNotComputed": false,<br />            "prunedResult": false,<br />            "hitChunkGroupByLimit": false<br />        }<br />    ],<br />    "prunedAmpIds": []<br />}

Quick Links

Unanswered Questions

time format on import from Big Query
I am running into a loop when attempting to import data from BigQuery. At origin, my data is already in milliseconds since epoch. If I query: event_time as time, I get the error: 1.'time' column should be a TIMESTAMP_NTZ column (Snowflake) or a TIMESTAMP column (BigQuery). example for the type of 'time' column is…
Import data from one amplitude account to another
How do I transfer data from one amplitude account to another? It seems all the community chats about this have completely broken links. Easy to export, no way to import, very frustrating. :(
@amplitude/plugin-web-vitals-browser build fails on CRA v4 (react-scripts@4.0.3)
When using @amplitude/plugin-web-vitals-browser with Create React App v4 (react-scripts@4.0.3), the build fails with: ./node_modules/@amplitude/plugin-web-vitals-browser/node_modules/web-vitals/dist/web-vitals.js<br /><br />SyntaxError:…
Question about Amplitude Export API Data Delay
Hello, I'm using SpringBoot and Kotlin to integrate with the Amplitude Export API. The official Amplitude documentation (https://amplitude.com/docs/apis/analytics/export) states that "data is available to export at a minimum within 2 hours of when the servers received it." However, there's no clear information about the…
Retrieve via the API users based on a user property
Hello, Is there a way to make a query like: “Give me all the users that have the user property X equal to 10”, by using just any of the APIs, without making a cohort first through the Amplitude’s UI? Thank you!