SSIS Components for Google Contacts

Build 20.0.7656

ContactGroups

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

Select

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'

Insert

To create a new ContactGroup, the GroupName is required.

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

Update

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'

Delete

To delete a ContactGroup, the Id is required.

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

Columns

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.7656