Installation and Configuration Guide

10.3 HotFix 2

Back Next

Report Facet Web Service

The Report Facet web service returns the list of unique values for the specified column for the specified report. You can use the values as filters. Use the GET method for the web service.

Report Facet URL

The Report Facet URL has the following format:

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

Query Parameters

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

Parameter	Description
reportId	ID of the report.
facetType	Any column of the C_REPOS_RPT_DETAILS table.

Sample request

The following sample request returns the unique values in the

DIMENSION_VALUE_1

column for the report with ID 4:

http://localhost:8080/Customer360/services/localhost-orcl-TCR_HUB/reports/facets?reportId=1&facetType=DIMENSION_VALUE_1

Sample response

{
  "DIMENSION_VALUE_1": [
    "Close 1",
    "Close 5",
    "Close 4",
    "Overdue",
    "Close",
    "Close 2",
    "Open"
  ]
}

Rename Saved Search

Table of Contents

Installation and Configuration Guide

Installation and Configuration Guide

Report Facet Web Service

Report Facet Web Service

Report Facet URL

Query Parameters