Skip to content

Files

Latest commit

 

History

History
93 lines (71 loc) · 2.69 KB

analytics-api-get-report-queries.md

File metadata and controls

93 lines (71 loc) · 2.69 KB
title description ms.service ms.subservice ms.topic author ms.author ms.reviewer ms.date
Get report queries API
Use this API to get all queries that are available for use in commercial marketplace analytics reports.
marketplace
partnercenter-marketplace-publisher
article
smannepalle
smannepalle
sroy
03/14/2022

Get report queries API

The Get report queries API gets all queries that are available for use in reports. It gets all the system and user-defined queries by default.

Request syntax

Method Request URI
GET https://api.partnercenter.microsoft.com/insights/v1/cmp/ScheduledQueries?queryId={QueryID}&queryName={QueryName}&includeSystemQueries={include_system_queries}&includeOnlySystemQueries={include_only_system_queries}

Request header

Header Type Description
Authorization string Required. The Azure Active Directory (Azure AD) access token in the form Bearer <token>
Content-Type string Application/JSON

Path parameter

None

Query parameter

Parameter name Type Required Description
queryId string No Filter to get details of only queries with the ID given in the argument
queryName string No Filter to get details of only queries with the name given in the argument
IncludeSystemQueries boolean No Include predefined system queries in the response
IncludeOnlySystemQueries boolean No Include only system queries in the response

Request payload

None

Glossary

None

Response

The response payload is structured as follows:

Response code: 200, 400, 401, 403, 404, 500

Response payload:

{
  "Value": [
    {
      "QueryId": "string",
      "Name": "string",
      "Description": "string",
      "Query": "string",
      "Type": "string",
      "User": "string",
      "CreatedTime": "string",
      "ModifiedTime": "string"
    }
  ],
  "TotalCount": 0,
  "Message": "string",
  "StatusCode": 0
}

Glossary

This table describes the key definitions of elements in the response.

Parameter Description
QueryId Unique UUID of the query
Name Name given to the query at the time of query creation
Description Description given during creation of the query
Query Report query string
Type Set to userDefined for user created queries and system for predefined system queries
User User ID who created the query
CreatedTime Time of creation of query
TotalCount Number of datasets in the Value array
StatusCode Result Code. The possible values are 200, 400, 401, 403, 500