Get report rows

Get pivot table/table results as rows

This request retrieves the results of a pivot table as a list of JSON objects, with one object for each row in the report.

This result can be consumed by PowerBI and Excel using PowerQuery.

Request

GET https://www.activityinfo.org/resources/reports/{reportId}/rows

Response

Status Code	Error Code	Description
401	AUTHENTICATION_REQUIRED	The request must be authenticated

Example

curl -u anything:YOUR_API_TOKEN \
  https://www.activityinfo.org/resources/reports/cht8p4kdeimokm5/rows

The above command returns JSON structured like this:

[
  {
    "Gender": "Female",
    "Value": 97
  },
  {
    "Gender": "Male",
    "Value": 42
  }
]