Get Analytics Panel Output
See what a panel produces: its status, any failure message, and its rows, a window at a time. Check it after Update Analytics Panel, reading the draft.
Path
The page id, from List Analytics Pages.
The panel id, from Get Analytics Page.
Headers
Optional. The id of the organization to act in. Leave it out to act in the API key's own organization. Here a key acts in another organization only as one of its members: with "Use this key across all of your organizations" on, in an organization its creator belongs to with a role. Child organizations and MindCloud staff access do not reach this endpoint. Every response's X-Company-Id header names the organization it acted in. See Organizations.
Query
draft or published.
Which version of the page to read. Left out: the published version when there is one, otherwise the draft.
draftThe draft, with the changes not yet published. Editors and owners only.publishedThe version viewers see.
How many rows to answer, 1-1000.
How many rows to answer, 1-1000. Defaults to 100.
Default: 100
How many rows to skip.
How many rows to skip. Defaults to 0.
Default: 0
Response fields
panelIdstringThe panel, from Get Analytics Page.
statusstringWhere the panel's stored result stands.
readyRows are ready.emptyIt ran and returned no rows.refreshingIts sources are fetching; the result follows.failedIt failed; message says why.draftIt is set up but has not produced a result yet.noResultIt has sources but no stored result yet. Set its query or transform to run it.noDataSourceIt has no data source yet.
messagestringWhy it failed or is waiting. Null when there is nothing to say.
columnsarray of stringThe column names the rows carry, in order.
rowsarray of objectsThe rows in this window, as objects keyed by column.
rowCountnumberHow many rows there are in all.
offsetnumberWhere this window starts.
nextOffsetnumberThe offset of the next window, or null when this is the last.
updatedOndateWhen the result was last written. Null when there is none.
versionobjectWhich version of the page this answer reads.
modestringdraft or published.
draftThe draft, with changes not yet published.publishedThe version viewers see.
publishedVersionIdstringThe published version read, from List Analytics Page Versions, or null when the draft is read.