Download OpenAPI specification:
Read-only reporting data for Microsoft Fabric and Power BI.
Full snapshots of the reporting resources, one keyset-paged GET per resource. Machine clients authenticate with an Entra access token (client credentials). Code fields are open sets: clients ignore unknown values and read their labels from the codes resource.
The registry is loaded and, in the sandbox, the database is reachable and holds data. Also 200 while the API is switched off: read checks.enabled. No authentication.
{- "status": "string",
- "checks": {
- "enabled": true,
- "registry": "string",
- "database": "string",
- "data": {
- "maintenance": true,
- "mutator_enabled": true,
- "generator_version": "string"
}
}
}Client id, environment, granted proceedings with opaque keys and granted column groups.
{- "client_id": "string",
- "environment": "string",
- "proceedings": [
- {
- "proceeding_id": "string",
- "proceeding_name": "string"
}
], - "column_groups": [
- "string"
], - "rate_tier": "string",
- "meta": {
- "as_of": "2019-08-24T14:15:22Z",
- "epoch": "string",
- "schema_version": "string"
}
}Per resource the primary key, the granted columns and an advisory row count valid at as_of.
{- "resources": [
- {
- "resource": "string",
- "primary_key": [
- "string"
], - "row_count": 0,
- "columns": [
- {
- "name": "string",
- "type": "string",
- "nullable": true,
- "column_group": "string"
}
]
}
], - "schema_version": "string",
- "epoch": "string",
- "as_of": "2019-08-24T14:15:22Z",
- "proceedings": [
- {
- "proceeding_id": "string",
- "is_mutating": true
}
]
}One row per proceeding (Unternehmen) the client may see. Keyset-paged: follow next_link until it is absent.
| proceeding_id | Array of strings[ items^p_[a-z2-7]{20}$ ] Opaque key of a proceeding. May repeat. Omit it to read all granted proceedings. |
| page_size | integer [ 1 .. 10000 ] Default: 5000 Rows per page, an integer from 1 to 10000. Any other value returns 400 invalid-parameter. |
| cursor | string non-empty Opaque cursor of a previous page. Use next_link instead of building it. |
{- "data": [
- {
- "proceeding_id": "string",
- "proceeding_name": "string",
- "proceeding_designation": "string",
- "external_reference": "string",
- "court_name": "string",
- "opened_date": "2019-08-24",
- "is_archived": true
}
], - "next_link": "string",
- "meta": {
- "as_of": "2019-08-24T14:15:22Z",
- "epoch": "string",
- "schema_version": "string"
}
}One row per supplier (Kreditor), with its proceeding. The same company in two proceedings is two suppliers. Keyset-paged: follow next_link until it is absent.
| proceeding_id | Array of strings[ items^p_[a-z2-7]{20}$ ] Opaque key of a proceeding. May repeat. Omit it to read all granted proceedings. |
| page_size | integer [ 1 .. 10000 ] Default: 5000 Rows per page, an integer from 1 to 10000. Any other value returns 400 invalid-parameter. |
| cursor | string non-empty Opaque cursor of a previous page. Use next_link instead of building it. |
{- "data": [
- {
- "supplier_id": "string",
- "proceeding_id": "string",
- "supplier_number": "string",
- "is_archived": true,
- "supplier_name": "string"
}
], - "next_link": "string",
- "meta": {
- "as_of": "2019-08-24T14:15:22Z",
- "epoch": "string",
- "schema_version": "string"
}
}One row per cost type (Kostenart), with its proceeding. Keyset-paged: follow next_link until it is absent.
| proceeding_id | Array of strings[ items^p_[a-z2-7]{20}$ ] Opaque key of a proceeding. May repeat. Omit it to read all granted proceedings. |
| page_size | integer [ 1 .. 10000 ] Default: 5000 Rows per page, an integer from 1 to 10000. Any other value returns 400 invalid-parameter. |
| cursor | string non-empty Opaque cursor of a previous page. Use next_link instead of building it. |
{- "data": [
- {
- "cost_type_id": "string",
- "proceeding_id": "string",
- "cost_type_number": "string",
- "cost_type_name": "string",
- "is_archived": true
}
], - "next_link": "string",
- "meta": {
- "as_of": "2019-08-24T14:15:22Z",
- "epoch": "string",
- "schema_version": "string"
}
}One row per cost center (Kostenstelle), with its proceeding. Keyset-paged: follow next_link until it is absent.
| proceeding_id | Array of strings[ items^p_[a-z2-7]{20}$ ] Opaque key of a proceeding. May repeat. Omit it to read all granted proceedings. |
| page_size | integer [ 1 .. 10000 ] Default: 5000 Rows per page, an integer from 1 to 10000. Any other value returns 400 invalid-parameter. |
| cursor | string non-empty Opaque cursor of a previous page. Use next_link instead of building it. |
{- "data": [
- {
- "cost_center_id": "string",
- "proceeding_id": "string",
- "cost_center_number": "string",
- "cost_center_name": "string",
- "is_archived": true
}
], - "next_link": "string",
- "meta": {
- "as_of": "2019-08-24T14:15:22Z",
- "epoch": "string",
- "schema_version": "string"
}
}One row per code of a domain, with German label and flags. Global, not per proceeding: a proceeding_id parameter returns 400 invalid-parameter. Keyset-paged: follow next_link until it is absent.
| page_size | integer [ 1 .. 10000 ] Default: 5000 Rows per page, an integer from 1 to 10000. Any other value returns 400 invalid-parameter. |
| cursor | string non-empty Opaque cursor of a previous page. Use next_link instead of building it. |
{- "data": [
- {
- "domain": "string",
- "code": "string",
- "label_de": "string",
- "sort_order": 0,
- "is_active": true,
- "is_excluded_from_totals": true,
- "is_pending_approval": true
}
], - "next_link": "string",
- "meta": {
- "as_of": "2019-08-24T14:15:22Z",
- "epoch": "string",
- "schema_version": "string"
}
}One row per case (Vorgang). Keyset-paged: follow next_link until it is absent.
| proceeding_id | Array of strings[ items^p_[a-z2-7]{20}$ ] Opaque key of a proceeding. May repeat. Omit it to read all granted proceedings. |
| page_size | integer [ 1 .. 10000 ] Default: 5000 Rows per page, an integer from 1 to 10000. Any other value returns 400 invalid-parameter. |
| cursor | string non-empty Opaque cursor of a previous page. Use next_link instead of building it. |
{- "data": [
- {
- "case_id": "string",
- "proceeding_id": "string",
- "case_number": 0,
- "case_type_code": "string",
- "has_prepayment": true,
- "status_code": "string",
- "previous_status_code": "string",
- "cost_type_id": "string",
- "cost_center_id": "string",
- "due_date": "2019-08-24",
- "is_in_clarification": true,
- "has_no_delivery": true,
- "created_at": "2019-08-24T14:15:22Z",
- "has_implausible_date": true,
- "is_deleted": true
}
], - "next_link": "string",
- "meta": {
- "as_of": "2019-08-24T14:15:22Z",
- "epoch": "string",
- "schema_version": "string"
}
}One row per order (Bestellung). Keyset-paged: follow next_link until it is absent.
| proceeding_id | Array of strings[ items^p_[a-z2-7]{20}$ ] Opaque key of a proceeding. May repeat. Omit it to read all granted proceedings. |
| page_size | integer [ 1 .. 10000 ] Default: 5000 Rows per page, an integer from 1 to 10000. Any other value returns 400 invalid-parameter. |
| cursor | string non-empty Opaque cursor of a previous page. Use next_link instead of building it. |
{- "data": [
- {
- "order_id": "string",
- "case_id": "string",
- "proceeding_id": "string",
- "supplier_id": "string",
- "order_number": "string",
- "order_date": "2019-08-24",
- "gross_amount": "string",
- "gross_amount_foreign": "string",
- "currency_code": "string",
- "exchange_rate": "string",
- "is_exchange_rate_imprecise": true,
- "tax_rate": "string",
- "status_code": "string",
- "approved_at": "2019-08-24T14:15:22Z",
- "cancelled_at": "2019-08-24T14:15:22Z",
- "rejected_at": "2019-08-24T14:15:22Z",
- "is_prepayment": true,
- "created_at": "2019-08-24T14:15:22Z",
- "is_deleted": true
}
], - "next_link": "string",
- "meta": {
- "as_of": "2019-08-24T14:15:22Z",
- "epoch": "string",
- "schema_version": "string"
}
}One row per invoice (Rechnung). Keyset-paged: follow next_link until it is absent.
| proceeding_id | Array of strings[ items^p_[a-z2-7]{20}$ ] Opaque key of a proceeding. May repeat. Omit it to read all granted proceedings. |
| page_size | integer [ 1 .. 10000 ] Default: 5000 Rows per page, an integer from 1 to 10000. Any other value returns 400 invalid-parameter. |
| cursor | string non-empty Opaque cursor of a previous page. Use next_link instead of building it. |
{- "data": [
- {
- "invoice_id": "string",
- "proceeding_id": "string",
- "supplier_id": "string",
- "payment_plan_id": "string",
- "invoice_number": "string",
- "invoice_type_code": "string",
- "is_credit_note": true,
- "is_prepayment_invoice": true,
- "status_code": "string",
- "invoice_date": "2019-08-24",
- "service_date": "2019-08-24",
- "due_date": "2019-08-24",
- "gross_amount": "string",
- "is_gross_amount_fallback": true,
- "payable_amount": "string",
- "net_amount": "string",
- "is_net_amount_derived": true,
- "tax_rate": "string",
- "currency_code": "string",
- "gross_amount_foreign": "string",
- "payable_amount_foreign": "string",
- "exchange_rate": "string",
- "is_exchange_rate_imprecise": true,
- "captured_at": "2019-08-24T14:15:22Z",
- "clerk_approved_at": "2019-08-24T14:15:22Z",
- "factual_approved_at": "2019-08-24T14:15:22Z",
- "payment_approved_at": "2019-08-24T14:15:22Z",
- "rejected_at": "2019-08-24T14:15:22Z",
- "payment_suspended_at": "2019-08-24T14:15:22Z",
- "linked_case_count": 0,
- "is_collective_invoice": true,
- "has_sign_anomaly": true,
- "has_dangling_payment_plan": true,
- "has_implausible_date": true,
- "is_deleted": true
}
], - "next_link": "string",
- "meta": {
- "as_of": "2019-08-24T14:15:22Z",
- "epoch": "string",
- "schema_version": "string"
}
}One row per link between a case and an invoice. Keyset-paged: follow next_link until it is absent.
| proceeding_id | Array of strings[ items^p_[a-z2-7]{20}$ ] Opaque key of a proceeding. May repeat. Omit it to read all granted proceedings. |
| page_size | integer [ 1 .. 10000 ] Default: 5000 Rows per page, an integer from 1 to 10000. Any other value returns 400 invalid-parameter. |
| cursor | string non-empty Opaque cursor of a previous page. Use next_link instead of building it. |
{- "data": [
- {
- "link_id": "string",
- "case_id": "string",
- "invoice_id": "string",
- "proceeding_id": "string",
- "is_deleted": true
}
], - "next_link": "string",
- "meta": {
- "as_of": "2019-08-24T14:15:22Z",
- "epoch": "string",
- "schema_version": "string"
}
}One row per payment plan (Zahlplan). Keyset-paged: follow next_link until it is absent.
| proceeding_id | Array of strings[ items^p_[a-z2-7]{20}$ ] Opaque key of a proceeding. May repeat. Omit it to read all granted proceedings. |
| page_size | integer [ 1 .. 10000 ] Default: 5000 Rows per page, an integer from 1 to 10000. Any other value returns 400 invalid-parameter. |
| cursor | string non-empty Opaque cursor of a previous page. Use next_link instead of building it. |
{- "data": [
- {
- "payment_plan_id": "string",
- "proceeding_id": "string",
- "plan_amount": "string",
- "is_plan_amount_overridden": true,
- "linked_invoice_count": 0,
- "currency_code": "string",
- "payment_type_code": "string",
- "status_code": "string",
- "is_paid": true,
- "paid_date": "2019-08-24",
- "payment_run_number": "string",
- "created_at": "2019-08-24T14:15:22Z"
}
], - "next_link": "string",
- "meta": {
- "as_of": "2019-08-24T14:15:22Z",
- "epoch": "string",
- "schema_version": "string"
}
}One row per approval decision on an order. Keyset-paged: follow next_link until it is absent.
| proceeding_id | Array of strings[ items^p_[a-z2-7]{20}$ ] Opaque key of a proceeding. May repeat. Omit it to read all granted proceedings. |
| page_size | integer [ 1 .. 10000 ] Default: 5000 Rows per page, an integer from 1 to 10000. Any other value returns 400 invalid-parameter. |
| cursor | string non-empty Opaque cursor of a previous page. Use next_link instead of building it. |
{- "data": [
- {
- "approval_step_id": "string",
- "order_id": "string",
- "proceeding_id": "string",
- "stage_number": 0,
- "decision_code": "string",
- "decided_at": "2019-08-24T14:15:22Z",
- "is_automatic": true
}
], - "next_link": "string",
- "meta": {
- "as_of": "2019-08-24T14:15:22Z",
- "epoch": "string",
- "schema_version": "string"
}
}One row per bank statement line, with the statement date. Keyset-paged: follow next_link until it is absent.
| proceeding_id | Array of strings[ items^p_[a-z2-7]{20}$ ] Opaque key of a proceeding. May repeat. Omit it to read all granted proceedings. |
| page_size | integer [ 1 .. 10000 ] Default: 5000 Rows per page, an integer from 1 to 10000. Any other value returns 400 invalid-parameter. |
| cursor | string non-empty Opaque cursor of a previous page. Use next_link instead of building it. |
{- "data": [
- {
- "bank_statement_line_id": "string",
- "proceeding_id": "string",
- "statement_date": "2019-08-24",
- "booking_date": "2019-08-24",
- "value_date": "2019-08-24",
- "line_amount": "string",
- "currency_code": "string",
- "direction_code": "string",
- "is_matched": true,
- "is_partially_matched": true,
- "statement_number": "string",
- "counterparty_name": "string",
- "account_number": "string",
- "bank_routing_number": "string",
- "purpose_text": "string"
}
], - "next_link": "string",
- "meta": {
- "as_of": "2019-08-24T14:15:22Z",
- "epoch": "string",
- "schema_version": "string"
}
}One row per link between a bank statement line and a document. Keyset-paged: follow next_link until it is absent.
| proceeding_id | Array of strings[ items^p_[a-z2-7]{20}$ ] Opaque key of a proceeding. May repeat. Omit it to read all granted proceedings. |
| page_size | integer [ 1 .. 10000 ] Default: 5000 Rows per page, an integer from 1 to 10000. Any other value returns 400 invalid-parameter. |
| cursor | string non-empty Opaque cursor of a previous page. Use next_link instead of building it. |
{- "data": [
- {
- "link_id": "string",
- "bank_statement_line_id": "string",
- "payment_plan_id": "string",
- "link_kind_code": "string",
- "proceeding_id": "string"
}
], - "next_link": "string",
- "meta": {
- "as_of": "2019-08-24T14:15:22Z",
- "epoch": "string",
- "schema_version": "string"
}
}