Datenwerk
bank csv unify
No 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/Empfänger, IBAN, BIC, Verwendungszweck, Buchungstext, Gläubiger-ID, Mandatsreferenz, Kundenreferenz (End-to-End), Saldo, Date, Amount, Payee .) or mapped explicitly by the caller. Delimiter, decimal comma/point and date format are detected (ambiguous.
POST https://daten.halowerk.com/v1/bank-csv-unifyInputs
| Field | Type | Required | Description |
|---|---|---|---|
| csv | string | Yes | CSV text as exported by the bank (decode the file to text first). |
| delimiter | string | No | |
| decimal | string | No | |
| date_format | string | No | |
| mapping | object | No | Explicit header names per target field; overrides detection. |
| debit_indicators | array | No | Values of the sign column meaning debit (default S, Soll, D, DR, DBIT, Debit, -). |
| default_currency | string | No | |
| output | string | No |
Show full input schema
{
"type": "object",
"additionalProperties": false,
"required": [
"csv"
],
"properties": {
"csv": {
"type": "string",
"minLength": 20,
"maxLength": 5000000,
"description": "CSV text as exported by the bank (decode the file to text first)."
},
"delimiter": {
"type": "string",
"enum": [
"auto",
";",
",",
"\t",
"|"
],
"default": "auto"
},
"decimal": {
"type": "string",
"enum": [
"auto",
"comma",
"point"
],
"default": "auto"
},
"date_format": {
"type": "string",
"enum": [
"auto",
"DD.MM.YYYY",
"DD.MM.YY",
"YYYY-MM-DD",
"DD/MM/YYYY",
"MM/DD/YYYY"
],
"default": "auto"
},
"mapping": {
"type": "object",
"additionalProperties": false,
"description": "Explicit header names per target field; overrides detection.",
"properties": {
"booking_date": {
"type": "string",
"minLength": 1,
"maxLength": 100
},
"value_date": {
"type": "string",
"minLength": 1,
"maxLength": 100
},
"amount": {
"type": "string",
"minLength": 1,
"maxLength": 100
},
"debit": {
"type": "string",
"minLength": 1,
"maxLength": 100
},
"credit": {
"type": "string",
"minLength": 1,
"maxLength": 100
},
"sign": {
"type": "string",
"minLength": 1,
"maxLength": 100
},
"currency": {
"type": "string",
"minLength": 1,
"maxLength": 100
},
"counterparty_name": {
"type": "string",
"minLength": 1,
"maxLength": 100
},
"counterparty_iban": {
"type": "string",
"minLength": 1,
"maxLength": 100
},
"counterparty_bic": {
"type": "string",
"minLength": 1,
"maxLength": 100
},
"remittance_info": {
"type": "string",
"minLength": 1,
"maxLength": 100
},
"booking_text": {
"type": "string",
"minLength": 1,
"maxLength": 100
},
"creditor_id": {
"type": "string",
"minLength": 1,
"maxLength": 100
},
"mandate_reference": {
"type": "string",
"minLength": 1,
"maxLength": 100
},
"end_to_end_id": {
"type": "string",
"minLength": 1,
"maxLength": 100
},
"balance": {
"type": "string",
"minLength": 1,
"maxLength": 100
},
"account_iban": {
"type": "string",
"minLength": 1,
"maxLength": 100
}
}
},
"debit_indicators": {
"type": "array",
"maxItems": 10,
"items": {
"type": "string",
"maxLength": 10
},
"description": "Values of the sign column meaning debit (default S, Soll, D, DR, DBIT, Debit, -)."
},
"default_currency": {
"type": "string",
"pattern": "^[A-Z]{3}$",
"default": "EUR"
},
"output": {
"type": "string",
"enum": [
"json",
"csv",
"both"
],
"default": "both"
}
}
}Published input example
{
"csv": "Date,Payee,Account number,Transaction type,Payment reference,Amount (EUR)\n2026-11-02,\"Warehouse equipment Ltd\",DE79000000001234567890,Credit Transfer,\"Invoice 42, thanks\",250.00\n2026-11-03,Coffee Shop,,Card Payment,-,-4.20"
}Result & documentation
Machine-readable documentation of this hub
Source of this page: the published HALOWERK catalog. Updated: 2026-11-17 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
booking page
POSThttps://daten.halowerk.com/v1/booking-pageCreates a SQLite-backed page from caller-supplied absolute ISO slots or relative start delays resolved at creation. Offers are immutable, displayed in the requested IANA time zone with UTC offsets, and identified by an availability SHA-256.