Web API: Expression/query

The Analysis operation runs a query in the server and returns the query results.

Form of the url is https://SERVER/qprpa/api/analysis/33 where SERVER is the DNS name to access QPR ProcessAnalyzer server. (The 33 is the number of the analysis which is the one mostly used. This documentation only covers using the analysis type 33.)

HTTP request header Authorization with value Bearer <access token> needs to be in place to identify the session.

The request body is a JSON object containing key-value pairs as properties. Available properties are described in the Expression Analysis parameters. Note that all keys are strings, so JSON values need to be stringified.

Returns Example:

url: https://SERVER/qprpa/api/analysis/33
Body:
{
  Configuration: "{\"Root\":\"Cases\","Dimensions\":[{\"name\":\"Case Duration\",\"expression\":\"Duration.ToInteger(TotalDays)\"}],\"Values\":[{\"name\":\"Case count\",\"expression\":\"Count(_)\"}],\"Ordering\":[{\"Name\":\"Case Duration\",\"Direction\":\"Ascending\"}]",
  Filter: "{"Items":[{\"Type\":\"IncludeCases\",\"Items\":[{\"Type\":\"CaseAttributeValue\",\"Attribute\":\"Account Manager\",\"Values\":[\"Patricia White\",\"Rober Miller\"]}]}]}",
  ModelId: "123",
  QueryIdentifier: "myQuery1",
  CancelEarlierQueriesWithIdentifier: "true"
}

Response is a JSON object with several properties. The Contents property contains the result data. The Contents property is an object with properties Columns and Rows.

Example:

{
  "Contents": {
    "Columns": [
      {
        "Caption": "dim"
      },
      {
        "Caption": "mea"
      }
    ],
  "Rows": [
      ["50", "4237"], ["51", "4213"], ["52", "4201"], ["53", "4209"], ["54", "4431"], ["55", "42043"]
  ]
}