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 criterias 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

All the other columns and operators are processed client side. Type supports only equality comparison.

SELECT * FROM ContactPersonals
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, IsIndividual.

INSERT INTO ContactPersonals (FirstName, LastName, IsIndividual) VALUES ("James", "Bond", true)

Update

To update an existing ContactPersonal, along with the addresses, we can either pass a JSON string to the aggregate input value or use a temporary table like below.

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	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	String	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.
CompanyFileId	String	True	The ID of the company file. Takes precedence over the CompanyFileId connection property.