Apigee API . organizations . hostQueries

close()

Close httplib2 connections.

create(parent, body=None, x__xgafv=None)

Submit a query at host level to be processed in the background. If the submission of the query succeeds, the API returns a 201 status and an ID that refer to the query. In addition to the HTTP status 201, the `state` of "enqueued" means that the request succeeded.

Args:
  parent: string, Required. The parent resource name. Must be of the form `organizations/{org}`. (required)
  body: object, The request body.
    The object takes the form of:

{
  "csvDelimiter": "A String", # Delimiter used in the CSV file, if `outputFormat` is set to `csv`. Defaults to the `,` (comma) character. Supported delimiter characters include comma (`,`), pipe (`|`), and tab (`\t`).
  "dimensions": [ # A list of dimensions. https://docs.apigee.com/api-platform/analytics/analytics-reference#dimensions
    "A String",
  ],
  "envgroupHostname": "A String", # Hostname needs to be specified if query intends to run at host level. This field is only allowed when query is submitted by CreateHostAsyncQuery where analytics data will be grouped by organization and hostname.
  "filter": "A String", # Boolean expression that can be used to filter data. Filter expressions can be combined using AND/OR terms and should be fully parenthesized to avoid ambiguity. See Analytics metrics, dimensions, and filters reference https://docs.apigee.com/api-platform/analytics/analytics-reference for more information on the fields available to filter on. For more information on the tokens that you use to build filter expressions, see Filter expression syntax. https://docs.apigee.com/api-platform/analytics/asynch-reports-api#filter-expression-syntax
  "groupByTimeUnit": "A String", # Time unit used to group the result set. Valid values include: second, minute, hour, day, week, or month. If a query includes groupByTimeUnit, then the result is an aggregation based on the specified time unit and the resultant timestamp does not include milliseconds precision. If a query omits groupByTimeUnit, then the resultant timestamp includes milliseconds precision.
  "limit": 42, # Maximum number of rows that can be returned in the result.
  "metrics": [ # A list of Metrics.
    { # More info about Metric: https://docs.apigee.com/api-platform/analytics/analytics-reference#metrics
      "alias": "A String", # Alias for the metric. Alias will be used to replace metric name in query results.
      "function": "A String", # Aggregation function: avg, min, max, or sum.
      "name": "A String", # Required. Metric name.
      "operator": "A String", # One of `+`, `-`, `/`, `%`, `*`.
      "value": "A String", # Operand value should be provided when operator is set.
    },
  ],
  "name": "A String", # Asynchronous Query Name.
  "outputFormat": "A String", # Valid values include: `csv` or `json`. Defaults to `json`. Note: Configure the delimiter for CSV output using the csvDelimiter property.
  "reportDefinitionId": "A String", # Asynchronous Report ID.
  "timeRange": "", # Required. Time range for the query. Can use the following predefined strings to specify the time range: `last60minutes` `last24hours` `last7days` Or, specify the timeRange as a structure describing start and end timestamps in the ISO format: yyyy-mm-ddThh:mm:ssZ. Example: "timeRange": { "start": "2018-07-29T00:13:00Z", "end": "2018-08-01T00:18:00Z" }
}

  x__xgafv: string, V1 error format.
    Allowed values
      1 - v1 error format
      2 - v2 error format

Returns:
  An object of the form:

    {
  "created": "A String", # Creation time of the query.
  "envgroupHostname": "A String", # Hostname is available only when query is executed at host level.
  "error": "A String", # Error is set when query fails.
  "executionTime": "A String", # ExecutionTime is available only after the query is completed.
  "name": "A String", # Asynchronous Query Name.
  "queryParams": { # Contains information like metrics, dimenstions etc of the AsyncQuery.
    "dimensions": [ # Dimensions of the AsyncQuery.
      "A String",
    ],
    "endTimestamp": "A String", # End timestamp of the query range.
    "metrics": [ # Metrics of the AsyncQuery. Example: ["name:message_count,func:sum,alias:sum_message_count"]
      "A String",
    ],
    "outputFormat": "A String", # Output format.
    "startTimestamp": "A String", # Start timestamp of the query range.
    "timeUnit": "A String", # Query GroupBy time unit.
  },
  "reportDefinitionId": "A String", # Asynchronous Report ID.
  "result": { # Result is available only after the query is completed.
    "expires": "A String", # Query result will be unaccessable after this time.
    "self": "A String", # Self link of the query results. Example: `/organizations/myorg/environments/myenv/queries/9cfc0d85-0f30-46d6-ae6f-318d0cb961bd/result` or following format if query is running at host level: `/organizations/myorg/hostQueries/9cfc0d85-0f30-46d6-ae6f-318d0cb961bd/result`
  },
  "resultFileSize": "A String", # ResultFileSize is available only after the query is completed.
  "resultRows": "A String", # ResultRows is available only after the query is completed.
  "self": "A String", # Self link of the query. Example: `/organizations/myorg/environments/myenv/queries/9cfc0d85-0f30-46d6-ae6f-318d0cb961bd` or following format if query is running at host level: `/organizations/myorg/hostQueries/9cfc0d85-0f30-46d6-ae6f-318d0cb961bd`
  "state": "A String", # Query state could be "enqueued", "running", "completed", "failed".
  "updated": "A String", # Last updated timestamp for the query.
}

get(name, x__xgafv=None)

Get status of a query submitted at host level. If the query is still in progress, the `state` is set to "running" After the query has completed successfully, `state` is set to "completed"

Args:
  name: string, Required. Name of the asynchronous query to get. Must be of the form `organizations/{org}/queries/{queryId}`. (required)
  x__xgafv: string, V1 error format.
    Allowed values
      1 - v1 error format
      2 - v2 error format

Returns:
  An object of the form:

    {
  "created": "A String", # Creation time of the query.
  "envgroupHostname": "A String", # Hostname is available only when query is executed at host level.
  "error": "A String", # Error is set when query fails.
  "executionTime": "A String", # ExecutionTime is available only after the query is completed.
  "name": "A String", # Asynchronous Query Name.
  "queryParams": { # Contains information like metrics, dimenstions etc of the AsyncQuery.
    "dimensions": [ # Dimensions of the AsyncQuery.
      "A String",
    ],
    "endTimestamp": "A String", # End timestamp of the query range.
    "metrics": [ # Metrics of the AsyncQuery. Example: ["name:message_count,func:sum,alias:sum_message_count"]
      "A String",
    ],
    "outputFormat": "A String", # Output format.
    "startTimestamp": "A String", # Start timestamp of the query range.
    "timeUnit": "A String", # Query GroupBy time unit.
  },
  "reportDefinitionId": "A String", # Asynchronous Report ID.
  "result": { # Result is available only after the query is completed.
    "expires": "A String", # Query result will be unaccessable after this time.
    "self": "A String", # Self link of the query results. Example: `/organizations/myorg/environments/myenv/queries/9cfc0d85-0f30-46d6-ae6f-318d0cb961bd/result` or following format if query is running at host level: `/organizations/myorg/hostQueries/9cfc0d85-0f30-46d6-ae6f-318d0cb961bd/result`
  },
  "resultFileSize": "A String", # ResultFileSize is available only after the query is completed.
  "resultRows": "A String", # ResultRows is available only after the query is completed.
  "self": "A String", # Self link of the query. Example: `/organizations/myorg/environments/myenv/queries/9cfc0d85-0f30-46d6-ae6f-318d0cb961bd` or following format if query is running at host level: `/organizations/myorg/hostQueries/9cfc0d85-0f30-46d6-ae6f-318d0cb961bd`
  "state": "A String", # Query state could be "enqueued", "running", "completed", "failed".
  "updated": "A String", # Last updated timestamp for the query.
}

getResult(name, x__xgafv=None)

After the query is completed, use this API to retrieve the results. If the request succeeds, and there is a non-zero result set, the result is downloaded to the client as a zipped JSON file. The name of the downloaded file will be: OfflineQueryResult-.zip Example: `OfflineQueryResult-9cfc0d85-0f30-46d6-ae6f-318d0cb961bd.zip`

Args:
  name: string, Required. Name of the asynchronous query result to get. Must be of the form `organizations/{org}/queries/{queryId}/result`. (required)
  x__xgafv: string, V1 error format.
    Allowed values
      1 - v1 error format
      2 - v2 error format

Returns:
  An object of the form:

    { # Message that represents an arbitrary HTTP body. It should only be used for payload formats that can't be represented as JSON, such as raw binary or an HTML page. This message can be used both in streaming and non-streaming API methods in the request as well as the response. It can be used as a top-level request field, which is convenient if one wants to extract parameters from either the URL or HTTP template into the request fields and also want access to the raw HTTP body. Example: message GetResourceRequest { // A unique request id. string request_id = 1; // The raw HTTP body is bound to this field. google.api.HttpBody http_body = 2; } service ResourceService { rpc GetResource(GetResourceRequest) returns (google.api.HttpBody); rpc UpdateResource(google.api.HttpBody) returns (google.protobuf.Empty); } Example with streaming methods: service CaldavService { rpc GetCalendar(stream google.api.HttpBody) returns (stream google.api.HttpBody); rpc UpdateCalendar(stream google.api.HttpBody) returns (stream google.api.HttpBody); } Use of this type only changes how the request and response bodies are handled, all other features will continue to work unchanged.
  "contentType": "A String", # The HTTP Content-Type header value specifying the content type of the body.
  "data": "A String", # The HTTP request/response body as raw binary.
  "extensions": [ # Application specific response metadata. Must be set in the first response for streaming APIs.
    {
      "a_key": "", # Properties of the object. Contains field @type with type URL.
    },
  ],
}

getResultView(name, x__xgafv=None)

Args:
  name: string, Required. Name of the asynchronous query result view to get. Must be of the form `organizations/{org}/queries/{queryId}/resultView`. (required)
  x__xgafv: string, V1 error format.
    Allowed values
      1 - v1 error format
      2 - v2 error format

Returns:
  An object of the form:

    {
  "code": 42, # Error code when there is a failure.
  "error": "A String", # Error message when there is a failure.
  "metadata": { # Metadata contains information like metrics, dimenstions etc of the AsyncQuery.
    "dimensions": [ # Dimensions of the AsyncQuery.
      "A String",
    ],
    "endTimestamp": "A String", # End timestamp of the query range.
    "metrics": [ # Metrics of the AsyncQuery. Example: ["name:message_count,func:sum,alias:sum_message_count"]
      "A String",
    ],
    "outputFormat": "A String", # Output format.
    "startTimestamp": "A String", # Start timestamp of the query range.
    "timeUnit": "A String", # Query GroupBy time unit.
  },
  "rows": [ # Rows of query result. Each row is a JSON object. Example: {sum(message_count): 1, developer_app: "(not set)",…}
    "",
  ],
  "state": "A String", # State of retrieving ResultView.
}

list(parent, dataset=None, envgroupHostname=None, from=None, inclQueriesWithoutReport=None, status=None, submittedBy=None, to=None, x__xgafv=None)

Return a list of Asynchronous Queries at host level.

Args:
  parent: string, Required. The parent resource name. Must be of the form `organizations/{org}`. (required)
  dataset: string, Filter response list by dataset. Example: `api`, `mint`
  envgroupHostname: string, Required. Filter response list by hostname.
  from: string, Filter response list by returning asynchronous queries that created after this date time. Time must be in ISO date-time format like '2011-12-03T10:15:30Z'.
  inclQueriesWithoutReport: string, Flag to include asynchronous queries that don't have a report denifition.
  status: string, Filter response list by asynchronous query status.
  submittedBy: string, Filter response list by user who submitted queries.
  to: string, Filter response list by returning asynchronous queries that created before this date time. Time must be in ISO date-time format like '2011-12-03T10:16:30Z'.
  x__xgafv: string, V1 error format.
    Allowed values
      1 - v1 error format
      2 - v2 error format

Returns:
  An object of the form:

    { # The response for ListAsyncQueries.
  "queries": [ # The asynchronous queries belong to requested resource name.
    {
      "created": "A String", # Creation time of the query.
      "envgroupHostname": "A String", # Hostname is available only when query is executed at host level.
      "error": "A String", # Error is set when query fails.
      "executionTime": "A String", # ExecutionTime is available only after the query is completed.
      "name": "A String", # Asynchronous Query Name.
      "queryParams": { # Contains information like metrics, dimenstions etc of the AsyncQuery.
        "dimensions": [ # Dimensions of the AsyncQuery.
          "A String",
        ],
        "endTimestamp": "A String", # End timestamp of the query range.
        "metrics": [ # Metrics of the AsyncQuery. Example: ["name:message_count,func:sum,alias:sum_message_count"]
          "A String",
        ],
        "outputFormat": "A String", # Output format.
        "startTimestamp": "A String", # Start timestamp of the query range.
        "timeUnit": "A String", # Query GroupBy time unit.
      },
      "reportDefinitionId": "A String", # Asynchronous Report ID.
      "result": { # Result is available only after the query is completed.
        "expires": "A String", # Query result will be unaccessable after this time.
        "self": "A String", # Self link of the query results. Example: `/organizations/myorg/environments/myenv/queries/9cfc0d85-0f30-46d6-ae6f-318d0cb961bd/result` or following format if query is running at host level: `/organizations/myorg/hostQueries/9cfc0d85-0f30-46d6-ae6f-318d0cb961bd/result`
      },
      "resultFileSize": "A String", # ResultFileSize is available only after the query is completed.
      "resultRows": "A String", # ResultRows is available only after the query is completed.
      "self": "A String", # Self link of the query. Example: `/organizations/myorg/environments/myenv/queries/9cfc0d85-0f30-46d6-ae6f-318d0cb961bd` or following format if query is running at host level: `/organizations/myorg/hostQueries/9cfc0d85-0f30-46d6-ae6f-318d0cb961bd`
      "state": "A String", # Query state could be "enqueued", "running", "completed", "failed".
      "updated": "A String", # Last updated timestamp for the query.
    },
  ],
}