Data Model
Overview
This section shows the available API objects and provides more information on executing SQL to Google Contacts APIs.
Key Features
- The adapter models Google Contacts entities like documents, folders, and groups as relational views, allowing you to write SQL to query Google Contacts data.
- Stored procedures allow you to execute operations to Google Contacts.
- Live connectivity to these objects means any changes to your Google Contacts account are immediately reflected when using the adapter.
- 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 adapter models the Google Contacts API as relational Tables.
Views
Views offer additional metadata information from Google Contacts.
Stored Procedures
Stored Procedures are function-like interfaces to Google Contacts. Stored procedures allow you to execute operations to Google Contacts, including downloading documents and moving envelopes.