Data Reconciliation

Get Data Reconciliation

Endpoint to retrieve a single Data Reconciliation by ID

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

Request

Path parameters

idstring uuid required

ID of the Data Reconciliation to retrieve

Request body

Example request

{
  "select": {
    "_id": true,
    "createdAt": true,
    "updatedAt": true,
    "name": true,
    "toleranceType": true,
    "sourceMeasure": true,
    "sourceColumnName": true,
    "targetMeasure": 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",
    "name": "Orders: app vs warehouse",
    "description": "This is an example of longer text content that might be stored in this field.",
    "intervalInMinutes": 42,
    "toleranceType": "Percent",
    "tolerance": 42,
    "sourceDataAssetId": "123e4567-e89b-12d3-a456-426614174000",
    "sourceMeasure": "Row Count",
    "sourceColumnName": "amount",
    "sourceCustomSql": "This is an example of very long text content that might be stored in this field. It can contain a lot of information, such as detailed descriptions, comments, or any other lengthy text data that needs to be stored in the database.",
    "sourceDataCheckId": "123e4567-e89b-12d3-a456-426614174000",
    "sourceValue": 42,
    "targetDataAssetId": "123e4567-e89b-12d3-a456-426614174000",
    "targetMeasure": "Row Count",
    "targetColumnName": "amount",
    "targetCustomSql": "This is an example of very long text content that might be stored in this field. It can contain a lot of information, such as detailed descriptions, comments, or any other lengthy text data that needs to be stored in the database.",
    "targetDataCheckId": "123e4567-e89b-12d3-a456-426614174000",
    "targetValue": 42,
    "difference": 42,
    "differencePercent": 42,
    "status": "In Step",
    "statusMessage": "This is an example of longer text content that might be stored in this field.",
    "comparedAt": {
      "_type": "DateTime",
      "value": "2023-10-01T12:00:00Z"
    },
    "statusChangedAt": {
      "_type": "DateTime",
      "value": "2023-10-01T12:00:00Z"
    },
    "monitorId": "123e4567-e89b-12d3-a456-426614174000",
    "createdByUserId": "123e4567-e89b-12d3-a456-426614174000"
  }
}

Changes

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