Hubspot full reference

This connector is optimized for AI agents. For the data replication connector, see Hubspot.

This is the full reference documentation for the Hubspot agent connector.

Supported entities and actions

The Hubspot connector supports the following entities and actions.

Entity	Actions
Contacts	List, Get, API Search, Context Store Search
Companies	List, Get, API Search, Context Store Search
Deals	List, Get, API Search, Context Store Search
Tickets	List, Get, API Search, Context Store Search
Schemas	List, Get
Objects	List, Get

Contacts

Contacts List

Returns a paginated list of contacts

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "hubspot",
  "entity": "contacts",
  "action": "list"
}'

Python SDK

await hubspot.contacts.list()

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "contacts",
    "action": "list"
}'

Parameters

Parameter Name	Type	Required	Description
`limit`	`integer`	No	The maximum number of results to display per page.
`after`	`string`	No	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.
`associations`	`string`	No	A comma separated list of associated object types to include in the response. Valid values are contacts, deals, tickets, and custom object type IDs or fully qualified names (e.g., "p12345_cars").
`properties`	`string`	No	A comma separated list of the properties to be returned in the response. If any of the specified properties are not present on the requested object(s), they will be ignored.
`propertiesWithHistory`	`string`	No	A comma separated list of the properties to be returned along with their history of previous values. If any of the specified properties are not present on the requested object(s), they will be ignored. Usage of this parameter will reduce the maximum number of companies that can be read by a single request.
`archived`	`boolean`	No	Whether to return only results that have been archived.

Response Schema

Records

Field Name	Type	Description
`id`	`string`
`properties`	`object`
`createdAt`	`string`
`updatedAt`	`string`
`archived`	`boolean`
`archivedAt`	`string \| null`
`propertiesWithHistory`	`object \| null`
`associations`	`object \| null`
`objectWriteTraceId`	`string \| null`
`url`	`string \| null`

Meta

Field Name	Type	Description
`next_cursor`	`string`
`next_link`	`string`

Contacts Get

Get a single contact by ID

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "hubspot",
  "entity": "contacts",
  "action": "get",
  "params": {
    "contactId": "<str>"
  }
}'

Python SDK

await hubspot.contacts.get(
    contact_id="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "contacts",
    "action": "get",
    "params": {
        "contactId": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
`contactId`	`string`	Yes	Contact ID
`properties`	`string`	No	A comma separated list of the properties to be returned in the response. If any of the specified properties are not present on the requested object(s), they will be ignored.
`propertiesWithHistory`	`string`	No	A comma separated list of the properties to be returned along with their history of previous values. If any of the specified properties are not present on the requested object(s), they will be ignored.
`associations`	`string`	No	A comma separated list of object types to retrieve associated IDs for. If any of the specified associations do not exist, they will be ignored.
`idProperty`	`string`	No	The name of a property whose values are unique for this object.
`archived`	`boolean`	No	Whether to return only results that have been archived.

Response Schema

Records

Field Name	Type	Description
`id`	`string`
`properties`	`object`
`createdAt`	`string`
`updatedAt`	`string`
`archived`	`boolean`
`archivedAt`	`string \| null`
`propertiesWithHistory`	`object \| null`
`associations`	`object \| null`
`objectWriteTraceId`	`string \| null`
`url`	`string \| null`

Contacts API Search

Search for contacts by filtering on properties, searching through associations, and sorting results.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "hubspot",
  "entity": "contacts",
  "action": "api_search"
}'

Python SDK

await hubspot.contacts.api_search()

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "contacts",
    "action": "api_search"
}'

Parameters

Parameter Name	Type	Required	Description
`filterGroups`	`array<object>`	No	Up to 6 groups of filters defining additional query criteria.
`filterGroups.filters`	`array<object>`	No
`filterGroups.filters.operator`	`"BETWEEN" \| "CONTAINS_TOKEN" \| "EQ" \| "GT" \| "GTE" \| "HAS_PROPERTY" \| "IN" \| "LT" \| "LTE" \| "NEQ" \| "NOT_CONTAINS_TOKEN" \| "NOT_HAS_PROPERTY" \| "NOT_IN"`	No
`filterGroups.filters.propertyName`	`string`	No	The name of the property to apply the filter on.
`filterGroups.filters.value`	`string`	No	The value to match against the property.
`filterGroups.filters.values`	`array<string>`	No	The values to match against the property.
`properties`	`array<string>`	No	A list of property names to include in the response.
`limit`	`integer`	No	Maximum number of results to return
`after`	`string`	No	A paging cursor token for retrieving subsequent pages.
`sorts`	`array<object>`	No	Sort criteria
`sorts.propertyName`	`string`	No
`sorts.direction`	`"ASCENDING" \| "DESCENDING"`	No
`query`	`string`	No	The search query string, up to 3000 characters.

Response Schema

Records

Field Name	Type	Description
`id`	`string`
`properties`	`object`
`createdAt`	`string`
`updatedAt`	`string`
`archived`	`boolean`
`archivedAt`	`string \| null`
`propertiesWithHistory`	`object \| null`
`associations`	`object \| null`
`objectWriteTraceId`	`string \| null`
`url`	`string \| null`

Meta

Field Name	Type	Description
`total`	`integer`
`next_cursor`	`string`
`next_link`	`string`

Contacts Context Store Search

Search and filter contacts records powered by Airbyte's data sync. This often provides additional fields and operators beyond what the API natively supports, making it easier to narrow down results before performing further operations. Only available in hosted mode.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "hubspot",
  "entity": "contacts",
  "action": "context_store_search",
  "params": {
    "query": {
      "filter": {
        "eq": {
          "archived": true
        }
      }
    }
  }
}'

Python SDK

await hubspot.contacts.context_store_search(
    query={"filter": {"eq": {"archived": True}}}
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "contacts",
    "action": "context_store_search",
    "params": {
        "query": {"filter": {"eq": {"archived": True}}}
    }
}'

Parameters

Parameter Name	Type	Required	Description
`query`	`object`	Yes	Filter and sort conditions. Supports operators: eq, neq, gt, gte, lt, lte, in, like, fuzzy, keyword, not, and, or
`query.filter`	`object`	No	Filter conditions
`query.sort`	`array`	No	Sort conditions
`limit`	`integer`	No	Maximum results to return (default 1000)
`cursor`	`string`	No	Pagination cursor from previous response's `meta.cursor`
`fields`	`array`	No	Field paths to include in results

Searchable Fields

Field Name	Type	Description
`archived`	`boolean`	Boolean flag indicating whether the contact has been archived or deleted
`companies`	`array`	Associated company records linked to this contact
`createdAt`	`string`	Timestamp indicating when the contact was first created in the system
`id`	`string`	Unique identifier for the contact record
`properties`	`object`	Key-value object storing all contact properties and their values.
`properties.associatedcompanyid`	`string`	ID of the associated company
`properties.createdate`	`string`	Date the contact was created
`properties.email`	`string`	Contact email address
`properties.firstname`	`string`	Contact first name
`properties.hs_object_id`	`string`	HubSpot object ID
`properties.hubspot_owner_id`	`string`	ID of the HubSpot owner assigned to this contact
`properties.lastmodifieddate`	`string`	Last modified date of the contact
`properties.lastname`	`string`	Contact last name
`updatedAt`	`string`	Timestamp indicating when the contact record was last modified

Response Schema

Field Name	Type	Description
`data`	`array`	List of matching records
`meta`	`object`	Pagination metadata
`meta.has_more`	`boolean`	Whether additional pages are available
`meta.cursor`	`string \| null`	Cursor for next page of results
`meta.took_ms`	`number \| null`	Query execution time in milliseconds
`data[].archived`	`boolean`	Boolean flag indicating whether the contact has been archived or deleted
`data[].companies`	`array`	Associated company records linked to this contact
`data[].createdAt`	`string`	Timestamp indicating when the contact was first created in the system
`data[].id`	`string`	Unique identifier for the contact record
`data[].properties`	`object`	Key-value object storing all contact properties and their values.
`data[].properties.associatedcompanyid`	`string`	ID of the associated company
`data[].properties.createdate`	`string`	Date the contact was created
`data[].properties.email`	`string`	Contact email address
`data[].properties.firstname`	`string`	Contact first name
`data[].properties.hs_object_id`	`string`	HubSpot object ID
`data[].properties.hubspot_owner_id`	`string`	ID of the HubSpot owner assigned to this contact
`data[].properties.lastmodifieddate`	`string`	Last modified date of the contact
`data[].properties.lastname`	`string`	Contact last name
`data[].updatedAt`	`string`	Timestamp indicating when the contact record was last modified

Companies

Companies List

Retrieve all companies, using query parameters to control the information that gets returned.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "hubspot",
  "entity": "companies",
  "action": "list"
}'

Python SDK

await hubspot.companies.list()

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "companies",
    "action": "list"
}'

Parameters

Parameter Name	Type	Required	Description
`limit`	`integer`	No	The maximum number of results to display per page.
`after`	`string`	No	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.
`associations`	`string`	No	A comma separated list of associated object types to include in the response. Valid values are contacts, deals, tickets, and custom object type IDs or fully qualified names (e.g., "p12345_cars").
`properties`	`string`	No	A comma separated list of the properties to be returned in the response. If any of the specified properties are not present on the requested object(s), they will be ignored.
`propertiesWithHistory`	`string`	No	A comma separated list of the properties to be returned along with their history of previous values. If any of the specified properties are not present on the requested object(s), they will be ignored. Usage of this parameter will reduce the maximum number of companies that can be read by a single request.
`archived`	`boolean`	No	Whether to return only results that have been archived.

Response Schema

Records

Field Name	Type	Description
`id`	`string`
`properties`	`object`
`createdAt`	`string`
`updatedAt`	`string`
`archived`	`boolean`
`archivedAt`	`string \| null`
`propertiesWithHistory`	`object \| null`
`associations`	`object \| null`
`objectWriteTraceId`	`string \| null`
`url`	`string \| null`

Meta

Field Name	Type	Description
`next_cursor`	`string`
`next_link`	`string`

Companies Get

Get a single company by ID

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "hubspot",
  "entity": "companies",
  "action": "get",
  "params": {
    "companyId": "<str>"
  }
}'

Python SDK

await hubspot.companies.get(
    company_id="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "companies",
    "action": "get",
    "params": {
        "companyId": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
`companyId`	`string`	Yes	Company ID
`properties`	`string`	No	A comma separated list of the properties to be returned in the response. If any of the specified properties are not present on the requested object(s), they will be ignored.
`propertiesWithHistory`	`string`	No	A comma separated list of the properties to be returned along with their history of previous values. If any of the specified properties are not present on the requested object(s), they will be ignored.
`associations`	`string`	No	A comma separated list of object types to retrieve associated IDs for. If any of the specified associations do not exist, they will be ignored.
`idProperty`	`string`	No	The name of a property whose values are unique for this object.
`archived`	`boolean`	No	Whether to return only results that have been archived.

Response Schema

Records

Field Name	Type	Description
`id`	`string`
`properties`	`object`
`createdAt`	`string`
`updatedAt`	`string`
`archived`	`boolean`
`archivedAt`	`string \| null`
`propertiesWithHistory`	`object \| null`
`associations`	`object \| null`
`objectWriteTraceId`	`string \| null`
`url`	`string \| null`

Companies API Search

Search for companies by filtering on properties, searching through associations, and sorting results.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "hubspot",
  "entity": "companies",
  "action": "api_search"
}'

Python SDK

await hubspot.companies.api_search()

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "companies",
    "action": "api_search"
}'

Parameters

Parameter Name	Type	Required	Description
`filterGroups`	`array<object>`	No	Up to 6 groups of filters defining additional query criteria.
`filterGroups.filters`	`array<object>`	No
`filterGroups.filters.operator`	`"BETWEEN" \| "CONTAINS_TOKEN" \| "EQ" \| "GT" \| "GTE" \| "HAS_PROPERTY" \| "IN" \| "LT" \| "LTE" \| "NEQ" \| "NOT_CONTAINS_TOKEN" \| "NOT_HAS_PROPERTY" \| "NOT_IN"`	No
`filterGroups.filters.propertyName`	`string`	No	The name of the property to apply the filter on.
`filterGroups.filters.value`	`string`	No	The value to match against the property.
`filterGroups.filters.values`	`array<string>`	No	The values to match against the property.
`properties`	`array<string>`	No	A list of property names to include in the response.
`limit`	`integer`	No	Maximum number of results to return
`after`	`string`	No	A paging cursor token for retrieving subsequent pages.
`sorts`	`array<object>`	No	Sort criteria
`sorts.propertyName`	`string`	No
`sorts.direction`	`"ASCENDING" \| "DESCENDING"`	No
`query`	`string`	No	The search query string, up to 3000 characters.

Response Schema

Records

Field Name	Type	Description
`id`	`string`
`properties`	`object`
`createdAt`	`string`
`updatedAt`	`string`
`archived`	`boolean`
`archivedAt`	`string \| null`
`propertiesWithHistory`	`object \| null`
`associations`	`object \| null`
`objectWriteTraceId`	`string \| null`
`url`	`string \| null`

Meta

Field Name	Type	Description
`total`	`integer`
`next_cursor`	`string`
`next_link`	`string`

Companies Context Store Search

Search and filter companies records powered by Airbyte's data sync. This often provides additional fields and operators beyond what the API natively supports, making it easier to narrow down results before performing further operations. Only available in hosted mode.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "hubspot",
  "entity": "companies",
  "action": "context_store_search",
  "params": {
    "query": {
      "filter": {
        "eq": {
          "archived": true
        }
      }
    }
  }
}'

Python SDK

await hubspot.companies.context_store_search(
    query={"filter": {"eq": {"archived": True}}}
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "companies",
    "action": "context_store_search",
    "params": {
        "query": {"filter": {"eq": {"archived": True}}}
    }
}'

Parameters

Parameter Name	Type	Required	Description
`query`	`object`	Yes	Filter and sort conditions. Supports operators: eq, neq, gt, gte, lt, lte, in, like, fuzzy, keyword, not, and, or
`query.filter`	`object`	No	Filter conditions
`query.sort`	`array`	No	Sort conditions
`limit`	`integer`	No	Maximum results to return (default 1000)
`cursor`	`string`	No	Pagination cursor from previous response's `meta.cursor`
`fields`	`array`	No	Field paths to include in results

Searchable Fields

Field Name	Type	Description
`archived`	`boolean`	Indicates whether the company has been deleted and moved to the recycling bin
`contacts`	`array`	Associated contact records linked to this company
`createdAt`	`string`	Timestamp when the company record was created
`id`	`string`	Unique identifier for the company record
`properties`	`object`	Object containing all property values for the company
`properties.createdate`	`string`	Date the company was created
`properties.domain`	`string`	Company domain name
`properties.hs_lastmodifieddate`	`string`	Last modified date of the company
`properties.hs_object_id`	`string`	HubSpot object ID
`properties.hubspot_owner_id`	`string`	ID of the HubSpot owner assigned to this company
`properties.name`	`string`	Company name
`updatedAt`	`string`	Timestamp when the company record was last modified

Response Schema

Field Name	Type	Description
`data`	`array`	List of matching records
`meta`	`object`	Pagination metadata
`meta.has_more`	`boolean`	Whether additional pages are available
`meta.cursor`	`string \| null`	Cursor for next page of results
`meta.took_ms`	`number \| null`	Query execution time in milliseconds
`data[].archived`	`boolean`	Indicates whether the company has been deleted and moved to the recycling bin
`data[].contacts`	`array`	Associated contact records linked to this company
`data[].createdAt`	`string`	Timestamp when the company record was created
`data[].id`	`string`	Unique identifier for the company record
`data[].properties`	`object`	Object containing all property values for the company
`data[].properties.createdate`	`string`	Date the company was created
`data[].properties.domain`	`string`	Company domain name
`data[].properties.hs_lastmodifieddate`	`string`	Last modified date of the company
`data[].properties.hs_object_id`	`string`	HubSpot object ID
`data[].properties.hubspot_owner_id`	`string`	ID of the HubSpot owner assigned to this company
`data[].properties.name`	`string`	Company name
`data[].updatedAt`	`string`	Timestamp when the company record was last modified

Deals

Deals List

Returns a paginated list of deals

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "hubspot",
  "entity": "deals",
  "action": "list"
}'

Python SDK

await hubspot.deals.list()

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "deals",
    "action": "list"
}'

Parameters

Parameter Name	Type	Required	Description
`limit`	`integer`	No	The maximum number of results to display per page.
`after`	`string`	No	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.
`associations`	`string`	No	A comma separated list of associated object types to include in the response. Valid values are contacts, deals, tickets, and custom object type IDs or fully qualified names (e.g., "p12345_cars").
`properties`	`string`	No	A comma separated list of the properties to be returned in the response. If any of the specified properties are not present on the requested object(s), they will be ignored.
`propertiesWithHistory`	`string`	No	A comma separated list of the properties to be returned along with their history of previous values. If any of the specified properties are not present on the requested object(s), they will be ignored. Usage of this parameter will reduce the maximum number of companies that can be read by a single request.
`archived`	`boolean`	No	Whether to return only results that have been archived.

Response Schema

Records

Field Name	Type	Description
`id`	`string`
`properties`	`object`
`createdAt`	`string`
`updatedAt`	`string`
`archived`	`boolean`
`archivedAt`	`string \| null`
`propertiesWithHistory`	`object \| null`
`associations`	`object \| null`
`objectWriteTraceId`	`string \| null`
`url`	`string \| null`

Meta

Field Name	Type	Description
`next_cursor`	`string`
`next_link`	`string`

Deals Get

Get a single deal by ID

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "hubspot",
  "entity": "deals",
  "action": "get",
  "params": {
    "dealId": "<str>"
  }
}'

Python SDK

await hubspot.deals.get(
    deal_id="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "deals",
    "action": "get",
    "params": {
        "dealId": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
`dealId`	`string`	Yes	Deal ID
`properties`	`string`	No	A comma separated list of the properties to be returned in the response. If any of the specified properties are not present on the requested object(s), they will be ignored.
`propertiesWithHistory`	`string`	No	A comma separated list of the properties to be returned along with their history of previous values. If any of the specified properties are not present on the requested object(s), they will be ignored.
`associations`	`string`	No	A comma separated list of object types to retrieve associated IDs for. If any of the specified associations do not exist, they will be ignored.
`idProperty`	`string`	No	The name of a property whose values are unique for this object.
`archived`	`boolean`	No	Whether to return only results that have been archived.

Response Schema

Records

Field Name	Type	Description
`id`	`string`
`properties`	`object`
`createdAt`	`string`
`updatedAt`	`string`
`archived`	`boolean`
`archivedAt`	`string \| null`
`propertiesWithHistory`	`object \| null`
`associations`	`object \| null`
`objectWriteTraceId`	`string \| null`
`url`	`string \| null`

Deals API Search

Search deals with filters and sorting

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "hubspot",
  "entity": "deals",
  "action": "api_search"
}'

Python SDK

await hubspot.deals.api_search()

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "deals",
    "action": "api_search"
}'

Parameters

Parameter Name	Type	Required	Description
`filterGroups`	`array<object>`	No	Up to 6 groups of filters defining additional query criteria.
`filterGroups.filters`	`array<object>`	No
`filterGroups.filters.operator`	`"BETWEEN" \| "CONTAINS_TOKEN" \| "EQ" \| "GT" \| "GTE" \| "HAS_PROPERTY" \| "IN" \| "LT" \| "LTE" \| "NEQ" \| "NOT_CONTAINS_TOKEN" \| "NOT_HAS_PROPERTY" \| "NOT_IN"`	No
`filterGroups.filters.propertyName`	`string`	No	The name of the property to apply the filter on.
`filterGroups.filters.value`	`string`	No	The value to match against the property.
`filterGroups.filters.values`	`array<string>`	No	The values to match against the property.
`properties`	`array<string>`	No	A list of property names to include in the response.
`limit`	`integer`	No	Maximum number of results to return
`after`	`string`	No	A paging cursor token for retrieving subsequent pages.
`sorts`	`array<object>`	No	Sort criteria
`sorts.propertyName`	`string`	No
`sorts.direction`	`"ASCENDING" \| "DESCENDING"`	No
`query`	`string`	No	The search query string, up to 3000 characters.

Response Schema

Records

Field Name	Type	Description
`id`	`string`
`properties`	`object`
`createdAt`	`string`
`updatedAt`	`string`
`archived`	`boolean`
`archivedAt`	`string \| null`
`propertiesWithHistory`	`object \| null`
`associations`	`object \| null`
`objectWriteTraceId`	`string \| null`
`url`	`string \| null`

Meta

Field Name	Type	Description
`total`	`integer`
`next_cursor`	`string`
`next_link`	`string`

Deals Context Store Search

Search and filter deals records powered by Airbyte's data sync. This often provides additional fields and operators beyond what the API natively supports, making it easier to narrow down results before performing further operations. Only available in hosted mode.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "hubspot",
  "entity": "deals",
  "action": "context_store_search",
  "params": {
    "query": {
      "filter": {
        "eq": {
          "archived": true
        }
      }
    }
  }
}'

Python SDK

await hubspot.deals.context_store_search(
    query={"filter": {"eq": {"archived": True}}}
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "deals",
    "action": "context_store_search",
    "params": {
        "query": {"filter": {"eq": {"archived": True}}}
    }
}'

Parameters

Parameter Name	Type	Required	Description
`query`	`object`	Yes	Filter and sort conditions. Supports operators: eq, neq, gt, gte, lt, lte, in, like, fuzzy, keyword, not, and, or
`query.filter`	`object`	No	Filter conditions
`query.sort`	`array`	No	Sort conditions
`limit`	`integer`	No	Maximum results to return (default 1000)
`cursor`	`string`	No	Pagination cursor from previous response's `meta.cursor`
`fields`	`array`	No	Field paths to include in results

Searchable Fields

Field Name	Type	Description
`archived`	`boolean`	Indicates whether the deal has been deleted and moved to the recycling bin
`companies`	`array`	Collection of company records associated with the deal
`contacts`	`array`	Collection of contact records associated with the deal
`createdAt`	`string`	Timestamp when the deal record was originally created
`id`	`string`	Unique identifier for the deal record
`line_items`	`array`	Collection of product line items associated with the deal
`properties`	`object`	Key-value object containing all deal properties and custom fields
`properties.amount`	`string`	Deal amount
`properties.closedate`	`string`	Expected close date of the deal
`properties.createdate`	`string`	Date the deal was created
`properties.dealname`	`string`	Deal name
`properties.dealstage`	`string`	Current deal stage
`properties.hs_lastmodifieddate`	`string`	Last modified date of the deal
`properties.hs_object_id`	`string`	HubSpot object ID
`properties.hubspot_owner_id`	`string`	ID of the HubSpot owner assigned to this deal
`properties.pipeline`	`string`	Deal pipeline
`updatedAt`	`string`	Timestamp when the deal record was last modified

Response Schema

Field Name	Type	Description
`data`	`array`	List of matching records
`meta`	`object`	Pagination metadata
`meta.has_more`	`boolean`	Whether additional pages are available
`meta.cursor`	`string \| null`	Cursor for next page of results
`meta.took_ms`	`number \| null`	Query execution time in milliseconds
`data[].archived`	`boolean`	Indicates whether the deal has been deleted and moved to the recycling bin
`data[].companies`	`array`	Collection of company records associated with the deal
`data[].contacts`	`array`	Collection of contact records associated with the deal
`data[].createdAt`	`string`	Timestamp when the deal record was originally created
`data[].id`	`string`	Unique identifier for the deal record
`data[].line_items`	`array`	Collection of product line items associated with the deal
`data[].properties`	`object`	Key-value object containing all deal properties and custom fields
`data[].properties.amount`	`string`	Deal amount
`data[].properties.closedate`	`string`	Expected close date of the deal
`data[].properties.createdate`	`string`	Date the deal was created
`data[].properties.dealname`	`string`	Deal name
`data[].properties.dealstage`	`string`	Current deal stage
`data[].properties.hs_lastmodifieddate`	`string`	Last modified date of the deal
`data[].properties.hs_object_id`	`string`	HubSpot object ID
`data[].properties.hubspot_owner_id`	`string`	ID of the HubSpot owner assigned to this deal
`data[].properties.pipeline`	`string`	Deal pipeline
`data[].updatedAt`	`string`	Timestamp when the deal record was last modified

Tickets

Tickets List

Returns a paginated list of tickets

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "hubspot",
  "entity": "tickets",
  "action": "list"
}'

Python SDK

await hubspot.tickets.list()

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "tickets",
    "action": "list"
}'

Parameters

Parameter Name	Type	Required	Description
`limit`	`integer`	No	The maximum number of results to display per page.
`after`	`string`	No	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.
`associations`	`string`	No	A comma separated list of associated object types to include in the response. Valid values are contacts, deals, tickets, and custom object type IDs or fully qualified names (e.g., "p12345_cars").
`properties`	`string`	No	A comma separated list of the properties to be returned in the response. If any of the specified properties are not present on the requested object(s), they will be ignored.
`propertiesWithHistory`	`string`	No	A comma separated list of the properties to be returned along with their history of previous values. If any of the specified properties are not present on the requested object(s), they will be ignored. Usage of this parameter will reduce the maximum number of companies that can be read by a single request.
`archived`	`boolean`	No	Whether to return only results that have been archived.

Response Schema

Records

Field Name	Type	Description
`id`	`string`
`properties`	`object`
`createdAt`	`string`
`updatedAt`	`string`
`archived`	`boolean`
`archivedAt`	`string \| null`
`propertiesWithHistory`	`object \| null`
`associations`	`object \| null`
`objectWriteTraceId`	`string \| null`
`url`	`string \| null`

Meta

Field Name	Type	Description
`next_cursor`	`string`
`next_link`	`string`

Tickets Get

Get a single ticket by ID

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "hubspot",
  "entity": "tickets",
  "action": "get",
  "params": {
    "ticketId": "<str>"
  }
}'

Python SDK

await hubspot.tickets.get(
    ticket_id="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "tickets",
    "action": "get",
    "params": {
        "ticketId": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
`ticketId`	`string`	Yes	Ticket ID
`properties`	`string`	No	A comma separated list of the properties to be returned in the response. If any of the specified properties are not present on the requested object(s), they will be ignored.
`propertiesWithHistory`	`string`	No	A comma separated list of the properties to be returned along with their history of previous values. If any of the specified properties are not present on the requested object(s), they will be ignored.
`associations`	`string`	No	A comma separated list of object types to retrieve associated IDs for. If any of the specified associations do not exist, they will be ignored.
`idProperty`	`string`	No	The name of a property whose values are unique for this object.
`archived`	`boolean`	No	Whether to return only results that have been archived.

Response Schema

Records

Field Name	Type	Description
`id`	`string`
`properties`	`object`
`createdAt`	`string`
`updatedAt`	`string`
`archived`	`boolean`
`archivedAt`	`string \| null`
`propertiesWithHistory`	`object \| null`
`associations`	`object \| null`
`objectWriteTraceId`	`string \| null`
`url`	`string \| null`

Tickets API Search

Search for tickets by filtering on properties, searching through associations, and sorting results.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "hubspot",
  "entity": "tickets",
  "action": "api_search"
}'

Python SDK

await hubspot.tickets.api_search()

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "tickets",
    "action": "api_search"
}'

Parameters

Parameter Name	Type	Required	Description
`filterGroups`	`array<object>`	No	Up to 6 groups of filters defining additional query criteria.
`filterGroups.filters`	`array<object>`	No
`filterGroups.filters.operator`	`"BETWEEN" \| "CONTAINS_TOKEN" \| "EQ" \| "GT" \| "GTE" \| "HAS_PROPERTY" \| "IN" \| "LT" \| "LTE" \| "NEQ" \| "NOT_CONTAINS_TOKEN" \| "NOT_HAS_PROPERTY" \| "NOT_IN"`	No
`filterGroups.filters.propertyName`	`string`	No	The name of the property to apply the filter on.
`filterGroups.filters.value`	`string`	No	The value to match against the property.
`filterGroups.filters.values`	`array<string>`	No	The values to match against the property.
`properties`	`array<string>`	No	A list of property names to include in the response.
`limit`	`integer`	No	Maximum number of results to return
`after`	`string`	No	A paging cursor token for retrieving subsequent pages.
`sorts`	`array<object>`	No	Sort criteria
`sorts.propertyName`	`string`	No
`sorts.direction`	`"ASCENDING" \| "DESCENDING"`	No
`query`	`string`	No	The search query string, up to 3000 characters.

Response Schema

Records

Field Name	Type	Description
`id`	`string`
`properties`	`object`
`createdAt`	`string`
`updatedAt`	`string`
`archived`	`boolean`
`archivedAt`	`string \| null`
`propertiesWithHistory`	`object \| null`
`associations`	`object \| null`
`objectWriteTraceId`	`string \| null`
`url`	`string \| null`

Meta

Field Name	Type	Description
`total`	`integer`
`next_cursor`	`string`
`next_link`	`string`

Tickets Context Store Search

Search and filter tickets records powered by Airbyte's data sync. This often provides additional fields and operators beyond what the API natively supports, making it easier to narrow down results before performing further operations. Only available in hosted mode.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "hubspot",
  "entity": "tickets",
  "action": "context_store_search",
  "params": {
    "query": {
      "filter": {
        "eq": {
          "archived": true
        }
      }
    }
  }
}'

Python SDK

await hubspot.tickets.context_store_search(
    query={"filter": {"eq": {"archived": True}}}
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "tickets",
    "action": "context_store_search",
    "params": {
        "query": {"filter": {"eq": {"archived": True}}}
    }
}'

Parameters

Parameter Name	Type	Required	Description
`query`	`object`	Yes	Filter and sort conditions. Supports operators: eq, neq, gt, gte, lt, lte, in, like, fuzzy, keyword, not, and, or
`query.filter`	`object`	No	Filter conditions
`query.sort`	`array`	No	Sort conditions
`limit`	`integer`	No	Maximum results to return (default 1000)
`cursor`	`string`	No	Pagination cursor from previous response's `meta.cursor`
`fields`	`array`	No	Field paths to include in results

Searchable Fields

Field Name	Type	Description
`archived`	`boolean`	Indicates whether the ticket has been deleted and moved to the recycling bin
`companies`	`array`	Collection of company records associated with the ticket
`contacts`	`array`	Collection of contact records associated with the ticket
`createdAt`	`string`	Timestamp when the ticket record was originally created
`id`	`string`	Unique identifier for the ticket record
`properties`	`object`	Object containing all property values for the ticket
`properties.content`	`string`	Ticket content/description
`properties.createdate`	`string`	Date the ticket was created
`properties.hs_lastmodifieddate`	`string`	Last modified date of the ticket
`properties.hs_object_id`	`string`	HubSpot object ID
`properties.hs_pipeline`	`string`	Ticket pipeline
`properties.hs_pipeline_stage`	`string`	Current pipeline stage of the ticket
`properties.hs_ticket_category`	`string`	Ticket category
`properties.hs_ticket_priority`	`string`	Ticket priority level
`properties.subject`	`string`	Ticket subject line
`updatedAt`	`string`	Timestamp when the ticket record was last modified

Response Schema

Field Name	Type	Description
`data`	`array`	List of matching records
`meta`	`object`	Pagination metadata
`meta.has_more`	`boolean`	Whether additional pages are available
`meta.cursor`	`string \| null`	Cursor for next page of results
`meta.took_ms`	`number \| null`	Query execution time in milliseconds
`data[].archived`	`boolean`	Indicates whether the ticket has been deleted and moved to the recycling bin
`data[].companies`	`array`	Collection of company records associated with the ticket
`data[].contacts`	`array`	Collection of contact records associated with the ticket
`data[].createdAt`	`string`	Timestamp when the ticket record was originally created
`data[].id`	`string`	Unique identifier for the ticket record
`data[].properties`	`object`	Object containing all property values for the ticket
`data[].properties.content`	`string`	Ticket content/description
`data[].properties.createdate`	`string`	Date the ticket was created
`data[].properties.hs_lastmodifieddate`	`string`	Last modified date of the ticket
`data[].properties.hs_object_id`	`string`	HubSpot object ID
`data[].properties.hs_pipeline`	`string`	Ticket pipeline
`data[].properties.hs_pipeline_stage`	`string`	Current pipeline stage of the ticket
`data[].properties.hs_ticket_category`	`string`	Ticket category
`data[].properties.hs_ticket_priority`	`string`	Ticket priority level
`data[].properties.subject`	`string`	Ticket subject line
`data[].updatedAt`	`string`	Timestamp when the ticket record was last modified

Schemas

Schemas List

Returns all custom object schemas to discover available custom objects

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "hubspot",
  "entity": "schemas",
  "action": "list"
}'

Python SDK

await hubspot.schemas.list()

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "schemas",
    "action": "list"
}'

Parameters

Parameter Name	Type	Required	Description
`archived`	`boolean`	No	Whether to return only results that have been archived.

Response Schema

Records

Field Name	Type	Description
`id`	`string`
`name`	`string`
`labels`	`object`
`objectTypeId`	`string`
`fullyQualifiedName`	`string`
`requiredProperties`	`array<string>`
`searchableProperties`	`array<string>`
`primaryDisplayProperty`	`string`
`secondaryDisplayProperties`	`array<string>`
`description`	`string \| null`
`allowsSensitiveProperties`	`boolean`
`archived`	`boolean`
`restorable`	`boolean`
`metaType`	`string`
`createdByUserId`	`integer`
`updatedByUserId`	`integer`
`properties`	`array<object>`
`associations`	`array<object>`
`createdAt`	`string`
`updatedAt`	`string`

Schemas Get

Get the schema for a specific custom object type

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "hubspot",
  "entity": "schemas",
  "action": "get",
  "params": {
    "objectType": "<str>"
  }
}'

Python SDK

await hubspot.schemas.get(
    object_type="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "schemas",
    "action": "get",
    "params": {
        "objectType": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
`objectType`	`string`	Yes	Fully qualified name or object type ID of your schema.

Response Schema

Records

Field Name	Type	Description
`id`	`string`
`name`	`string`
`labels`	`object`
`objectTypeId`	`string`
`fullyQualifiedName`	`string`
`requiredProperties`	`array<string>`
`searchableProperties`	`array<string>`
`primaryDisplayProperty`	`string`
`secondaryDisplayProperties`	`array<string>`
`description`	`string \| null`
`allowsSensitiveProperties`	`boolean`
`archived`	`boolean`
`restorable`	`boolean`
`metaType`	`string`
`createdByUserId`	`integer`
`updatedByUserId`	`integer`
`properties`	`array<object>`
`associations`	`array<object>`
`createdAt`	`string`
`updatedAt`	`string`

Objects

Objects List

Read a page of objects. Control what is returned via the properties query param.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "hubspot",
  "entity": "objects",
  "action": "list",
  "params": {
    "objectType": "<str>"
  }
}'

Python SDK

await hubspot.objects.list(
    object_type="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "objects",
    "action": "list",
    "params": {
        "objectType": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
`objectType`	`string`	Yes	Object type ID or fully qualified name (e.g., "cars" or "p12345_cars")
`limit`	`integer`	No	The maximum number of results to display per page.
`after`	`string`	No	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.
`properties`	`string`	No	A comma separated list of the properties to be returned in the response. If any of the specified properties are not present on the requested object(s), they will be ignored.
`archived`	`boolean`	No	Whether to return only results that have been archived.
`associations`	`string`	No	A comma separated list of object types to retrieve associated IDs for. If any of the specified associations do not exist, they will be ignored.
`propertiesWithHistory`	`string`	No	A comma separated list of the properties to be returned along with their history of previous values. If any of the specified properties are not present on the requested object(s), they will be ignored.

Response Schema

Records

Field Name	Type	Description
`id`	`string`
`properties`	`object`
`createdAt`	`string`
`updatedAt`	`string`
`archived`	`boolean`
`archivedAt`	`string \| null`
`propertiesWithHistory`	`object \| null`
`associations`	`object \| null`
`objectWriteTraceId`	`string \| null`
`url`	`string \| null`

Meta

Field Name	Type	Description
`next_cursor`	`string`
`next_link`	`string`

Objects Get

Read an Object identified by {objectId}. {objectId} refers to the internal object ID by default, or optionally any unique property value as specified by the idProperty query param. Control what is returned via the properties query param.

CLI

airbyte-agent connectors execute --json '{
  "workspace": "<your_workspace_name>",
  "name": "hubspot",
  "entity": "objects",
  "action": "get",
  "params": {
    "objectType": "<str>",
    "objectId": "<str>"
  }
}'

Python SDK

await hubspot.objects.get(
    object_type="<str>",
    object_id="<str>"
)

API

curl --location 'https://api.airbyte.ai/api/v1/integrations/connectors/{your_connector_id}/execute' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {your_auth_token}' \
--data '{
    "entity": "objects",
    "action": "get",
    "params": {
        "objectType": "<str>",
        "objectId": "<str>"
    }
}'

Parameters

Parameter Name	Type	Required	Description
`objectType`	`string`	Yes	Object type ID or fully qualified name
`objectId`	`string`	Yes	Object record ID
`properties`	`string`	No	A comma separated list of the properties to be returned in the response. If any of the specified properties are not present on the requested object(s), they will be ignored.
`archived`	`boolean`	No	Whether to return only results that have been archived.
`associations`	`string`	No	A comma separated list of object types to retrieve associated IDs for. If any of the specified associations do not exist, they will be ignored.
`idProperty`	`string`	No	The name of a property whose values are unique for this object.
`propertiesWithHistory`	`string`	No	A comma separated list of the properties to be returned along with their history of previous values. If any of the specified properties are not present on the requested object(s), they will be ignored.

Response Schema

Records

Field Name	Type	Description
`id`	`string`
`properties`	`object`
`createdAt`	`string`
`updatedAt`	`string`
`archived`	`boolean`
`archivedAt`	`string \| null`
`propertiesWithHistory`	`object \| null`
`associations`	`object \| null`
`objectWriteTraceId`	`string \| null`
`url`	`string \| null`

Supported entities and actions​

Contacts​

Contacts List​

CLI​

Python SDK​

API​

Parameters​

Records​

Meta​

Contacts Get​

CLI​

Python SDK​

API​

Parameters​

Records​

Contacts API Search​

CLI​

Python SDK​

API​

Parameters​

Records​

Meta​

Contacts Context Store Search​

CLI​

Python SDK​

API​

Parameters​

Searchable Fields​

Companies​

Companies List​

CLI​

Python SDK​

API​

Parameters​

Records​

Meta​

Companies Get​

CLI​

Python SDK​

API​

Parameters​

Records​

Companies API Search​

CLI​

Python SDK​

API​

Parameters​

Records​

Meta​

Companies Context Store Search​

CLI​

Python SDK​

API​

Parameters​

Searchable Fields​

Deals​

Deals List​

CLI​

Python SDK​

API​

Parameters​

Records​

Meta​

Deals Get​

CLI​

Python SDK​

API​

Parameters​

Records​

Deals API Search​

CLI​

Python SDK​

API​

Parameters​

Records​

Meta​

Deals Context Store Search​

CLI​

Python SDK​

API​

Supported entities and actions

Contacts

Contacts List

CLI

Python SDK

API

Parameters

Records

Meta

Contacts Get

CLI

Python SDK

API

Parameters

Records

Contacts API Search

CLI

Python SDK

API

Parameters

Records

Meta

Contacts Context Store Search

CLI

Python SDK

API

Parameters

Searchable Fields

Companies

Companies List

CLI

Python SDK

API

Parameters

Records

Meta

Companies Get

CLI

Python SDK

API

Parameters

Records

Companies API Search

CLI

Python SDK

API

Parameters

Records

Meta

Companies Context Store Search

CLI

Python SDK

API

Parameters

Searchable Fields

Deals

Deals List

CLI

Python SDK

API

Parameters

Records

Meta

Deals Get

CLI

Python SDK

API

Parameters

Records

Deals API Search

CLI

Python SDK

API

Parameters

Records

Meta

Deals Context Store Search

CLI

Python SDK

API