ContactPersonals
Return, update, create and delete a personal contact for an AccountRight company file.
Table Specific Information
Select
MYOB allows a subset of columns to be used in the WHERE clause of a SELECT query. These columns may be used with the following operators: =, !=, >, <, >=, <=. In addition, queries with multiple criteria can be executed by combining the criteria with AND and OR operators. These columns support the above comparison types for server side filtering:
- ID
- CurrentBalance
- FirstName
- LastName
- CompanyName
- IsActive
- IsIndividual
- LastModified
- Notes
- DisplayID
SELECT * FROM ContactPersonals WHERE ID = "1bed306d-2da4-49b3-9023-153c3dc5b2e9" SELECT * FROM ContactPersonals WHERE FirstName = "James" OR FirstName = "John"
Insert
The following attributes are required when performing an insert: CompanyName (if IsIndividual = false), FirstName, LastName, and IsIndividual.
INSERT INTO ContactPersonals (FirstName, LastName, IsIndividual) VALUES ("James", "Smith", true)
Update
To update an existing ContactPersonal, along with its associated addresses, either pass a JSON string to the aggregate input value or use a temporary table:
INSERT INTO ContactAddressItems#TEMP (City, Country) VALUES ("Paris", "France") UPDATE ContactPersonals SET FirstName = "James", Addresses = "ContactAddressItems#TEMP" WHERE ID = "1bed306d-2da4-49b3-9023-153c3dc5b2e9"
Delete
You must specify the Id of the ContactPersonal to delete it.
DELETE FROM ContactPersonals WHERE Id = '5a3e152b-4910-4cbe-ad27-32a57392ae23'
Columns
Name | Type | ReadOnly | References | Description |
ID [KEY] | Uuid | True |
Unique identifier in the form of a guid. | |
CurrentBalance | Decimal | True |
Contact balance. | |
FirstName | String | False |
Contact first name. | |
LastName | String | False |
Contact last name. | |
CompanyName | String | False |
Contact company name. | |
IsActive | Boolean | False |
True indicates the employee contact is active. False indicates the employee contact is inactive. | |
IsIndividual | Boolean | False |
True indicates the employee contact represents an individual. False indicates the employee contact represents a company. | |
LastModified | Datetime | True |
Extracts the last modification date for the contact resource. | |
Notes | String | False |
Notes for the contact. | |
URI | String | True |
Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web. | |
PhotoURI | String | False |
Uniform resource identifier associated with a photo image. | |
DisplayID | String | False |
Display ID for the contact card. | |
Identifiers | String | True |
Contact Identifiers Details. | |
CustomField1Label | String | True |
Custom Field 1 label. | |
CustomField1Value | String | True |
Custom Field 1 value. | |
CustomField2Label | String | True |
Custom Field 2 label. | |
CustomField2Value | String | True |
Custom Field 2 value. | |
CustomField3Label | String | True |
Custom Field 3 label. | |
CustomField3Value | String | True |
Custom Field 3 value. | |
CustomList1Label | String | True |
Custom List 1 label. | |
CustomList1Value | String | True |
Custom List 1 value. | |
CustomList2Label | String | True |
Custom List 2 label. | |
CustomList2Value | String | True |
Custom List 2 value. | |
CustomList3Label | String | True |
Custom List 3 label. | |
CustomList3Value | String | True |
Custom List 3 value. | |
Addresses | String | False |
The following set of information pulls through details for a contact address. | |
RowVersion | String | False |
Number value that changes upon a record update, can be used for change control but does does not preserve a date or a time. |