LocalAPI — Transactions

Queue Databases Settings Transactions API Docs

Defined Transactions

Loading…

Remote app calls:
POST /api/transactions/{name}/
Authorization: Api-Key <key>

New Transaction

Name (slug)

Operation

Enabled

Description

Database

Schema

Table

Field Mapping (input field → DB column)

Caller sends	DB column

PK input field (caller's field for the row ID)

PK column (actual DB column)

Return columns (empty = all)

Return {"exists": true/false} instead of rows

SQL Template (use {field_name} placeholders)

Fixed filters (always applied, not overridable by caller)

DB column	Value

Fixed insert values (hardcoded column→value, use "__now__" for current datetime) Pre-insert SQL (scalar query for auto-generated fields, e.g. job number)

Target column (DB column to store the scalar result)

Allowed App Keys

Loading keys…

Select a transaction or create a new one