cmreq-by-cpcode report

The following shows how to generate the cmreq-by-cpcode report using either the Reporting API’s Generate a report POST operation or the Get a cacheable report GET operation. Details about each report’s supported products, metrics, filters, and available data intervals are also available dynamically by running the API’s Get a report type operation, also shown below. See also other available reports.

Report definition

Provides HTTP transaction data delivered through the edge platform to your end users at the CP code level.

Business object: cpcode

Data available for: 92 days

Required products: Cloud Monitor, OTA Updates

Available metrics

Metric Description
Data metrics
requestCount Total traffic by segments.

Sample report

POST /reporting-api/v1/reports/cmreq-by-cpcode/versions/1/report-data{?start,end}

Sample: /reporting-api/v1/reports/cmreq-by-cpcode/versions/1/report-data?start=2020-08-01T00%3A00%3A00Z&end=2020-09-01T00%3A00%3A00Z

Object type: Query

Download schema: report-request-schema.json

Query parameters

Parameter Type Sample Description
Required
start String 2020-08-01T00:00:00Z Specifies the start of the reported period as an ISO–8601 timestamp with optional time zone. The report includes data that matches the start value’s timestamp.
end String 2020-09-01T00:00:00Z Specifies the end of the reported period as an ISO–8601 timestamp with optional time zone. The report excludes any data that matches the end value’s timestamp.

JSON request members

Member Type Description
objectIds Array Specifies the set of cpcode values you want to report on.
objectIds Enumeration As an alternative to an array of ID values, specify all as a string for unfiltered data. Either way, objectIds is required.
metrics Array The set of desired metrics. If omitted, the report includes all available metrics.

Request body:

{
    "objectIds": [
        "55232",
        "23433",
        "32433"
    ],
    "metrics": [
        "requestCount"
    ]
}

GET /reporting-api/v1/reports/cmreq-by-cpcode/versions/1/report-data{?start,end,objectIds,allObjectIds,metrics}

Sample: /reporting-api/v1/reports/cmreq-by-cpcode/versions/1/report-data?start=2020–08–01T00%3A00%3A00Z&end=2020–09–01T00%3A00%3A00Z&objectIds=55232,23433,32433&metrics=requestCount

Query parameters

Parameter Type Sample Description
Required
start String 2020-08-01T00:00:00Z Specifies the end of the reported period as an ISO–8601 timestamp with optional time zone. The report excludes any data that matches the end value’s timestamp.
end String 2020-09-01T00:00:00Z Specifies if unavailable reports should be shown.
Optional
allObjectIds Boolean true As an alternative to objectIds, enabling this generates a report that includes all IDs available for the cpcode objectType. This parameter is ignored if the request also specifies a set of objectIds.
objectIds String 55232,23433,32433 As an alternative to allObjectIds, specifies the set of unique IDs for the cpcode objectType you want to report on, formatted as a comma-delimited list.
metrics String requestCount Specifies a comma-separated list of metrics to include in the report, otherwise all metrics if omitted. The set of available metrics depends on the type of report. URL-encode the entire value in the GET request.

Status 200 application/json

Object type: Report

Download schema: report-response-schema.json

Response body:

{
    "metadata": {
        "name": "cmreq-by-cpcode",
        "version": "1",
        "outputType": "FLAT",
        "groupBy": [
            "cpcode"
        ],
        "start": "2020-08-01T00:00:00Z",
        "end": "2020-09-01T00:00:00Z",
        "availableDataEnds": null,
        "suggestedRetryTime": null,
        "rowCount": 4,
        "filters": [],
        "columns": [
            {
                "name": "groupBy",
                "label": "cpcode"
            },
            {
                "name": "requestCount",
                "label": "Total Requests"
            }
        ],
        "objectType": "cpcode",
        "objectIds": [
            "55232",
            "23433",
            "32433"
        ]
    },
    "data": [
        {
            "cpcode": "34512",
            "requestCount": "3395"
        },
        {
            "cpcode": "51234",
            "requestCount": "212"
        },
        {
            "cpcode": "12345",
            "requestCount": "3904"
        },
        {
            "cpcode": "45123",
            "requestCount": "4655"
        }
    ],
    "summaryStatistics": {}
}

Status 200 text/csv

Response Body:

#METADATA_START
name,cmreq-by-cpcode
version,1
source,cmreq-by-cpcode/versions/1
groupBy,cpcode
start,2020-08-01T00:00:00Z
end,2020-09-01T00:00:00Z
availableDataEnds,
suggestedRetryTime,
rowCount,4
objectType,cpcode
objectIds,55232,23433,32433
#METADATA_END

#SUMMARYSTATISTICS_START

#SUMMARYSTATISTICS_END

#COLUMNS_START
cpcode,requestCount
#COLUMNS_END

#DATA_START
34512,3395
51234,212
12345,3904
45123,4655
#DATA_END

Get report details

This sample Get a report type operation gets the same information you need to run the cmreq-by-cpcode report as provided in this reference documentation, but available dynamically to your API client application.

GET /reporting-api/v1/reports/cmreq-by-cpcode/versions/1

Status 200 application/json

Object type: ReportType

Download schema: data-row-schema.json

Response body:

{
    "name": "cmreq-by-cpcode",
    "description": "Provides HTTP transaction data delivered through the edge platform to your end users at the CP code level.",
    "businessObjectName": "cpcode",
    "version": 1,
    "status": "PUBLISHED",
    "deprecated": false,
    "timeBased": false,
    "outputType": "FLAT",
    "requiredProducts": [
        "Cloud Monitor, OTA Updates"
    ],
    "requiredRoles": [
        "EdgeConnect Report - View Only",
        "OTA App User"
    ],
    "available": false,
    "metrics": [
        {
            "name": "requestCount",
            "description": "Total traffic by segments.",
            "label": "Total Requests",
            "unit": "COUNT",
            "summaryStatistic": false
        }
    ],
    "groupOutlyingValues": {
        "enabled": false
    },
    "groupBy": [
        "cpcode"
    ],
    "intervals": [
        "MONTH",
        "WEEK",
        "DAY",
        "HOUR",
        "FIVE_MINUTES"
    ],
    "dataRetentionDays": 92,
    "links": [
        {
            "rel": "self",
            "href": "/reporting-reports-executor-api/v1/reports/cmreq-by-cpcode/versions/1"
        },
        {
            "rel": "versions",
            "href": "/reporting-reports-executor-api/v1/reports/cmreq-by-cpcode/versions"
        },
        {
            "rel": "all-reports",
            "href": "/reporting-reports-executor-api/v1/reports"
        },
        {
            "rel": "execute-report",
            "href": "/reporting-reports-executor-api/v1/reports/cmreq-by-cpcode/versions/1/report-data"
        }
    ]
}