Skip to content
HALOWERK

Datenwerk

record foreign key orphans

Return child references without a supplied parent key and duplicate parent-key witnesses. Local records only.

POST https://daten.halowerk.com/v1/record-foreign-key-orphans

Inputs

Fields of the published input schema
FieldTypeRequiredDescription
parentsReferenceYes
childrenReferenceYes
parent_keystringYes
child_keystringYes
nullablebooleanYes
Show full input schema
{
  "type": "object",
  "properties": {
    "parents": {
      "$ref": "#/$defs/records"
    },
    "children": {
      "$ref": "#/$defs/records"
    },
    "parent_key": {
      "type": "string",
      "maxLength": 100,
      "minLength": 1
    },
    "child_key": {
      "type": "string",
      "maxLength": 100,
      "minLength": 1
    },
    "nullable": {
      "type": "boolean"
    }
  },
  "required": [
    "parents",
    "children",
    "parent_key",
    "child_key",
    "nullable"
  ],
  "additionalProperties": false,
  "$defs": {
    "records": {
      "type": "array",
      "items": {
        "type": "object",
        "maxProperties": 30,
        "additionalProperties": {
          "type": [
            "string",
            "number",
            "boolean",
            "null"
          ],
          "maxLength": 1000,
          "minimum": -1000000000,
          "maximum": 1000000000
        }
      },
      "maxItems": 100,
      "minItems": 0
    }
  }
}

Open original schema

Published input example

{
  "parents": [
    {
      "sku": "HW-CABLE-1M"
    }
  ],
  "children": [
    {
      "sku": "HW-CABLE-1M"
    },
    {
      "sku": "HW-ADAPTER"
    },
    {
      "sku": null
    }
  ],
  "parent_key": "sku",
  "child_key": "sku",
  "nullable": true
}

Result & documentation

Machine-readable documentation of this hub

Source of this page: the published HALOWERK catalog. Updated: 2026-11-18 UTC.

More endpoints in this hub

All endpoints in this hub โ†’