BizTalk Adapter for Google Contacts

Build 20.0.7654

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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654