HubSpot HubDB icon

HubSpot HubDB

Interact with HubSpot HubDB API v3

Actions30

Row → Get Many

AI-generated

Overview

This node interacts with the HubSpot HubDB API v3 to retrieve multiple rows from a specified table. It is useful for scenarios where you need to fetch bulk data from a HubDB table, such as exporting data for reporting, syncing with other systems, or processing multiple records in workflows. For example, you can retrieve all rows or a limited number of rows from a table, apply sorting, and filter rows using HubDB query syntax.

Use Case Examples

  1. Fetch all rows from a HubDB table to export data.
  2. Retrieve a limited number of rows sorted by a specific column for processing.
  3. Filter rows based on specific column values using query syntax.

Properties

Name Meaning
Table ID The ID of the HubDB table from which to retrieve rows.
Return All Whether to return all rows or only up to a specified limit.
Limit Maximum number of rows to return when not returning all.
Sort By Column name to sort the rows by, prefix with '-' for descending order.
Query Filter rows using HubDB query syntax to narrow down results.
Use Column Names Whether to use column names instead of column IDs in the output.

Output

JSON

  • rows - Array of row objects retrieved from the specified HubDB table, optionally filtered, sorted, and limited.

Dependencies

  • HubSpot HubDB API v3

Troubleshooting

  • Ensure the provided Table ID is correct and accessible with the API credentials.
  • If using query filters, verify the syntax matches HubDB query syntax to avoid errors.
  • When 'Return All' is false, ensure the 'Limit' is set to a positive number to avoid empty results.
  • Check API credentials and permissions if authentication errors occur.

Links

Discussion