Associations
Query, insert and delete Associations for a Xero organization.
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 combination of the file and object being associated |
| FileId | String | False |
The FileId of the file that is being associated |
| ObjectId | String | False |
The identifier of the object that is being associated to |
| ObjectGroup | String | False |
The Accounting entity to which the object should be attached |
| ObjectType | String | True |
A more specific category that the object belongs to |
| TenantId | String | False |
The ID of the tenant to query instead of the connection tenant |