HistoryContacts
Query and insert Contact history and notes for a Xero organization.
Table Specific Information
The HistoryContacts table allows you to read the notes created on a contact, and the history of changes to that contact. If a ContactId is not provided, the history of all Contacts will be retrieved.
A ContactId and Details is required for inserting a note:
INSERT INTO HistoryContacts (ContactId, Details) VALUES ('...', 'Reliable customer'),
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | True |
A combination of the position of the history item and when it occurred. |
ContactId | String | True |
The ID of the contact the history item belongs to. |
Changes | String | True |
What type of change happened on the contact |
Date | Datetime | True |
When the change occurred |
User | String | True |
The name of the user that made the change |
Details | String | False |
The change that was made |
TenantId | String | False |
The ID of the tenant to query instead of the connection tenant |