Excel Add-In for Xero

Build 22.0.8479

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479