Quickbase REST-API Utilities

Query & Jinja Workbench

Version 1 · Patch 14 · QC1

Build, paste, explain, and diagnose Quickbase Advanced Query syntax and Quickbase Pipelines Jinja in the context of the current application. The Workbench discovers the app and table schema dynamically so the same Code Page can be used in different Quickbase applications.

RealmDetecting…

App DBIDDetecting…

ModeLive schema + local query diagnostics

Application Context

Choose a live table from the current Quickbase app. Its field metadata drives query explanation and validation.

Quickbase Table

Connecting to Quickbase…

Application Relationship Cache

Patch 14 crawls every table as a potential child table, caches its fields and relationships, then builds an application-wide graph for shortest-path discovery.

0 Tables Cached

0 Fields Cached

0 Relationships Cached

0 Relationship Graph Edges

Relationship Path Explorer

Validate the application-wide relationship graph before we wire it into Add Condition. The Workbench searches for the shortest relationship path between two tables.

Patch 14

Visual Query Builder

Build QBL from the live schema. Condition 1 always starts from the Quickbase Table selected in Application Context above; added conditions can explore related tables and relationship-derived fields.

Quickbase Query

Primary Query Table: Loading…

Controlled by Application Context → Quickbase Table. Condition 1 is anchored to this table. To start the expression from a different table, change the Quickbase Table selection above.

Value mode can be Static or Jinja. For Pipeline Advanced Query fields, the outer syntax remains Quickbase query syntax while a single {{ ... }} Jinja expression may supply the matching value.

No query generated yet.

Live Query Results

Execute a valid one-table QBL expression against the live Quickbase JSON API and inspect the records, request payload, response, timing, or any API error.

JSON API

Execution Source: No generated query yet

The Workbench executes only QBL that resolves to one Quickbase table. Hybrid Pipelines Jinja and unresolved cross-table plans are not executed by this Code Page.

Generate a valid QBL expression in Visual Query Builder first.

Fields to Return

The first selection defaults to the fields used by the Visual Query Builder plus Record ID#. This directly controls the JSON API select array. After a query runs, change the checkboxes and choose Apply Fields & Re-run to add or remove returned columns.

Generate a valid one-table QBL plan to choose return fields.

Waiting for a generated QBL expression.

0 Records Returned

0 Fields Returned

— Execution Time

— HTTP Status

Request JSON

No request sent yet.

Response JSON

No response returned yet.

Execution Report

No live query executed yet.

Query & Jinja Tester

Reverse-engineer inherited Quickbase queries, Pipelines Jinja expressions, or hybrid Advanced Query strings.

Workbench Analysis

Language detection, parsed conditions, schema-aware explanations, and Pipeline compatibility checks.

Waiting for input

0Query Conditions

0Jinja Expressions

0Diagnostics

—Overall State

Run an analysis to see query health.

Workbench Report

No report yet.

Diagnostic JSON

No diagnostic JSON yet.

Analyzed Input

No input analyzed yet.