Overview

This section shows the available API objects and provides more information on executing SQL to GoogleContacts APIs.

Key Features

• The add-in models GoogleContacts entities like documents, folders, and groups as relational views, allowing you to write SQL to query GoogleContacts data.
• Stored procedures allow you to execute operations to GoogleContacts.
• Live connectivity to these objects means any changes to your GoogleContacts account are immediately reflected when using the add-in.
• INSERT support for ContactGroups, My Contacts, and Starred tables. Note that the latter two are generated dynamically so are not part of this documentation.

Tables

The add-in models the GoogleContacts API as relational Tables.

Views

Views offer additional metadata information from GoogleContacts.

Stored Procedures

Stored Procedures are function-like interfaces to GoogleContacts. Stored procedures allow you to execute operations to GoogleContacts, including downloading documents and moving envelopes.