📘

Automationen (Webhooks & API-Connectors)

automations core_platform 🛡️ RLS Protected

Automationen (Webhooks & API-Connectors) — aus Code abgeleitete Prozess- und API-Dokumentation.

Fachliche Bestimmung: Automationen (Webhooks & API-Connectors) — aus Code abgeleitete Prozess- und API-Dokumentation. Erfasst alle registrierten Prozesse, Capabilities, Zustandsmaschinen, APIs und Tabellen für Simulationen und Reviews.

⚡ Workflows and life cycles (0) 🗄️ Data models and fields (5) 🔌 The Commission shall adopt delegated acts in accordance with Article 21 of this Regulation. (20) 🛡️ Regulatory and compliance

⚡ Workflows and life cycles

Dieses Modul folgt dem standardisierten transaktionalen CRUD- und Event-Lifecycle.

🗄️ Data models and fields

WorkflowBlueprints workflow_blueprints

10 Fields and columns

Tabelle workflow_blueprints

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`key`	`VARCHAR(96)`	Ja *	-	Feld key
`version`	`INTEGER`	Ja *	-	Feld version
`status`	`VARCHAR(16)`	Ja *	-	Feld status
`active`	`BOOLEAN`	Ja *	-	Feld active
`definition`	`JSONB`	Ja *	-	Feld definition
`content_hash`	`VARCHAR(64)`	Ja *	-	Feld content_hash
`source`	`VARCHAR(255)`	Ja *	-	Feld source
`id`	`UUID`	Nein	PK	Feld id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at

WorkflowCheckpoints workflow_checkpoints RLS Aktiv

19 Fields and columns

Tabelle workflow_checkpoints

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`run_id`	`UUID`	Ja *	FK ➔ workflow_runs.id	Feld run_id
`source_kind`	`VARCHAR(16)`	Ja *	-	Feld source_kind
`source_id`	`UUID`	Ja *	-	Feld source_id
`definition`	`JSONB`	Ja *	-	Feld definition
`definition_hash`	`VARCHAR(64)`	Ja *	-	Feld definition_hash
`semantic_binding`	`JSONB`	Nein	-	Feld semantic_binding
`semantic_binding_hash`	`VARCHAR(64)`	Nein	-	Feld semantic_binding_hash
`state`	`VARCHAR(16)`	Ja *	-	Feld state
`cursor`	`INTEGER`	Ja *	-	Feld cursor
`facts`	`JSONB`	Ja *	-	Feld facts
`references`	`JSONB`	Ja *	-	Feld references
`review_ids`	`JSONB`	Ja *	-	Feld review_ids
`agent_run_id`	`UUID`	Nein	-	Feld agent_run_id
`error_code`	`VARCHAR(120)`	Nein	-	Feld error_code
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

WorkflowCommands workflow_commands RLS Aktiv

11 Fields and columns

Tabelle workflow_commands

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`requested_by`	`UUID`	Ja *	-	Feld requested_by
`agent_name`	`VARCHAR(64)`	Ja *	-	Feld agent_name
`idempotency_key`	`VARCHAR(128)`	Ja *	-	Feld idempotency_key
`input`	`JSONB`	Ja *	-	Feld input
`input_hash`	`VARCHAR(64)`	Ja *	-	Feld input_hash
`proposal_only`	`BOOLEAN`	Ja *	-	Feld proposal_only
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

WorkflowRunEvents workflow_run_events RLS Aktiv

11 Fields and columns

Tabelle workflow_run_events

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`run_id`	`UUID`	Ja *	FK ➔ workflow_runs.id	Feld run_id
`sequence`	`INTEGER`	Ja *	-	Feld sequence
`node_key`	`VARCHAR(64)`	Ja *	-	Feld node_key
`transition`	`VARCHAR(32)`	Ja *	-	Feld transition
`blueprint_hash`	`VARCHAR(64)`	Ja *	-	Feld blueprint_hash
`evidence`	`JSONB`	Ja *	-	Feld evidence
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ workflow_runs.tenant_id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at
`metadata`	`JSONB`	Ja *	-	Feld metadata

WorkflowRuns workflow_runs RLS Aktiv

17 Fields and columns

Tabelle workflow_runs

Feldname	Type of data	The Commission	Schlüssel	The technical significance
`workflow_name`	`VARCHAR(64)`	Ja *	-	Feld workflow_name
`workflow_version`	`INTEGER`	Ja *	-	Feld workflow_version
`trigger_event_id`	`UUID`	Nein	FK ➔ domain_events.id	Feld trigger_event_id
`trigger_event_type`	`VARCHAR(64)`	Ja *	-	Feld trigger_event_type
`status`	`VARCHAR(48)`	Ja *	-	Feld status
`steps`	`JSONB`	Ja *	-	Feld steps
`finished_at`	`DATETIME`	Nein	-	Feld finished_at
`last_error`	`TEXT`	Nein	-	Feld last_error
`correlation_id`	`UUID`	Nein	-	Feld correlation_id
`causation_id`	`UUID`	Nein	-	Feld causation_id
`parent_run_id`	`UUID`	Nein	FK ➔ workflow_runs.id	Feld parent_run_id
`workflow_depth`	`INTEGER`	Ja *	-	Feld workflow_depth
`idempotency_key`	`VARCHAR(64)`	Nein	-	Feld idempotency_key
`id`	`UUID`	Nein	PK	Feld id
`tenant_id`	`UUID`	Ja *	FK ➔ organizations.id	Feld tenant_id
`created_at`	`DATETIME`	Ja *	-	Feld created_at
`updated_at`	`DATETIME`	Ja *	-	Feld updated_at

🔌 The Commission shall adopt delegated acts in accordance with Article 21 of this Regulation.

Art	The method	Endpoint / path	Titel & Zweck	The Commission shall adopt the following:
⚡ REST API	GET	`/api/v1/workflow-instances`	list_workflow_instances Semantic binding: inventory_only; mutation=False	`automations`
⚡ REST API	GET	`/api/v1/workflow-instances/blueprints`	list_workflow_blueprints Semantic binding: inventory_only; mutation=False	`automations`
⚡ REST API	GET	`/api/v1/workflow-instances/metrics/autonomy`	autonomy_metrics Semantic binding: inventory_only; mutation=False	`automations`
⚡ REST API	GET	`/api/v1/workflow-instances/{run_id}`	get_workflow_instance Semantic binding: inventory_only; mutation=False	`automations`
⚡ REST API	GET	`/api/v1/workflow-instances/{run_id}/simulation`	simulate_workflow_instance Semantic binding: inventory_only; mutation=False	`automations`
⚡ REST API	GET	`/automationen`	automations_page Semantic binding: inventory_only; mutation=False	`automations`
⚡ REST API	GET	`/workflows`	workflows_page Semantic binding: inventory_only; mutation=False	`automations`
⚡ REST API	POST	`/api/v1/workflow-instances/{run_id}/retry`	retry_workflow_instance Semantic binding: operator_surface; mutation=True	`automations`
⚡ REST API	POST	`/automationen/deliveries/{delivery_id}/redeliver`	other Semantic binding: operator_surface; mutation=True	`automations`
⚡ REST API	POST	`/automationen/inbound`	create_inbound_endpoint Semantic binding: operator_surface; mutation=True	`automations`
⚡ REST API	POST	`/automationen/inbound/{endpoint_id}`	update_inbound_endpoint Semantic binding: operator_surface; mutation=True	`automations`
⚡ REST API	POST	`/automationen/inbound/{endpoint_id}/delete`	delete_inbound_endpoint Semantic binding: operator_surface; mutation=True	`automations`
⚡ REST API	POST	`/automationen/subscriptions`	create_subscription Semantic binding: operator_surface; mutation=True	`automations`
⚡ REST API	POST	`/automationen/subscriptions/{subscription_id}`	update_subscription Semantic binding: operator_surface; mutation=True	`automations`
⚡ REST API	POST	`/automationen/subscriptions/{subscription_id}/delete`	delete_subscription Semantic binding: operator_surface; mutation=True	`automations`
⚡ REST API	POST	`/automationen/subscriptions/{subscription_id}/test`	send_test_delivery Semantic binding: operator_surface; mutation=True	`automations`
⚡ REST API	POST	`/webhooks/in/{token}`	webhook_inbound Semantic binding: operator_surface; mutation=True	`automations`
⚡ REST API	POST	`/webhooks/paypal`	webhook_paypal Semantic binding: operator_surface; mutation=True	`automations`
⚡ REST API	POST	`/webhooks/stripe`	webhook_stripe Semantic binding: operator_surface; mutation=True	`automations`
⚡ REST API	POST	`/webhooks/unzer`	webhook_unzer Semantic binding: operator_surface; mutation=True	`automations`

🛡️ Regulatory and compliance

Dieses Modul unterliegt folgenden gesetzlichen, regulatorischen und Revisionsstandards:

The Commission shall adopt the following implementing acts:
The following information shall be provided: