Jump to

• Request
• Response

Create or Execute an Analytics Query

post

/ic/api/process/v1/analyticsqueries

Create an analytics query or Execute an analytic query without saving.

Request

Supported Media Types

• application/json

Query Parameters

• action: string
  action value to execute or not

Body ()

Business Query Payload

Root Schema : BusinessQuery

Type: object

Show Source

• activityName: string
• aggregation: string
• dimensions: array dimensions
• doName: string
• entityAttributes: array entityAttributes
• filters: array filters
• measureName: string
• measureType: string
  Allowed Values: [ "COUNTER", "MEASURE" ]
• queryType: string
  Allowed Values: [ "TACTICAL", "REAL_TIME" ]
• transientAttributes: object transientAttributes
  Additional Properties Allowed: additionalProperties

{
    "type":"object",
    "properties":{
        "measureName":{
            "type":"string"
        },
        "aggregation":{
            "type":"string"
        },
        "measureType":{
            "type":"string",
            "enum":[
                "COUNTER",
                "MEASURE"
            ]
        },
        "doName":{
            "type":"string"
        },
        "queryType":{
            "type":"string",
            "enum":[
                "TACTICAL",
                "REAL_TIME"
            ]
        },
        "filters":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/Filter"
            }
        },
        "dimensions":{
            "type":"array",
            "items":{
                "type":"string"
            }
        },
        "activityName":{
            "type":"string"
        },
        "transientAttributes":{
            "type":"object",
            "additionalProperties":{
                "type":"object"
            }
        },
        "entityAttributes":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/AttrObject"
            }
        }
    }
}

Nested Schema : dimensions

Type: array

Show Source

• Array of: string

{
    "type":"array",
    "items":{
        "type":"string"
    }
}

Nested Schema : entityAttributes

Type: array

Show Source

• Array of: object AttrObject

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/AttrObject"
    }
}

Nested Schema : filters

Type: array

Show Source

• Array of: object Filter

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/Filter"
    }
}

Nested Schema : transientAttributes

Type: object

Additional Properties Allowed

Show Source

• object additionalProperties

{
    "type":"object",
    "additionalProperties":{
        "type":"object"
    }
}

Nested Schema : AttrObject

Type: object

Show Source

• attrType: string
  Allowed Values: [ "VALUE", "REF" ]
• contentType: string
  Allowed Values: [ "OBJECT", "NATIVE_OBJECT", "LIST", "SORTED_LIST", "MAP" ]
• defaultValue: object defaultValue
• id: string
• msg: object Msg

{
    "type":"object",
    "properties":{
        "msg":{
            "$ref":"#/definitions/Msg"
        },
        "attrType":{
            "type":"string",
            "enum":[
                "VALUE",
                "REF"
            ]
        },
        "contentType":{
            "type":"string",
            "enum":[
                "OBJECT",
                "NATIVE_OBJECT",
                "LIST",
                "SORTED_LIST",
                "MAP"
            ]
        },
        "id":{
            "type":"string"
        },
        "defaultValue":{
            "type":"object"
        }
    }
}

Nested Schema : defaultValue

Type: object

Nested Schema : Msg

Type: object

Show Source

• allAvailableTranslationsForProjectLanguages: object allAvailableTranslationsForProjectLanguages
  Additional Properties Allowed: additionalProperties
• argCount: integer(int32)
• bundleName: string
• bundleShortName: string
• code: string
• detail: string
• imageFile: string
• imageResource: string(url)
• localizedLogMessage: string
• logComponent: string
  Allowed Values: [ "DEFAULT" ]
• mnemonic: string
• nonLocalizedString: string
• string: string

{
    "type":"object",
    "properties":{
        "code":{
            "type":"string"
        },
        "logComponent":{
            "type":"string",
            "enum":[
                "DEFAULT"
            ]
        },
        "argCount":{
            "type":"integer",
            "format":"int32"
        },
        "string":{
            "type":"string"
        },
        "detail":{
            "type":"string"
        },
        "allAvailableTranslationsForProjectLanguages":{
            "type":"object",
            "additionalProperties":{
                "type":"string"
            }
        },
        "mnemonic":{
            "type":"string"
        },
        "localizedLogMessage":{
            "type":"string"
        },
        "imageFile":{
            "type":"string"
        },
        "imageResource":{
            "type":"string",
            "format":"url"
        },
        "nonLocalizedString":{
            "type":"string"
        },
        "bundleShortName":{
            "type":"string"
        },
        "bundleName":{
            "type":"string"
        }
    }
}

Nested Schema : allAvailableTranslationsForProjectLanguages

Type: object

Additional Properties Allowed

Show Source

• string

{
    "type":"object",
    "additionalProperties":{
        "type":"string"
    }
}

Nested Schema : Filter

Type: object

Show Source

• conditionalType: string
  Allowed Values: [ "GREATER_THAN", "GREATER_THAN_EQUALS_TO", "LESS_THAN_EQUALS_TO", "EQUALS_TO", "LESS_THAN", "NEVER", "ALWAYS" ]
• conditionalValue: string
• entityAttributes: array entityAttributes
• transientAttributes: object transientAttributes
  Additional Properties Allowed: additionalProperties
• variable: string

{
    "type":"object",
    "properties":{
        "conditionalType":{
            "type":"string",
            "enum":[
                "GREATER_THAN",
                "GREATER_THAN_EQUALS_TO",
                "LESS_THAN_EQUALS_TO",
                "EQUALS_TO",
                "LESS_THAN",
                "NEVER",
                "ALWAYS"
            ]
        },
        "conditionalValue":{
            "type":"string"
        },
        "variable":{
            "type":"string"
        },
        "transientAttributes":{
            "type":"object",
            "additionalProperties":{
                "type":"object"
            }
        },
        "entityAttributes":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/AttrObject"
            }
        }
    }
}

Nested Schema : entityAttributes

Type: array

Show Source

• Array of: object AttrObject

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/AttrObject"
    }
}

Nested Schema : transientAttributes

Type: object

Additional Properties Allowed

Show Source

• object additionalProperties

{
    "type":"object",
    "additionalProperties":{
        "type":"object"
    }
}

Nested Schema : additionalProperties

Type: object

Nested Schema : additionalProperties

Type: object

Back to Top

Response

Supported Media Types

• application/json

200 Response

successful operation

Body ()

Root Schema : Link

Type: object

Show Source

• href: string
• mediaType: string
• rel: string

{
    "type":"object",
    "properties":{
        "rel":{
            "type":"string"
        },
        "href":{
            "type":"string"
        },
        "mediaType":{
            "type":"string"
        }
    }
}

201 Response

Created

Body ()

Root Schema : analyticsResult

Type: object

Show Source

• columnsInfo: array columnsInfo
• rows: array rows

{
    "type":"object",
    "properties":{
        "columnsInfo":{
            "type":"array",
            "items":{
                "xml":{
                    "name":"columnsInfo"
                },
                "$ref":"#/definitions/ColumnMetadata"
            }
        },
        "rows":{
            "type":"array",
            "items":{
                "xml":{
                    "name":"rows"
                },
                "$ref":"#/definitions/Row"
            }
        }
    },
    "xml":{
        "name":"analyticsResult",
        "namespace":"http://xmlns.oracle.com/bpm/rest/analyticsResult"
    }
}

Nested Schema : columnsInfo

Type: array

Show Source

• Array of: object ColumnMetadata

{
    "type":"array",
    "items":{
        "xml":{
            "name":"columnsInfo"
        },
        "$ref":"#/definitions/ColumnMetadata"
    }
}

Nested Schema : rows

Type: array

Show Source

• Array of: object Row

{
    "type":"array",
    "items":{
        "xml":{
            "name":"rows"
        },
        "$ref":"#/definitions/Row"
    }
}

Nested Schema : ColumnMetadata

Type: object

Show Source

• columnName: string
• type: string

{
    "type":"object",
    "properties":{
        "columnName":{
            "type":"string"
        },
        "type":{
            "type":"string"
        }
    }
}

Nested Schema : Row

Type: object

Show Source

• values: array values

{
    "type":"object",
    "properties":{
        "values":{
            "type":"array",
            "items":{
                "type":"object"
            }
        }
    }
}

Nested Schema : values

Type: array

Show Source

• Array of: object items

{
    "type":"array",
    "items":{
        "type":"object"
    }
}

Nested Schema : items

Type: object

400 Response

Bad Request

401 Response

Unauthorized

500 Response

Internal Server Error

Back to Top