Installation and Configuration Guide

10.3

Back Next

Report Details Web Service

The web service returns the data from the

C_REPOS_RPT_DETAILS

table for a specific report. The web service uses the GET method.

Report Details URL

The Report Details URL has the following format:

http://<host>:<port>/Customer360/services/<database ID>/reports/details

where

database ID

is the ID of the ORS that is registered in the Databases tool in the Hub Console.

Query Parameters

The following table lists the query parameters for the Report Details web service:

Parameter	Description
reportId	ID of the report.
qryParamString	Optional. Filter condition that can be added as a part of a WHERE clause. If you include Date data type as filter, date must be provided in milliseconds. For example, 1400092200000.

Sample request with no filters specified

The following sample request returns the details of a report with ID 4:

http://localhost:8080/Customer360/services/localhost-orcl-TCR_HUB/reports/details?reportId=4

Sample response

The following sample response shows the details of the report with ID 4:

{
  "metadata": {
    "ROWID_RPT_CONFIG": "4 ",
    "DIMENSION_NAME_1": "Subject area",
    "DIMENSION_NAME_2": "null",
    "TIMEPERIOD_NAME": "Year",
    "RPT_NAME": "MDM Business Entity Growth Trends",
    "METRIC_NAME": "Number Of Records",
    "RPT_DESC": "MDM Business Entity Growth Trends",
    "RPT_TYPE": "null"
  }
},
{
  "data": [
    [
      "Organization",
      "null",
      "2011-JAN-10",
      "450"
    ],
    [
      "Organization",
      "null",
      "2012-JAN-10",
      "266"
    ],
    [
      "TCR",
      "null",
      "2013-JAN-10",
      "450"
    ],
    [
      "Customer",
      "null",
      "2014-JAN-10",
      "12903"
    ]
  ]
}

Sample request with filters

The following sample request returns the details of a report based on the specified filter and ID 4:

http://localhost:8080/Customer360/services/localhost-orcl-TCR_HUB/reports/details?reportId=4&qryParamString={"filterCondition":[{"colName":"TIMEPERIOD_VALUE","type":"range","dataType":"date","value":["1294621200000","1389292200000"]}],"qryOperator":"AND"}

The following sample response shows the details of the report with ID 4:

{
  "metadata": {
    "ROWID_RPT_CONFIG": "4 ",
    "DIMENSION_NAME_1": "Subject area",
    "DIMENSION_NAME_2": "null",
    "TIMEPERIOD_NAME": "Year",
    "RPT_NAME": "MDM Business Entity Growth Trends",
    "METRIC_NAME": "Number Of Records",
    "RPT_DESC": "MDM Business Entity Growth Trends",
    "RPT_TYPE": "null"
  }
},
{
  "data": [
    [
      "Organization",
      "null",
      "2012-JAN-10",
      "266"
    ],
    [
      "TCR",
      "null",
      "2013-JAN-10",
      "450"
    ]
  ]
}

Rename Saved Search

Table of Contents

Installation and Configuration Guide

Installation and Configuration Guide

Report Details Web Service

Report Details Web Service

Report Details URL

Query Parameters