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-orphansInputs
| Field | Type | Required | Description |
|---|---|---|---|
| parents | Reference | Yes | |
| children | Reference | Yes | |
| parent_key | string | Yes | |
| child_key | string | Yes | |
| nullable | boolean | Yes |
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
}
}
}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
- Datenwerk0.002 USDC
agenda timebox
POSThttps://daten.halowerk.com/v1/agenda-timeboxItems are scheduled in the given order from the start time, with an optional buffer between items and a break inserted after the item that reaches the break interval. If a total length is set and the plan is too long, overflow=compress shor
- Datenwerk0.003 USDC
approval quorum
POSThttps://daten.halowerk.com/v1/approval-quorumCreates three separate role links for one immutable proposal and action SHA-256. Two approved links yield approved; two rejected links yield rejected. Otherwise the round stays pending until expiry. POST quorum_id and access_token to status
- Datenwerk0.003 USDC
bank csv unify
POSThttps://daten.halowerk.com/v1/bank-csv-unifyNo bank-specific layouts are assumed: the header row (preamble lines before it are skipped) is matched against a documented list of German and English column terms (Buchungstag, Valuta/Wertstellung, Betrag/Umsatz, Soll/Haben, Auftraggeber/E