(EXPERIMENTAL) Compute column statistics
(EXPERIMENTAL) Computes the requested statistical parameters of a column in a data source.
path Parameters
dataSourceIdstring · required
Request Body
columnNamestring · requiredfromrequired
frequencyobjecthistogramobjectstatisticsstring[] · uniqueEnum values:COUNTCOUNT_NULLCOUNT_UNIQUEAVGSTDDEVMINMAXPERCENTILE_25
Responses
OK
frequencyobjecthistogramobjectstatisticsobject[]warningsobject[]
(BETA) Valid descendants
(BETA) Returns map of lists of attributes that can be used as descendants of the given attributes.
path Parameters
workspaceIdstring · pattern:^(?!\.)[.A-Za-z0-9_-…· requiredWorkspace identifier
Request Body
attributesobject[] · requiredList of identifiers of the attributes to get the valid descendants for.
Responses
Map of lists of attributes valid as descendants of the given attributes.
validDescendantsobject · requiredMap of attribute identifiers to list of valid descendants identifiers.
Valid objects
Returns list containing attributes, facts, or metrics, which can be added to given AFM while still keeping it computable.
path Parameters
workspaceIdstring · pattern:^(?!\.)[.A-Za-z0-9_-…· requiredWorkspace identifier
Request Body
afmobject · requiredTop level executable entity. Combination of [A]ttributes, [F]ilters & [M]etrics.
typesstring[] · unique · requiredEnum values:factsattributesmeasuresExample: facts
Responses
List of attributes, facts and metrics valid with respect to given AFM.
itemsobject[] · required
Executes analytical request and returns link to the result
AFM is a combination of attributes, measures and filters that describe a query you want to execute.
path Parameters
workspaceIdstring · pattern:^(?!\.)[.A-Za-z0-9_-…· requiredWorkspace identifier
Headers
skip-cachebooleanIgnore all caches during execution of current request.
Default: falsetimestampstring · timestampTimestamp for the execution. Deprecated, use
settings.timestampin the request body.
Request Body
executionobject · requiredTop level executable entity. Combination of [A]ttributes, [F]ilters & [M]etrics.
resultSpecobject · requiredSpecifies how the result data will be formatted (
dimensions) and which additional data shall be computed (totals).
settingsobjectVarious settings affecting the process of AFM execution or its result
Responses
AFM Execution response with links to the result and server-enhanced dimensions from the original request.
executionResponseobject · requiredResponse to AFM execution request body
Get a single execution result
Gets a single execution result.
path Parameters
workspaceIdstring · pattern:^(?!\.)[.A-Za-z0-9_-…· requiredWorkspace identifier
resultIdstring · requiredResult ID
query Parameters
offsetinteger[] · style: formRequest page with these offsets. Format is offset=1,2,3,... - one offset for each dimensions in ResultSpec from originating AFM.
Default: []limitinteger[] · style: formReturn only this number of items. Format is limit=1,2,3,... - one limit for each dimensions in ResultSpec from originating AFM.
Default: []excludedTotalDimensionsstring[] · style: formIdentifiers of the dimensions where grand total data should not be returned for this request. A grand total will not be returned if all of its totalDimensions are in excludedTotalDimensions.
Default: []
Headers
X-GDC-CANCEL-TOKENstring
Responses
Execution result was found and returned.
dataobject[] · requiredA multi-dimensional array of computed results. The most common one being a 2-dimensional array. The arrays can be composed of Double or null values.
Example: [[1,2.5],[-1.3,3.14]]dimensionHeadersobject[] · requiredAn array containing dimension headers. The size of the array corresponds to the number of dimensions. Their order corresponds to the dimension order in the execution result spec.
grandTotalsobject[] · requiredmetadataobject · requiredAdditional metadata for the particular execution result.
pagingobject · requiredA paging information related to the data presented in the execution result. These paging information are multi-dimensional.
Get a single execution result's metadata.
The resource provides execution result's metadata as AFM and resultSpec used in execution request and an executionResponse
path Parameters
workspaceIdstring · pattern:^(?!\.)[.A-Za-z0-9_-…· requiredWorkspace identifier
resultIdstring · requiredResult ID
Responses
Execution result's metadata was found and returned.
afmobject · requiredTop level executable entity. Combination of [A]ttributes, [F]ilters & [M]etrics.
executionResponseobject · requiredResponse to AFM execution request body
resultSizeinteger · int64 · requiredresultSpecobject · requiredSpecifies how the result data will be formatted (
dimensions) and which additional data shall be computed (totals).
AFM explain resource.
The resource provides static structures needed for investigation of a problem with given AFM.
path Parameters
workspaceIdstring · pattern:^(?!\.)[.A-Za-z0-9_-…· requiredWorkspace identifier
query Parameters
explainTypestring · enumRequested explain type. If not specified all types are bundled in a ZIP archive.
MAQL- MAQL Abstract Syntax Tree, execution dimensions and related infoGRPC_MODEL- Datasets used in executionGRPC_MODEL_SVG- Generated SVG image of the datasetsCOMPRESSED_GRPC_MODEL_SVG- Generated SVG image of the model fragment used in the queryWDF- Workspace data filters in execution workspace contextQT- Query Tree, created from MAQL AST using Logical Data Model, contains all information needed to generate SQLQT_SVG- Generated SVG image of the Query TreeOPT_QT- Optimized Query TreeOPT_QT_SVG- Generated SVG image of the Optimized Query TreeSQL- Final SQL to be executedCOMPRESSED_SQL- Final SQL to be executed with rolled SQL datasetsSETTINGS- Settings used to execute explain requestEnum values:MAQLGRPC_MODELGRPC_MODEL_SVGWDFQTQT_SVGOPT_QTOPT_QT_SVG
Request Body
executionobject · requiredTop level executable entity. Combination of [A]ttributes, [F]ilters & [M]etrics.
resultSpecobject · requiredSpecifies how the result data will be formatted (
dimensions) and which additional data shall be computed (totals).
settingsobjectVarious settings affecting the process of AFM execution or its result
Responses
Requested resource
Listing of label values. The resulting data are limited by the static platform limit to the maximum of 10000 rows.
Returns paged list of elements (values) of given label satisfying given filtering criteria.
path Parameters
workspaceIdstring · pattern:^(?!\.)[.A-Za-z0-9_-…· requiredWorkspace identifier
query Parameters
offsetinteger · int32 · min: 0 · max: 10000Request page with this offset. Must be positive integer. The API is limited to the maximum of 10000 items. Therefore this parameter is limited to this number as well.
Default: 0limitinteger · int32 · min: 1 · max: 10000Return only this number of items. Must be positive integer. The API is limited to the maximum of 10000 items. Therefore this parameter is limited to this number as well.
Default: 1000
Headers
skip-cachebooleanIgnore all caches during execution of current request.
Default: false
Request Body
labelstring · pattern:^(?!\.)[.A-Za-z0-9_-…· requiredRequested label.
Example: label_id
cacheIdstringIf specified, the element data will be taken from the result with the same cacheId if it is available.
complementFilterbooleanInverse filters:
false- return items matchingpatternFilterandexactFiltertrue- return items not matchingpatternFilterandexactFilter
Default: falsedependsOnarrayReturn only items that are not filtered-out by the parent filters.
exactFilter(string | null)[]Return only items, whose
labeltitle exactly matches one offilter.excludePrimaryLabelbooleanExcludes items from the result that differ only by primary label
false- return items with distinct primary labeltrue- return items with distinct requested label
Default: falsefilterByobjectSpecifies what is used for filtering.
patternFilterstringReturn only items, whose
labeltitle case insensitively containsfilteras substring.sortOrderstring · enumSort order of returned items. Items are sorted by
labeltitle. If no sort order is specified then attribute'ssortDirectionis used, which is ASC by defaultEnum values:ASCDESCvalidateBy(object | null)[]Return only items that are computable on metric.
dataSamplingPercentagenumber · float · deprecated · requiredSpecifies percentage of source table data scanned during the computation. This field is deprecated and is no longer used during the elements computation.
Default: 100
Responses
List of label values.
elementsobject[] · requiredList of returned elements.
pagingobject · requiredCurrent page description.
primaryLabelobject · requiredObject identifier.
cacheIdstringThe client can use this in subsequent requests (like paging or search) to get results from the same point in time as the previous request. This is useful when the underlying data source has caches disabled and the client wants to avoid seeing inconsistent results and to also avoid excessive queries to the database itself.
formatobjectAttribute format describes formatting information to effectively format attribute values when needed.
granularitystring · enumGranularity of requested label in case of date attribute
Enum values:MINUTEHOURDAYWEEKMONTHQUARTERYEARMINUTE_OF_HOUR
Compute change analysis
Computes change analysis for the provided execution definition.
path Parameters
workspaceIdstring · pattern:^(?!\.)[.A-Za-z0-9_-…· requiredWorkspace identifier
Request Body
analyzedPeriodstring · requiredThe analyzed time period (e.g., '2025-02')
dateAttributeobject · requiredmeasureobject · requiredMetric is a quantity that is calculated from the data.
referencePeriodstring · requiredThe reference time period (e.g., '2025-01')
attributesobject[]Attributes to analyze for significant changes. If empty, valid attributes will be automatically discovered.
auxMeasuresobject[]Auxiliary measures
filtersarrayOptional filters to apply.
useSmartAttributeSelectionbooleanWhether to use smart attribute selection (LLM-based) instead of discovering all valid attributes. If true, GenAI will intelligently select the most relevant attributes for change analysis. If false or not set, all valid attributes will be discovered using Calcique. Smart attribute selection applies only when no attributes are provided.
Default: false
Responses
OK
linksobject · requiredLinks to the execution result.
(EXPERIMENTAL) Compute key driver analysis
(EXPERIMENTAL) Computes key driver analysis for the provided execution definition.
path Parameters
workspaceIdstring · pattern:^(?!\.)[.A-Za-z0-9_-…· requiredWorkspace identifier
Headers
skip-cachebooleanIgnore all caches during execution of current request.
Default: false
Request Body
metricobject · requiredMetric is a quantity that is calculated from the data.
auxMetricsobject[]Additional metrics to be included in the computation, but excluded from the analysis.
sortDirectionstring · enumSorting elements - ascending/descending order.
Enum values:ASCDESCDefault: DESC
Responses
OK
dimensionsobject[] · requiredlinksobject · requiredLinks to the execution result.
(BETA) Outlier Detection
(BETA) Computes outlier detection for the provided execution definition.
path Parameters
workspaceIdstring · pattern:^(?!\.)[.A-Za-z0-9_-…· requiredWorkspace identifier
Headers
skip-cachebooleanIgnore all caches during execution of current request.
Default: false
Request Body
attributesobject[] · requiredAttributes to be used in the computation.
filtersarray · requiredVarious filter types to filter the execution result.
granularitystring · enum · requiredDate granularity for anomaly detection. Only time-based granularities are supported (HOUR, DAY, WEEK, MONTH, QUARTER, YEAR).
Enum values:HOURDAYWEEKMONTHQUARTERYEARmeasuresobject[] · minItems: 1 · requiredsensitivitystring · enum · requiredSensitivity level for outlier detection
Enum values:LOWMEDIUMHIGH
auxMeasuresobject[]Metrics to be referenced from other AFM objects (e.g. filters) but not included in the result.
Responses
OK
linksobject · requiredLinks to the execution result.
(BETA) Outlier Detection Result
(BETA) Gets outlier detection result.
path Parameters
workspaceIdstring · pattern:^(?!\.)[.A-Za-z0-9_-…· requiredWorkspace identifier
resultIdstring · requiredResult ID
query Parameters
offsetinteger · int32limitinteger · int32
Responses
OK
attributearray | null · requiredAttribute values for outlier detection results.
valuesobject | null · requiredMap of measure identifiers to their outlier detection values. Each value is a list of nullable numbers.