> ## Documentation Index > Fetch the complete documentation index at: https://docs.invopop.com/llms.txt > Use this file to discover all available pages before exploring further. # Tables > Store, query, and transform structured data in SQL tables connected to your workflows. export const tablesMergeWorkflow = { "name": "Merge table data into invoice", "description": "Enrich a GOBL invoice with reference data looked up from a table", "schema": "bill/invoice", "steps": [{ "id": "c1d2e3f0-0000-11f0-c000-000000000001", "name": "Merge from table", "provider": "tables.merge", "summary": "Look up `customers` by tax code", "config": { "table": "customers", "scope": "doc", "key_jq": "e2N1c3RvbWVyX2NvZGU6IC5jdXN0b21lci50YXhfaWQuY29kZX0=", "patch_jq": "LiArIHtwYXltZW50OiB7dGVybXM6IHtrZXk6ICRyb3cucGF5bWVudF90ZXJtc319fQ==", "required": false } }, { "id": "c1d2e3f0-0000-11f0-c000-000000000002", "name": "Set state", "provider": "silo.state", "summary": "Set state to `enriched`{.state .enriched}", "config": { "state": "enriched" } }], "rescue": [{ "id": "c1d2e3f0-0000-11f0-c000-0000000000ff", "name": "Set state", "provider": "silo.state", "summary": "Set state to `error`{.state .error}", "config": { "state": "error" } }] }; export const tablesImportExportWorkflow = { "name": "Import and export invoice", "description": "Build a GOBL invoice from a table row, then record it in a reporting table", "schema": "bill/invoice", "steps": [{ "id": "a1b2c3d0-0000-11f0-a000-000000000001", "name": "Import from table", "provider": "tables.import", "summary": "Build `bill/invoice` from a row", "config": { "schema": "bill/invoice", "scope": "doc", "jq": "e3NlcmllcywgY29kZSwgaXNzdWVfZGF0ZSwgY3VycmVuY3ksIHN1cHBsaWVyOiB7bmFtZTogLnN1cHBsaWVyX25hbWUsIHRheF9pZDoge2NvdW50cnk6IC5zdXBwbGllcl9jb3VudHJ5LCBjb2RlOiAuc3VwcGxpZXJfdGF4X2NvZGV9fSwgY3VzdG9tZXI6IHtuYW1lOiAuY3VzdG9tZXJfbmFtZSwgdGF4X2lkOiB7Y291bnRyeTogLmN1c3RvbWVyX2NvdW50cnksIGNvZGU6IC5jdXN0b21lcl90YXhfY29kZX19LCBsaW5lczogW3txdWFudGl0eSwgaXRlbToge25hbWU6IC5pdGVtX25hbWUsIHByaWNlOiAuaXRlbV9wcmljZX0sIHRheGVzOiBbe2NhdDogIlZBVCIsIHJhdGU6IC50YXhfcmF0ZX1dfV19" } }, { "id": "a1b2c3d0-0000-11f0-a000-000000000002", "name": "Set state", "provider": "silo.state", "summary": "Set state to `processing`{.state .processing}", "config": { "state": "processing" } }, { "id": "a1b2c3d0-0000-11f0-a000-000000000003", "name": "Sign envelope", "provider": "silo.close" }, { "id": "a1b2c3d0-0000-11f0-a000-000000000004", "name": "Generate PDF", "provider": "pdf", "summary": "English", "config": { "locale": "en" } }, { "id": "a1b2c3d0-0000-11f0-a000-000000000005", "name": "Export to table", "provider": "tables.export", "summary": "Upsert into `invoices`", "config": { "table": "invoices", "scope": "doc", "jq": "e3NpbG9fZW50cnlfaWQ6IHNpbG9fZW50cnlfaWQsIGNvZGU6IC5jb2RlLCBpc3N1ZV9kYXRlOiAuaXNzdWVfZGF0ZSwgY3VycmVuY3k6IC5jdXJyZW5jeSwgdG90YWw6IC50b3RhbHMucGF5YWJsZX0=", "upsert_key": ["silo_entry_id"] } }, { "id": "a1b2c3d0-0000-11f0-a000-000000000006", "name": "Set state", "provider": "silo.state", "summary": "Set state to `sent`{.state .sent}", "config": { "state": "sent" } }], "rescue": [{ "id": "a1b2c3d0-0000-11f0-a000-0000000000ff", "name": "Set state", "provider": "silo.state", "summary": "Set state to `error`{.state .error}", "config": { "state": "error" } }] };
View implementation guide ›
| | | | --------- | ------------------------------ | | Developer | [Invopop](https://invopop.com) | | Category | Databases | | Scope | All | The **Tables app** gives each workspace a managed SQL database for storing structured data alongside your documents. Create tables, load them from your own SQL or from other steps in a workflow, browse and query them from a built-in editor, and move data in and out of your GOBL documents as part of any workflow. Each workspace that enables Tables gets a single **database**, backed by [Turso](https://turso.tech) (a managed libSQL/SQLite service). Inside it you create **tables** with typed columns and constraints (primary keys, `UNIQUE`, `NOT NULL`, defaults). Every table automatically includes an auto-incrementing `id` primary key and an optional `silo_entry_id` column that links a row back to the GOBL document it came from. Data moves between tables and documents using [JQ](https://jqlang.org) queries that you configure on each workflow step, so you control exactly how columns map onto GOBL fields and back. You can test your queries in the [online JQ playground](https://play.jqlang.org/) before saving them. To get started quickly, Tables ships with ready-made **templates** that create invoice tables: from a single flat table (one row per invoice), to one row per line item with an aggregating view, to a fully normalized set of supplier, customer, invoice, and line-item tables with a view that reassembles them. Each template comes with a suggested import query and an `ordering_code` uniqueness constraint to keep rows idempotent. #### Key features * **Workflow automation:** Import, export, merge, and batch actions plug into your workflows as steps, moving data between tables and GOBL documents automatically. * **Managed SQL database:** Each workspace gets its own libSQL/SQLite database, with no infrastructure to run or maintain. * **Flexible mapping with JQ:** Map table columns onto GOBL fields, and GOBL fields back onto columns, with JQ queries you can test and refine. * **Built-in SQL editor:** Browse tables, inspect schemas, and run ad-hoc SQL queries directly from the app. * **Table templates:** Start from prebuilt invoice schemas (flat, multi-row, or normalized multi-table), each with a suggested import query. * **Bulk processing:** Fan out a workflow over every row in a table, running one job per row for high-volume imports. * **Direct access:** Generate database credentials to connect and load data from your own tools. Make sure to check out our [Tables guide](/guides/tables) for step-by-step instructions on creating tables, loading data, and wiring the actions into your workflows. The following workflow actions will be available once you install and enable this app: Build a GOBL document from a stored table row and save it as a silo entry. Write data from a GOBL document into a table row, inserting a new row or updating an existing one. Enrich a GOBL document with values looked up from a matching table row. Run a workflow once for every row in a table, with an optional SQL filter. Use these sample workflows as a starting point for your own. The `jq`, `key_jq`, and `patch_jq` values are base64-encoded, exactly as the workflow stores them (the app's step configuration screen encodes them for you). The plain-text queries are shown in the [Tables guide](/guides/tables). Build a GOBL invoice from a table row, sign it and generate a PDF, then record key fields back into a reporting table (upserting on `silo_entry_id` so re-runs update the same row). Trigger it per row, for example from a `Create batch` step, passing the table name and row key. ```json Import and export invoice workflow theme={"system"} { "name": "Import and export invoice", "description": "Build a GOBL invoice from a table row, then record it in a reporting table", "schema": "bill/invoice", "steps": [ { "id": "a1b2c3d0-0000-11f0-a000-000000000001", "name": "Import from table", "provider": "tables.import", "summary": "Build `bill/invoice` from a row", "config": { "schema": "bill/invoice", "scope": "doc", "jq": "e3NlcmllcywgY29kZSwgaXNzdWVfZGF0ZSwgY3VycmVuY3ksIHN1cHBsaWVyOiB7bmFtZTogLnN1cHBsaWVyX25hbWUsIHRheF9pZDoge2NvdW50cnk6IC5zdXBwbGllcl9jb3VudHJ5LCBjb2RlOiAuc3VwcGxpZXJfdGF4X2NvZGV9fSwgY3VzdG9tZXI6IHtuYW1lOiAuY3VzdG9tZXJfbmFtZSwgdGF4X2lkOiB7Y291bnRyeTogLmN1c3RvbWVyX2NvdW50cnksIGNvZGU6IC5jdXN0b21lcl90YXhfY29kZX19LCBsaW5lczogW3txdWFudGl0eSwgaXRlbToge25hbWU6IC5pdGVtX25hbWUsIHByaWNlOiAuaXRlbV9wcmljZX0sIHRheGVzOiBbe2NhdDogIlZBVCIsIHJhdGU6IC50YXhfcmF0ZX1dfV19" } }, { "id": "a1b2c3d0-0000-11f0-a000-000000000002", "name": "Set state", "provider": "silo.state", "summary": "Set state to `processing`{.state .processing}", "config": { "state": "processing" } }, { "id": "a1b2c3d0-0000-11f0-a000-000000000003", "name": "Sign envelope", "provider": "silo.close" }, { "id": "a1b2c3d0-0000-11f0-a000-000000000004", "name": "Generate PDF", "provider": "pdf", "summary": "English", "config": { "locale": "en" } }, { "id": "a1b2c3d0-0000-11f0-a000-000000000005", "name": "Export to table", "provider": "tables.export", "summary": "Upsert into `invoices`", "config": { "table": "invoices", "scope": "doc", "jq": "e3NpbG9fZW50cnlfaWQ6IHNpbG9fZW50cnlfaWQsIGNvZGU6IC5jb2RlLCBpc3N1ZV9kYXRlOiAuaXNzdWVfZGF0ZSwgY3VycmVuY3k6IC5jdXJyZW5jeSwgdG90YWw6IC50b3RhbHMucGF5YWJsZX0=", "upsert_key": ["silo_entry_id"] } }, { "id": "a1b2c3d0-0000-11f0-a000-000000000006", "name": "Set state", "provider": "silo.state", "summary": "Set state to `sent`{.state .sent}", "config": { "state": "sent" } } ], "rescue": [ { "id": "a1b2c3d0-0000-11f0-a000-0000000000ff", "name": "Set state", "provider": "silo.state", "summary": "Set state to `error`{.state .error}", "config": { "state": "error" } } ] } ``` Look up a matching row and patch its values into the invoice being processed, for example a customer's default payment terms. ```json Merge table data into invoice workflow theme={"system"} { "name": "Merge table data into invoice", "description": "Enrich a GOBL invoice with reference data looked up from a table", "schema": "bill/invoice", "steps": [ { "id": "c1d2e3f0-0000-11f0-c000-000000000001", "name": "Merge from table", "provider": "tables.merge", "summary": "Look up `customers` by tax code", "config": { "table": "customers", "scope": "doc", "key_jq": "e2N1c3RvbWVyX2NvZGU6IC5jdXN0b21lci50YXhfaWQuY29kZX0=", "patch_jq": "LiArIHtwYXltZW50OiB7dGVybXM6IHtrZXk6ICRyb3cucGF5bWVudF90ZXJtc319fQ==", "required": false } }, { "id": "c1d2e3f0-0000-11f0-c000-000000000002", "name": "Set state", "provider": "silo.state", "summary": "Set state to `enriched`{.state .enriched}", "config": { "state": "enriched" } } ], "rescue": [ { "id": "c1d2e3f0-0000-11f0-c000-0000000000ff", "name": "Set state", "provider": "silo.state", "summary": "Set state to `error`{.state .error}", "config": { "state": "error" } } ] } ``` *** Ask and answer questions about the Tables app →