Read and manage Zite databases, tables, fields and records, with filtered lists, aggregates, bulk record changes and read-only SQL.
Explore 22 workflow actions for Zite Database, including account permissions and operation limits.
8 read actions14 write actions
WORKFLOW ACTIONS
What you can configure.
Choose an action in the workflow builder, connect an account, and map its inputs. These actions are available in the catalog; your account access and a successful test determine whether they work for your setup.
Aggregate records
Read
Computes an aggregate (sum, avg, min, max, count, or countdistinct) over a field, optionally filtered and grouped.
Permissions and limits
Account permissions
A Zite API key (account settings, Developer) for the organization that owns the database
Bulk create or upsert records
Write
Creates up to 100 records in a single request.
Permissions and limits
Account permissions
A Zite API key (account settings, Developer) for the organization that owns the database
A repeated request may repeat the external action. Review the previous result before retrying a write.
Bulk delete records
Write
Permanently deletes up to 100 records in a single request.
Permissions and limits
Account permissions
A Zite API key (account settings, Developer) for the organization that owns the database
A repeated request may repeat the external action. Review the previous result before retrying a write.
Bulk update records
Write
Updates up to 100 existing records in a single request.
Permissions and limits
Account permissions
A Zite API key (account settings, Developer) for the organization that owns the database
A repeated request may repeat the external action. Review the previous result before retrying a write.
Create database
Write
Creates a new database with tables and fields
Permissions and limits
Account permissions
A Zite API key (account settings, Developer) for the organization that owns the database
A repeated request may repeat the external action. Review the previous result before retrying a write.
Create field
Write
Adds a new field to an existing table
Permissions and limits
Account permissions
A Zite API key (account settings, Developer) for the organization that owns the database
A repeated request may repeat the external action. Review the previous result before retrying a write.
Create record
Write
Creates a new record in a table with the provided field data
Permissions and limits
Account permissions
A Zite API key (account settings, Developer) for the organization that owns the database
A repeated request may repeat the external action. Review the previous result before retrying a write.
Create table
Write
Adds a new table to an existing database
Permissions and limits
Account permissions
A Zite API key (account settings, Developer) for the organization that owns the database
A repeated request may repeat the external action. Review the previous result before retrying a write.
Delete database
Write
Permanently deletes a database and all its data
Permissions and limits
Account permissions
A Zite API key (account settings, Developer) for the organization that owns the database
A repeated request may repeat the external action. Review the previous result before retrying a write.
Delete field
Write
Permanently deletes a field from a table
Permissions and limits
Account permissions
A Zite API key (account settings, Developer) for the organization that owns the database
A repeated request may repeat the external action. Review the previous result before retrying a write.
Delete record
Write
Permanently deletes a record from a table
Permissions and limits
Account permissions
A Zite API key (account settings, Developer) for the organization that owns the database
A repeated request may repeat the external action. Review the previous result before retrying a write.
Delete table
Write
Permanently deletes a table and all its data
Permissions and limits
Account permissions
A Zite API key (account settings, Developer) for the organization that owns the database
A repeated request may repeat the external action. Review the previous result before retrying a write.
Get database by ID
Read
Returns detailed information about a specific database including all tables and fields
Permissions and limits
Account permissions
A Zite API key (account settings, Developer) for the organization that owns the database
Get databases
Read
Lists all databases for your organization
Permissions and limits
Account permissions
A Zite API key (account settings, Developer) for the organization that owns the database
Get record by ID
Read
Returns a single record by its UUID
Permissions and limits
Account permissions
A Zite API key (account settings, Developer) for the organization that owns the database
Get SQL schema
Read
Returns the database schema (tables, fields, and link tables) using human-readable names, for composing SQL queries.
Permissions and limits
Account permissions
A Zite API key (account settings, Developer) for the organization that owns the database
List fields
Read
Retrieves all fields for a table, in display order, using either the table ID or table name.
Permissions and limits
Account permissions
A Zite API key (account settings, Developer) for the organization that owns the database
List records
Read
Retrieves records from a table with filtering, sorting, and pagination
Permissions and limits
Account permissions
A Zite API key (account settings, Developer) for the organization that owns the database
Pagination: offset. Check the result for additional pages; a single action may not return every record.
Run SQL query
Read
Executes a read-only (SELECT) SQL query against the database.
Permissions and limits
Account permissions
A Zite API key (account settings, Developer) for the organization that owns the database
Operation limits
Zite runs only read-only SELECT statements. Bind values ($1, $2) are not offered, so values from earlier steps must not be pasted into the SQL text.
Update field
Write
Updates field properties and configuration
Permissions and limits
Account permissions
A Zite API key (account settings, Developer) for the organization that owns the database
A repeated request may repeat the external action. Review the previous result before retrying a write.
Update record
Write
Updates specific fields of an existing record
Permissions and limits
Account permissions
A Zite API key (account settings, Developer) for the organization that owns the database
A repeated request may repeat the external action. Review the previous result before retrying a write.
Update table
Write
Updates table properties like name
Permissions and limits
Account permissions
A Zite API key (account settings, Developer) for the organization that owns the database
A repeated request may repeat the external action. Review the previous result before retrying a write.
SETUP
Start with a controlled test.
01Connect the intended account
Use the account and permissions required for your process. Review the connection check before configuring a workflow action.
02Review inputs and access
Select a listed operation and map its required inputs. Use test records and add a human approval before writes that need review.
03Confirm the result
Inspect step outputs and confirm the result in Zite Database. A saved workflow is not a completed provider action.