Skip to main content
Solved

Load 'Failed records' to ONE Data via API

  • May 26, 2025
  • 1 reply
  • 19 views

Forum|alt.badge.img

In catalog item DQ evaluation, we are trying to run the DQ evaluation via API and it is working fine. Do we have an API to load the failed records to ONE data via API?

 

Best answer by Lisa Kovalskaia

@Hanish N this mutation will both trigger a DQ evaluation job and load the results into ONE Data:

mutation ImportCatalogItemDq($dmmEntity: DmmDqEntityInput!, $catalogItemId: GID!, $dqFilter: DmmDqFilter!, $importStrategy: DmmDqImportStrategy!) {
  dmmImportCatalogItemDQ(
    dmmEntity: $dmmEntity
    catalogItemId: $catalogItemId
    dqFilter: $dqFilter
    importStrategy: $importStrategy
  ) {
    dqJobState {
      reason
      gid
      executionType
      name
      entityId
      type
      status
      __typename
    }
    dmmDqJobError {
      errorCode
      __typename
    }
    __typename
  }
}

Assuming you always load to an existing ONE Data table, the variables might look like this:

{
  "dmmEntity": {
    "name": "target_ONE_Data_table(invalid records)",
    "description": "",
    "id": "a0b74cd0-7301-4396-b2b2-4dca571f7eec",
    "stewardshipGroup": null
  },
  "catalogItemId": "15bbce34-0000-7000-0000-0000001a0228",
  "dqFilter": "INVALID",
  "importStrategy": "OVERWRITE"
}

Let me know if you have any additional questions!

View original

Lisa Kovalskaia
Ataccamer
Forum|alt.badge.img+3

@Hanish N this mutation will both trigger a DQ evaluation job and load the results into ONE Data:

mutation ImportCatalogItemDq($dmmEntity: DmmDqEntityInput!, $catalogItemId: GID!, $dqFilter: DmmDqFilter!, $importStrategy: DmmDqImportStrategy!) {
  dmmImportCatalogItemDQ(
    dmmEntity: $dmmEntity
    catalogItemId: $catalogItemId
    dqFilter: $dqFilter
    importStrategy: $importStrategy
  ) {
    dqJobState {
      reason
      gid
      executionType
      name
      entityId
      type
      status
      __typename
    }
    dmmDqJobError {
      errorCode
      __typename
    }
    __typename
  }
}

Assuming you always load to an existing ONE Data table, the variables might look like this:

{
  "dmmEntity": {
    "name": "target_ONE_Data_table(invalid records)",
    "description": "",
    "id": "a0b74cd0-7301-4396-b2b2-4dca571f7eec",
    "stewardshipGroup": null
  },
  "catalogItemId": "15bbce34-0000-7000-0000-0000001a0228",
  "dqFilter": "INVALID",
  "importStrategy": "OVERWRITE"
}

Let me know if you have any additional questions!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings