HubSpot: Get a table row

← Hubdb operations · Get started

Operation hubspot.hubdb_get_row

Provider route: GET /cms/hubdb/2026-09/tables/{tableIdOrName}/rows/{rowId}. Alter supplies the connection’s credentials and routing.

Call through Alter

Install @alter-ai/sdk @alter-ai/hubspot with npm, or alter-sdk-hubspot with pip. Supply your connected customer’s grant ID and the arguments described below.

import { App } from "@alter-ai/sdk";
import { HubSpotIntegration } from "@alter-ai/hubspot";

async function execute(input: Parameters<HubSpotIntegration["hubdb"]["getRow"]>[0]) {
  const app = new App({ apiKey: process.env.ALTER_API_KEY! });
  try {
    const provider = new HubSpotIntegration(app, { grantId: process.env.PROVIDER_GRANT_ID! });
    const call = await provider.hubdb.getRow(input);
    const result = await call.wait();
    return result.bodyJson();
  } finally {
    await app.close();
  }
}

import os
from alter_sdk import App
from alter_sdk_hubspot import HubSpotIntegration

async def execute(arguments):
    async with App(api_key=os.environ["ALTER_API_KEY"]) as app:
        provider = HubSpotIntegration(app, {"grant_id": os.environ["PROVIDER_GRANT_ID"]})
        call = await provider.hubdb.get_row(arguments)
        result = await call.wait()
        return result.body_json()

Input

Field	Type	Presence	Description and constraints
$	object	Root	Additional keys: not allowed
path	object	Required within parent	Additional keys: not allowed
path.rowId	string	Required within parent	Pattern: \d+
path.tableIdOrName	string	Required within parent
query	object	Optional	Additional keys: not allowed
query.archived	boolean	Optional

Response

Response media type: application/json. The table describes the pinned successful response. Referenced models link to their complete fields.

Field	Type	Presence	Description and constraints
$	Model	Root	Expand Clone a row — response body

Referenced models: Clone a row — response body

Schemas

Clone a row — response body

Field	Type	Presence	Description and constraints
$	object	Root
childTableId	string	Required within parent	Specifies the value for the column child table id
createdAt	string	Required within parent	Timestamp at which the row is created Format: date-time
id	string	Required within parent	The id of the table row
name	string	Required within parent	Specifies the value for `hs_name` column, which will be used as title in the dynamic pages
path	string	Required within parent	Specifies the value for `hs_path` column, which will be used as slug in the dynamic pages
publishedAt	string	Required within parent	The timestamp indicating when the row was last published, in date-time format. Format: date-time
updatedAt	string	Required within parent	Timestamp at which the row is updated last time Format: date-time
values	object	Required within parent	List of key value pairs with the column name and column value Additional keys: see wildcard field
values.*	object	Additional keys

Policy, approvals and errors

SDK function policy ID: hubspot.hubdb_get_row. Catalog operation: hubdb_get_row. Rules can name either ID; function rules distinguish managed calls and conservatively cover raw calls sharing the route. Existing grant permissions and policy rules apply. wait() returns an immediate result or waits for a required approval; it never approves the request itself. Persist the approval ID to resume after a restart.

Provider errors retain their response; JSON decoding raises ProviderAPIError for provider failures. ManagedOperationError identifies contract/input/retention errors. See error handling and provider-specific behavior. Sensitive input may be refused before approval storage. A decoding error never resubmits a write.

Required provider scopes: ["hubdb.rows.read"]

Official provider source