Skip to main content
Return a report’s computed pivot-table cells — its cross-tabulated values. For a report configured as a pivot table (see get_report’s pivot_configuration): returns the row groups, the column groups, the measures, and the flattened cells (one per row-path × column-path × measure), respecting the caller’s visibility. __total__ in a path marks a subtotal or grand-total. For a flat (non-pivot) report, use get_report_data instead — calling this on a report with no pivot configuration raises a clear error. Paginated like every list tool: limit caps the number of cells per call, offset walks the pages (next_offset is null on the last one), total_cell_count is the full size. A page holds whole pivot rows, so it may return slightly fewer cells than limit (never more), and always at least one row. A pivot too large to compute on the fly raises an actionable error. You only see reports you have access to.

Parameters

Body

string
required
The report to read. Accepts the report’s ObjectId (the id returned by list_reports) or a case- and accent-insensitive substring of its name. A name matching no — or more than one — report raises a clear error; pass the full id to disambiguate.
integer
Page size, between 1 and 250. Defaults to 50.
integer
Row offset into the result set — the number of rows to skip before this page. Pass the next_offset returned by the previous call, or None for the first page.

Response

Body

string
string
Deep link to open this report in the Qobra web app.
object[]
The fields laid out on rows, outermost first.
object[]
The fields laid out on columns, outermost first.
object[]
object[]
One cell per row-path × column-path × measure; __total__ in a path marks a subtotal/grand-total position.
integer
integer
integer
Row offset for the next page — pass it back as offset to fetch the following cells. null on the last page.