Skip to content
One platform. From customer conversation to completed work.Take a closer look
All connections
Data & Docs ยท CONNECTION

Zite Database + NodeHub

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.

Follow the workflow quickstart
EXPLORE YOUR STACK

More in Data & Docs.

Zite Database integration | NodeHub