Data Check

Get Data Check

Endpoint to retrieve a single Data Check by ID

post/data-check/{id}/get-item

Request

Path parameters

idstring uuid required

ID of the Data Check to retrieve

Request body

Example request

{
  "select": {
    "_id": true,
    "createdAt": true,
    "updatedAt": true,
    "name": true,
    "checkType": true,
    "columnName": true,
    "segmentColumn": true,
    "formatPreset": true
  }
}

Response

Successful response

Example response

{
  "data": {
    "_id": "123e4567-e89b-12d3-a456-426614174000",
    "createdAt": {
      "_type": "DateTime",
      "value": "2023-10-01T12:00:00Z"
    },
    "updatedAt": {
      "_type": "DateTime",
      "value": "2023-10-01T12:00:00Z"
    },
    "deletedAt": {
      "_type": "DateTime",
      "value": "2023-10-01T12:00:00Z"
    },
    "version": 42,
    "projectId": "123e4567-e89b-12d3-a456-426614174000",
    "dataAssetId": "123e4567-e89b-12d3-a456-426614174000",
    "dataStoreId": "123e4567-e89b-12d3-a456-426614174000",
    "name": "Orders without a customer",
    "description": "Every order must belong to a customer.",
    "checkType": "Null Percent",
    "columnName": "customer_id",
    "segmentColumn": "tenant_id",
    "acceptedValues": {
      "key": "value",
      "nested": {
        "data": 123
      }
    },
    "pattern": "^[^@\\s]+@[^@\\s]+$",
    "formatPreset": "Email",
    "samplePercent": 42,
    "referenceTableKey": "public.customers",
    "referenceColumnName": "id",
    "customSql": "SELECT COUNT(*) FROM orders WHERE total < 0",
    "intervalInMinutes": 42,
    "isEnabled": true,
    "isManagedByFile": true,
    "alertCondition": "Unusually High",
    "alertThreshold": 42,
    "monitorId": "123e4567-e89b-12d3-a456-426614174000",
    "dataReconciliationId": "123e4567-e89b-12d3-a456-426614174000",
    "lastRunAt": {
      "_type": "DateTime",
      "value": "2023-10-01T12:00:00Z"
    },
    "lastRunStatus": "Example short text",
    "lastRunMessage": "This is an example of longer text content that might be stored in this field.",
    "lastValue": 42,
    "failingRowsSample": {
      "key": "value",
      "nested": {
        "data": 123
      }
    },
    "lastSegmentCount": 42,
    "externalId": "This is an example of longer text content that might be stored in this field.",
    "createdByUserId": "123e4567-e89b-12d3-a456-426614174000"
  }
}

Changes

No recorded changes to this operation across all 1 revision of this API.