Contacts

Set the name of this table to any of your ContactGroups(GroupName) to create, update, delete, and query Google contacts.

Select

The Contacts table supports the Id and Updated columns in the WHERE clause. The supported operators are '=' for Id and '<, >, =' for Updated. For example:

SELECT * FROM [My Contacts]

SELECT * FROM [My Contacts] WHERE Id = '567931ee88efc109'

SELECT * FROM [Contacts Group Test] WHERE Updated > '2017-03-15'

Insert

You can insert any field into the Contacts table that is not read-only.

INSERT INTO [My Contacts](FirstName, LastName, FullName, Notes, HomeEmailAddresses, WorkEmailAddresses, WorkPhoneNumbers, HomePhoneNumbers, HomeAddresses) VALUES ('Elizabeth', 'Bennet', 'Elizabeth Bennet', 'Notes', 'liz@gmail.com', 'liz@example.org', '(206)555-1212' , '(206)555-1213', '1600 Amphitheatre Pkwy Mountain View')

Update

You can update any field in the Contacts table that is not read-only.

UPDATE [My Contacts] SET FirstName = 'Elizabeth', LastName = 'Bennet', FullName = 'Elizabeth Bennet', MobilePhoneNumbers = '+355696969999;+355676555001' WHERE Id = '48b8b9158b1db34d'

Delete

To delete a Contact, the Id is required.

DELETE FROM [My Contacts] WHERE Id = '567931ee88efc109'

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	True	The Id of the contact.
Fullname	String	False	The full name of the contact.
NamePrefix	String	False	The prefix of the contact's name.
FirstName	String	False	The first name of the contact.
MiddleName	String	False	The middle name of the contact.
LastName	String	False	The last name of the contact.
NameSuffix	String	False	The suffix of the contact's name.
Nickname	String	False	The nickname of the contact.
Birthday	String	False	The birthday of the contact.
Gender	String	False	The gender of the person represented by the contact.
OrganizationName	String	False	The name of the organization the contact belongs to.
OrganizationTitle	String	False	The title of the contact in the organization.
Photo	String	True	The photo link of the contact.
Notes	String	False	The notes added for the contact.
HomeEmailAddresses	String	False	A semicolon-separated list of the home emails of the contact.
WorkEmailAddresses	String	False	A semicolon-separated list of the work emails of the contact.
OtherEmailAddresses	String	False	A semicolon-separated list of the other email addresses of the contact.
CustomEmailAddressTypes	String	False	A semicolon-separated list of the custom email address types of the contact.
CustomEmailAddresses	String	False	A semicolon-separated list of the custom email addresses of the contact.
HomePhoneNumbers	String	False	A semicolon-separated list of the home phone numbers of the contact.
WorkPhoneNumbers	String	False	A semicolon-separated list of the work phone numbers of the contact.
MobilePhoneNumbers	String	False	A semicolon-separated list of the mobile phone numbers of the contact.
HomeFaxes	String	False	A semicolon-separated list of the home fax numbers of the contact.
WorkFaxes	String	False	A semicolon-separated list of the work fax numbers of the contact.
Pagers	String	False	A semicolon-separated list of the pager numbers of the contact.
CustomPhoneNumberTypes	String	False	A semicolon-separated list of the custom phone number types of the contact.
CustomPhoneNumbers	String	False	A semicolon-separated list of the custom phone numbers of the contact.
HomeAddresses	String	False	A semicolon-separated list of the home addresses of the contact.
WorkAddresses	String	False	A semicolon-separated list of the work addresses of the contact.
BillingInfo	String	False	The billing information of the contact.
RelationshipTypes	String	True	A semicolon-separated list of the type of relationship the contact has with a user. Valid values are ASSISTANT, BROTHER, CHILD, DOMESTIC-PARTNER, FATHER, FRIEND, MANAGER, MOTHER, PARENT, PARTNER, REFERRED-BY, RELATIVE, SISTER and SPOUSE.
RelationshipValues	String	True	A semicolon-separated list of the users with whom the contact is in relation.
WebsiteTypes	String	True	A semicolon-separated list of website types, linked to WebsiteValues. Valid values are HOMEPAGE, BLOG, PROFILE, HOME, WORK, OTHER, and FTP.
WebsiteValues	String	True	A semicolon-separated list of website names, linked to WebsiteTypes.
ETag	String	True	The ETag of the resource. (Note that the quotation marks are part of the ETag.)
Updated	Datetime	True	The last time the contact was updated.
SelfLink	String	True	The self link of the contact.
EditLink	String	True	The edit link of the contact.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
SearchTerms	String	The SearchTerms to search against.