Data qualities
API for triggering data quality computations and retrieving global results to assess the quality of your datasets.
Endpoints
For new integrations, and when updating your existing integrations, use:
-
POST data-governance/data-qualities/computations
Triggers a full data quality computation for a dataset, running profile calculation followed by data quality
assessment. Returns a computationId that can be used to track progress via the computation status endpoint
(GET /data-qualities/computations/{computationId}). The computation runs asynchronously.
Poll the status endpoint until status is SUCCEEDED or FAILED.
Facts
Request Body
Required- application/json object
Request payload for triggering a data quality computation. The
connectionIdis optional for file-based datasets. If none of the sampling parameters are provided, the following defaults apply:executionMode: PULLUPsampleMode: ABSOLUTEsampleSize: 1000
application/json properties
- datasetId stringRequired
The ID of the dataset
- connectionId string
The ID of the connection
- sampleMode string
Specifies how the dataset is sampled.
ABSOLUTErepresents a fixed number of rows, whileRELATIVErefers to a percentage of the total dataset rows.Can be one of: "ABSOLUTE""RELATIVE"
- sampleSize integer
The actual value of the selected sampling method size (either a fixed number for
ABSOLUTEmode or a percentage forRELATIVEmode). Maximum allowed value forABSOLUTEmode is100000. - executionMode string
Specifies where the data quality computation takes place. In
PUSHDOWNmode, it runs within the Cloud Data Warehouse (e.g., Snowflake, Databricks), whereas inPULLUPmode, it runs in Qlik Cloud.Can be one of: "PUSHDOWN""PULLUP"
Responses
202
Computation triggered. The response body contains the computationId for tracking progress.
- application/json object
Response returned when a data quality computation is successfully triggered.
application/json properties
- computationId stringRequired
The unique identifier of the triggered computation. Use this value to poll for status.
-
400
The request is in incorrect format.
- application/json object
application/json properties
- errors array of objects
errors properties
- code string
- title string
- detail string
-
- traceId string
-
401
User does not have valid authentication credentials.
- application/json object
application/json properties
- errors array of objects
errors properties
- code string
- title string
- detail string
-
- traceId string
-
403
User does not have access to the resource.
- application/json object
application/json properties
- errors array of objects
errors properties
- code string
- title string
- detail string
-
- traceId string
-
500
Internal Server Error.
- application/json object
application/json properties
- errors array of objects
errors properties
- code string
- title string
- detail string
-
- traceId string
-
503
Requested service is not available.
- application/json object
application/json properties
- errors array of objects
errors properties
- code string
- title string
- detail string
-
- traceId string
-
import { createQlikApi } from '@qlik/api'
const qlik = createQlikApi({ hostConfig: { host: 'https://{tenant}.{region}.qlikcloud.com', apiKey: '<access-token>', },})
await qlik.dataQualities.triggerDataQualitiesComputation( { connectionId: '2b855c3d-426c-4aac-90cf-0edf9fc294d3', datasetId: '669144f5aa2d642638ef1dd0', executionMode: 'PULLUP', sampleMode: 'ABSOLUTE', sampleSize: 10000, },)# qlik-cli has not implemented support for POST /api/v1/data-qualities/computations yet.curl "https://{tenant}.{region}.qlikcloud.com/api/v1/data-qualities/computations" \-X POST \-H "Content-type: application/json" \-H "Authorization: Bearer <access_token>" \-d '{"datasetId":"669144f5aa2d642638ef1dd0","sampleMode":"ABSOLUTE","sampleSize":10000,"connectionId":"2b855c3d-426c-4aac-90cf-0edf9fc294d3","executionMode":"PULLUP"}'Example Response
{ "computationId": "string"}For new integrations, and when updating your existing integrations, use:
-
GET data-governance/data-qualities/computations/{computationId}
Retrieves the current execution status of a data quality computation. Poll this endpoint after triggering a
computation to determine when results are available. The status field returns one of REQUESTED,
SUBMITTED, PROFILE_REQUESTED, SUCCEEDED, FAILED, or PROFILE_FAILED.
Facts
Path Parameters
- computationId stringRequired
The unique identifier of the computation, as returned by
POST /data-governance/data-qualities/computations.
Responses
200
Current execution status of the computation
- application/json object
application/json properties
- status stringRequired
Can be one of: "PROFILE_REQUESTED""PROFILE_FAILED""REQUESTED""SUBMITTED""SUCCEEDED""FAILED"
-
400
The request is in incorrect format.
- application/json object
application/json properties
- errors array of objects
errors properties
- code string
- title string
- detail string
-
- traceId string
-
401
User does not have valid authentication credentials.
- application/json object
application/json properties
- errors array of objects
errors properties
- code string
- title string
- detail string
-
- traceId string
-
403
User does not have access to the resource.
- application/json object
application/json properties
- errors array of objects
errors properties
- code string
- title string
- detail string
-
- traceId string
-
404
No computation found with the specified computationId.
- application/json object
application/json properties
- errors array of objects
errors properties
- code string
- title string
- detail string
-
- traceId string
-
500
Internal Server Error.
- application/json object
application/json properties
- errors array of objects
errors properties
- code string
- title string
- detail string
-
- traceId string
-
503
Requested service is not available.
- application/json object
application/json properties
- errors array of objects
errors properties
- code string
- title string
- detail string
-
- traceId string
-
import { createQlikApi } from '@qlik/api'
const qlik = createQlikApi({ hostConfig: { host: 'https://{tenant}.{region}.qlikcloud.com', apiKey: '<access-token>', },})
await qlik.dataQualities.getDataQualitiesComputation( '4db06daa-3117-412e-8fb4-b29c937f9a0e',)# qlik-cli has not implemented support for GET /api/v1/data-qualities/computations/{computationId} yet.curl "https://{tenant}.{region}.qlikcloud.com/api/v1/data-qualities/computations/{computationId}" \-H "Authorization: Bearer <access_token>"Example Response
{ "status": "PROFILE_REQUESTED"}For new integrations, and when updating your existing integrations, use:
-
GET data-governance/data-qualities/global-results
Retrieves the global quality results for a dataset, showing counts of valid, invalid, empty, and total sample cells.
Facts
Query Parameters
- datasetId stringRequired
The unique identifier of the dataset.
- connectionId string
The unique identifier of the connection.
Responses
200
Global quality results for the dataset, including counts of valid, invalid, empty, and total sample cells per connection.
- application/json object
application/json properties
- datasetId stringRequired
The unique identifier of the dataset.
- qualities array of objectsRequired
qualities properties
- quality objectRequired
quality properties
- empty integerRequired
Number of empty sample cells.
- total integerRequired
Total number of cells in the sample.
- valid integerRequired
Number of valid sample cells.
- invalid integerRequired
Number of invalid sample cells.
- updatedAt stringRequired
Timestamp of the most recent data quality computation for this dataset and connection.
-
- connectionId stringRequired
The unique identifier of the connection.
-
-
400
The request is in incorrect format.
- application/json object
application/json properties
- errors array of objects
errors properties
- code string
- title string
- detail string
-
- traceId string
-
401
User does not have valid authentication credentials.
- application/json object
application/json properties
- errors array of objects
errors properties
- code string
- title string
- detail string
-
- traceId string
-
403
User does not have access to the resource.
- application/json object
application/json properties
- errors array of objects
errors properties
- code string
- title string
- detail string
-
- traceId string
-
404
No quality results found for the specified dataset.
- application/json object
application/json properties
- errors array of objects
errors properties
- code string
- title string
- detail string
-
- traceId string
-
500
Internal Server Error.
- application/json object
application/json properties
- errors array of objects
errors properties
- code string
- title string
- detail string
-
- traceId string
-
503
Requested service is not available.
- application/json object
application/json properties
- errors array of objects
errors properties
- code string
- title string
- detail string
-
- traceId string
-
import { createQlikApi } from '@qlik/api'
const qlik = createQlikApi({ hostConfig: { host: 'https://{tenant}.{region}.qlikcloud.com', apiKey: '<access-token>', },})
await qlik.dataQualities.getDataQualitiesGlobalResults( { datasetId: 'string' },)# qlik-cli has not implemented support for GET /api/v1/data-qualities/global-results yet.curl "https://{tenant}.{region}.qlikcloud.com/api/v1/data-qualities/global-results" \-H "Authorization: Bearer <access_token>"Example Response
{ "datasetId": "string", "qualities": [ { "quality": { "empty": 42, "total": 42, "valid": 42, "invalid": 42, "updatedAt": "2018-10-30T07:06:22Z" }, "connectionId": "string" } ]}