Get Report Data (Operation)

URL	`http://<report-url>/data`
Parent Resource	Report

Description

Executes a report and returns the raw result set.

Parameters

Parameter	Details
f	Description: The response format. The default response format is html. Values: html \| json
user	Required Description: The username of the client.
timeZoneOffset	Description: The time zone offset from UTC (in minutes) of the client's system. This parameter affects the formatting of date/time values within a report.

Example Usage

Example 1: URL for the report data of report ID 3 in the "Workflow" service on sampleserver.

http://sampleserver/arcgis/rest/services/Workflow/WMServer/reports/3/data?user=cjones

JSON Response Syntax

{
  "reportData": {
    "title": "<title>",
    "description": "<description>",
    "columns": [ "<columnName1>", "<columnName2>", ... ],
    "groups": [
      {
        "value": "<groupValue1>",
        "aggregateLabel": "<aggregateLabel1>",
        "aggregateValue": "<aggregateValue1>",
        "rows": [
          [ "<rowValue111>", "<rowValue112>", ... ],
          [ "<rowValue121>", "<rowValue122>", ... ],
          ...
        ]
      },
      {
        "value": "<groupValue2>",
        "aggregateLabel": "<aggregateLabel2>",
        "aggregateValue": "<aggregateValue2>",
        "rows": [
          [ "<rowValue211>", "<rowValue212>", ... ],
          [ "<rowValue221>", "<rowValue222>", ... ],
          ...
        ]
      },
      ...
    ]
  }
}

JSON Response Example

{
  "reportData": {
    "title": "Workload Report",
    "description": "A measure of the job load for each analyst",
    "columns": [ "Job Assignment", "Number of Active Jobs" ],
    "groups": [
      {
        "value": "",
        "aggregateLabel": "",
        "aggregateValue": "0",
        "rows": [
          [ "Andy Miller", "5" ],
          [ "Charlotte Jones", "8" ],
          [ "QA Team", "12" ]
        ]
      }
    ]
  }
}