HubSpot HubDB icon

HubSpot HubDB

Manage HubSpot HubDB tables and rows

Actions15

Row → Get All

AI-generated

Summary

Fetches draft rows from the selected HubDB table, with optional filtering, sorting, column selection, and pagination. Returns rows as n8n items; the operation reads the draft version of the table.

Inputs

  • Table (required) — Select a HubDB table or provide its ID or name using an expression.
  • Return All — When enabled, fetches all available rows. When disabled, returns up to the Limit, which defaults to 100 and supports values from 1 to 1,000.
  • Sort — Add one or more table columns and choose ascending or descending order. Sort criteria are sent in the configured order.
  • Properties — Choose columns to include; leave empty to return all columns.
  • Filters — Filter rows by column, operator, and comparison value. Multiple filters are combined with AND logic. In and Not In values use semicolon-separated entries.

Output shape

A list of n8n items, one per returned row; each row is in the item's json field.

Rows are requested from the HubDB draft rows endpoint. The API is fetched in pages of up to 100 rows; when Return All is disabled, results are truncated to Limit.

Links

Discussion