BizTalk Adapter for Google Contacts

Build 20.0.7654


Create, update, delete, and query Google contact groups.


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

SELECT * FROM [ContactGroups]

SELECT * FROM [ContactGroups] WHERE Id = '674ddb258de3ef81'

SELECT * FROM [ContactGroups] WHERE Updated > '2017-03-25'


To create a new ContactGroup, the GroupName is required.

INSERT INTO [ContactGroups](GroupName) VALUES ('Contacts Group Test')


You can update the GroupName of a ContactGroups row (except for System Groups like My Contacts, Coworkers, and Friends) by specifying the Id column.

UPDATE ContactGroups SET GroupName = 'Salsa Friends' WHERE Id = '674ddb258de3ef81'


To delete a ContactGroup, the Id is required.

DELETE FROM [ContactGroups] WHERE Id = '674ddb258de3ef81'


Name Type ReadOnly Description
Id [KEY] String True

The Id of the contact group.

GroupName String False

The title of the contact group.

ETag String True

The ETag of the resource. (Note that the quotation marks are part of the ETag.)

Updated Datetime True

The latest update time.

SelfLink String True

The self link of the contact.

EditLink String True

The edit link of the contact.

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