This article contains information about a QBL (Quickbase language) object. QBL objects are the supported Quickbase schema elements you see textually represented in the YAML file generated by Quickbase when you export a solution. Each object has associated properties. Supported schema may differ by QBL version.
QBL support for connected tables is currently in closed beta. This beta version introduces temporary behaviors that will evolve in future releases.
In this article
Supported data sources
- Quickbase to Quickbase (QB2QB)
- Admin Console Sync
- Sample Data
Connected tables with unsupported connecters are not included in the export.
Connection handling
The solution APIs handle connections differently. Review this section to learn what behavior to expect for each API.
Export
- Exports include the ID of the connection used.
- Quickbase Sync tables are grouped under their parent app.
- The source service is indicated in the QBL (e.g., QB2QB, Sample Data, Admin Console).
- The source table reference is maintained for QB2QB sync.
- The email of the connection owner is included to identify ownership
Create
- If the connection owner in the QBL is not the importing user, the table is imported with a placeholder connection (meaning the schema is created but not connected).
- If the connection owner in the QBL matches the importing user, the table is imported with the designated connection ID.
- Connected tables retain the original table ID as the source reference.
- Admin Console sync currently only allows one connected table per source. If a user attempts to connect a copied table to the Admin Console source, the schema is created but the connection will fail with a warning.
Update
- If the connection owner is not the importing user, the connection is replaced with a placeholder connection after update. If the connection owner is the importing user, there is no change to the connection.
- The "Allow users who are not administrators to make a Quickbase Sync connection to this app" property is set or updated to match the exported solution.
- Filters, table update options, and sync schedules are applied or updated as defined in the exported solution.
- The connected table's original schedule is retained if present.
- If schema validation for the connected table fails due to an invalid connection, the import is blocked.
This beta release includes foundational support for connected tables in QBL. Future updates will expand capabilities and refine behaviors for improved functionality.
Connected table properties
The following tables list information about the properties of this object.
Connected column placeholder
| Property Name | Required | Default | Allowed Values |
|---|---|---|---|
| Name | True | None | Any string |
| Type | False | Text | Any string |
Connected column text
| Property Name | Required | Default | Allowed Values |
|---|---|---|---|
| Name | True | None | Any string |
| Type | False | Text | Any string |
Connected data source: Admin console
| Property Name | Required | Default | Allowed Values |
|---|---|---|---|
| Owner | True | None | Any string |
Connected data source: Placeholder
| Property Name | Required | Default | Allowed Values |
|---|---|---|---|
| Owner | True | None | Any string |
Connected data source: Quickbase
| Property Name | Required | Default | Allowed Values |
|---|---|---|---|
| Owner | True | None | Any string |
Connected data source: Sample
| Property Name | Required | Default | Allowed Values |
|---|---|---|---|
| Owner | True | None | Any string |
Connected record set
| Property Name | Required | Default | Allowed Values |
|---|---|---|---|
| ExternalSetId | True | None | Any string |
| Name | True | None | Any string |
| SetType | False | Table | One of: Table, Query |
| PrimaryKey | False | None |