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

All the other columns and operators are processed client side. These columns only support equality comparisons.

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.