Associations
Manages the associations of files within Xero, including how files are linked to other entities (such as contacts, invoices, or projects). It allows for querying, inserting, and deleting associations between files and records.
Table-Specific Information
To create an Association, everything but the Id and ObjectType must be provided:
INSERT INTO Associations (FileId, ObjectId, ObjectGroup)
VALUES ('2bf7b85c-7ed8-47b4-8559-d83f8f5f9b9c', '4819be2c-b3b7-43a2-80fe-ef479ad25351', 'Invoice')
Associations cannot be changed once they have been inserted. If you need to update an Association you must delete it and recreate it.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
A unique identifier combining the file and the object it is being associated with. |
| FileId | String | False |
The identifier of the file being associated with the object. |
| ObjectId | String | False |
The identifier of the object being linked to the file. |
| ObjectGroup | String | False |
The accounting entity to which the object should be attached, such as a specific department or division. |
| ObjectType | String | True |
A more specific category or classification that the object belongs to, providing further context for its type. |
| TenantId | String | False |
The ID of the tenant to query instead of the connection tenant, enabling tenant-specific queries. |