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