HubSpot HubDB icon

HubSpot HubDB

Interact with HubSpot HubDB API v3

Actions30

Table → Get

AI-generated

Overview

This node interacts with the HubSpot HubDB API v3 to perform operations on HubDB resources such as tables, rows, and drafts. Specifically, the 'Table - Get' operation retrieves a table by its ID from HubSpot's HubDB. It is useful for workflows that need to fetch and manipulate table data stored in HubSpot, such as syncing data, reporting, or automation based on table contents.

Use Case Examples

  1. Retrieve a HubDB table by its ID to use its data in subsequent workflow steps.
  2. Fetch a table with column names instead of IDs for easier data handling and readability.

Properties

Name Meaning
Table ID The ID of the HubDB table to retrieve, required for identifying which table to get.
Use Column Names Boolean flag to determine whether the response should use column names instead of column IDs for the table data, improving readability.

Output

JSON

  • id - The unique identifier of the retrieved table.
  • name - The name of the retrieved table.
  • columns - An array of columns in the table, either with names or IDs depending on the 'Use Column Names' setting.
  • rows - An array of rows containing the table data.

Dependencies

  • Requires an API key credential for HubSpot HubDB API v3 authentication.

Troubleshooting

  • Common issues include providing an invalid or missing Table ID, which results in errors from the HubSpot API indicating the table was not found.
  • If the API key credential is missing or invalid, authentication errors will occur.
  • Errors from the API are caught and can be output as error messages if 'Continue On Fail' is enabled, allowing the workflow to handle failures gracefully.

Links

Discussion