InvoiceAssociations
Retrieve the IDs of all the objects associated to specific Invoices objects in HubSpot.
Table-Specific Information
SELECT
The InvoiceAssociations table always includes the same set of columns, but some return NULL unless you filter by Id and Type, which allows the component to retrieve full association details.
To return full details for Invoice associations, filter by both the Invoice Id and the association Type.
The Type identifies the associated object (such as a Deal, Company, Contact, or Ticket).
-- Retrieve all fields for associations between a specific Invoice and its related Deals
SELECT *
FROM InvoiceAssociations
WHERE Id = '436648510605' -- Invoice Id
AND Type = 'Deal'; -- Associated object type
Note: Fetching all fields can cause a reduction in performance, as it requires the component to make requests for each Invoice.
DELETE
To remove an Invoice association, include both the Invoice Id and the association Type:
-- Delete an Invoice-Deal association
DELETE FROM InvoiceAssociations
WHERE Id = '436648510605' -- Invoice Id
AND Type = 'Deal'; -- Associated object type
Columns
| Name | Type | ReadOnly | References | Filterable | Description |
| Id [KEY] | Long | False |
Invoices.Id | False |
Invoices ID |
| AssociationId [KEY] | Long | False | False |
ID of the object that this Invoices object is associated with. | |
| Type [KEY] | String | False | False |
Type of the associated object, for example, a contact or deal. | |
| TypeId [KEY] | String | False |
AssociationsLabels.TypeId | False |
The numeric ID for the association type. This column is empty for more general associations queries. |
| Category [KEY] | String | False |
AssociationsLabels.Category | False |
The category of the association type for the specified object pair. This column is empty for more generic associations queries. |
| TypeLabel | String | True |
AssociationsLabels.Label | False |
The label assigned to the association type between objects. |