Tables

Description
Actions
Workflows

View implementation guide ›


Developer	Invopop
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 (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 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 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 for step-by-step instructions on creating tables, loading data, and wiring the actions into your workflows.

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.

Tables import and export invoice

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.

Import and export invoice workflow

{
    "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" }
        }
    ]
}

Tables merge invoice data

Look up a matching row and patch its values into the invoice being processed, for example a customer’s default payment terms.

Merge table data into invoice workflow

{
    "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" }
        }
    ]
}

Participate in our community

Ask and answer questions about the Tables app →

Network

Government

Notify

Format

Document

Storage

Databases

Automation

Integrations

Tables

Tables

Key features

Import

Export

Merge

Create batch

Participate in our community

Tables

​Key features

Import

Export

Merge

Create batch

Participate in our community

Key features