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(optional): string
  action value to execute or not

Body ()

Business Query Payload

Root Schema : BusinessQuery

Type: object

Show Source

• activityName(optional): string
• aggregation(optional): string
• dimensions(optional): array dimensions
• doName(optional): string
• entityAttributes(optional): array entityAttributes
• filters(optional): array filters
• measureName(optional): string
• measureType(optional): string
  Allowed Values: [ "COUNTER", "MEASURE" ]
• queryType(optional): string
  Allowed Values: [ "TACTICAL", "REAL_TIME" ]
• transientAttributes(optional): 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(optional): string
  Allowed Values: [ "VALUE", "REF" ]
• contentType(optional): string
  Allowed Values: [ "OBJECT", "NATIVE_OBJECT", "LIST", "SORTED_LIST", "MAP" ]
• defaultValue(optional): object defaultValue
• id(optional): string
• msg(optional): 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(optional): object allAvailableTranslationsForProjectLanguages
  Additional Properties Allowed: additionalProperties
• argCount(optional): integer(int32)
• bundleName(optional): string
• bundleShortName(optional): string
• code(optional): string
• detail(optional): string
• imageFile(optional): string
• imageResource(optional): string(url)
• localizedLogMessage(optional): string
• logComponent(optional): string
  Allowed Values: [ "DEFAULT" ]
• mnemonic(optional): string
• nonLocalizedString(optional): string
• string(optional): 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(optional): string
  Allowed Values: [ "GREATER_THAN", "GREATER_THAN_EQUALS_TO", "LESS_THAN_EQUALS_TO", "EQUALS_TO", "LESS_THAN", "NEVER", "ALWAYS" ]
• conditionalValue(optional): string
• entityAttributes(optional): array entityAttributes
• transientAttributes(optional): object transientAttributes
  Additional Properties Allowed: additionalProperties
• variable(optional): 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(optional): string
• mediaType(optional): string
• rel(optional): 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(optional): array columnsInfo
• rows(optional): 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(optional): string
• type(optional): string

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

Nested Schema : Row

Type: object

Show Source

• values(optional): 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