ContactPeople
Query ContactPeople in Sage Business Cloud Accounting.
Table Specific Information
Query the available ContactPeople
Select
The driver uses the Sage Accounting API to process search criteria that refer to AddressId,UpdatedOrCreatedSince,DeletedSince,ContactId columns. The driver processes other filters client-side within the driver.
- AddressId supports the '=' operator.
- UpdatedOrCreatedSince supports the '=' operator.
- DeletedSince supports the '=' operator.
- ContactId supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM ContactPeople WHERE AddressId = 'c04b66f130d14478b7978452aeedb8ad' SELECT * FROM ContactPeople WHERE UpdatedOrCreatedSince = '2019-10-02T11:46:53Z' SELECT * FROM ContactPeople WHERE DeletedSince = '2019-10-02T11:46:53Z' SELECT * FROM ContactPeople WHERE ContactId = 'c04b66f130d16538b7978452aeedb8ad'
Delete
You must specify the Id of the ContactPeople to delete it.
DELETE FROM ContactPeople WHERE id = '69d00f6931614e3fbb7ccad85fb84af0'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | False |
The unique identifier for the item | |
CreatedAt | Datetime | True |
The datetime when the item was created | |
DisplayedAs | String | False |
The name of the resource | |
Mobile | String | False |
The mobile number of the contact person | |
Name | String | False |
The name of the contact person | |
Fax | String | False |
The fax number of the contact person | |
Telephone | String | False |
The telephone number of the contact person | |
ContactPersonTypeAggregate | String | False |
The contact person types for the contact person | |
String | False |
The email address of the contact person | ||
UpdatedAt | Datetime | True |
The datetime when the item was last updated | |
DeletedAt | Datetime | True |
The datetime when the item was deleted | |
LegacyId | Int | False |
The legacy ID for the item | |
IsMainContact | Bool | False |
Indicates whether this is the main contact person | |
AddressId | String | False |
Addresses.Id |
The unique identifier for the item |
JobTitle | String | False |
The job title of the contact person | |
IsPreferredContact | Bool | False |
Indicates that this contact person is a preferred contact | |
DeletedSince | Datetime | True | ||
ContactId | String | False |