HUhubspot
Tables

Get rows from draft table

Changed on

Returns rows in the draft version of the specified table. Row results can be filtered and sorted. Filtering and sorting options will be sent as query parameters to the API request. For example, by adding the query parameters column1__gt=5&sort=-column1, API returns the rows with values for column column1 greater than 5 and in the descending order of column1 values. Refer to the overview section for detailed filtering and sorting options.

get/cms/hubdb/2026-03/tables/{tableIdOrName}/rows/draft

Request

  • Base URL
    https://api.hubapi.com
  • URL
    https://api.hubapi.com/cms/hubdb/2026-03/tables/{tableIdOrName}/rows/draft
  • Auth
    • OAuth 2
      Authorization code: https://app.hubspot.com/oauth/authorize
      Token URL: https://api.hubapi.com/oauth/v1/token scopes: hubdb
    • or OAuth 2
      Authorization code: https://app.hubspot.com/oauth/authorize
      Token URL: https://api.hubapi.com/oauth/v1/token scopes: hubdb.rows.read

Path parameters

tableIdOrNamestring required

The unique identifier or name of the table to retrieve draft rows from.

Query parameters

afterstring

The paging cursor token of the last successfully read resource will be returned as the paging.next.after JSON property of a paged response containing more results.

archivedboolean

Whether to return only results that have been archived.

limitinteger

The maximum number of results to display per page.

offsetinteger

The number of items to skip before starting to collect the result set.

propertiesstring[]

A comma-separated list of property names to include in the response.

sortstring[]

An array of strings specifying the fields to sort the results by.

Response

successful operation

OR

Changes

  • 2026-0357dfaa14c811Revision changes
    • info

      the security scope hubdb was added to the endpoint's security scheme oauth2

    • info

      the security scope hubdb.rows.read was removed from the endpoint's security scheme oauth2

  • 2026-03f907bc4f599cRevision changes
    • info

      the security scope hubdb.rows.read was added to the endpoint's security scheme oauth2

    • info

      the security scope hubdb-data-read was removed from the endpoint's security scheme oauth2