Automate Google Contacts Integration Tasks from PowerShell

The CData Cmdlets for Google Contacts are standard PowerShell cmdlets that make it easy to accomplish data cleansing, normalization, backup, and other integration tasks by enabling real-time and bidirectional access to Google Contacts.

PowerShell Cmdlets or ADO.NET Provider?

The Cmdlets are not only a PowerShell interface to Google Contacts, but also an SQL interface; this tutorial shows how to use both to create, retrieve, update, and delete Google Contacts data. We also show examples of the ADO.NET equivalent, which is possible with the CData ADO.NET Provider for Google Contacts. To access Google Contacts data from other .NET applications, like LINQPad, use the CData ADO.NET Provider for Google Contacts.

Once you have acquired the necessary connection properties, accessing Google Contacts data in PowerShell can be enabled in three steps.

You can connect to Google APIs on behalf of individual users or on behalf of a domain. Google uses the OAuth authentication standard. See the "Getting Started" section of the help documentation for a guide.

PowerShell

1. Install the module:

   Install-Module GoogleContactsCmdlets

2. Connect:

   $googlecontacts = Connect-GoogleContacts

3. Search for and retrieve data:

   $searchterms = "Durham" $friends = Select-GoogleContacts -Connection $googlecontacts -Table "Friends" -Where "SearchTerms = `'$SearchTerms`'" $friends

   You can also use the Invoke-GoogleContacts cmdlet to execute SQL commands:

   $friends = Invoke-GoogleContacts -Connection $googlecontacts -Query 'SELECT * FROM Friends WHERE SearchTerms = @SearchTerms' -Params @{'@SearchTerms'='Durham'}

ADO.NET

1. Load the provider's assembly:

   [Reflection.Assembly]::LoadFile("C:\Program Files\CData\CData ADO.NET Provider for Google Contacts\lib\System.Data.CData.GoogleContacts.dll")

2. Connect to Google Contacts:

   $conn= New-Object System.Data.CData.GoogleContacts.GoogleContactsConnection("InitiateOAuth=GETANDREFRESH") $conn.Open()

3. Instantiate the GoogleContactsDataAdapter, execute an SQL query, and output the results:

   $sql="SELECT Summary, StartDateTime from Friends" $da= New-Object System.Data.CData.GoogleContacts.GoogleContactsDataAdapter($sql, $conn) $dt= New-Object System.Data.DataTable $da.Fill($dt) $dt.Rows | foreach { Write-Host $_.summary $_.startdatetime }

Update Google Contacts Data

PowerShell

ADO.NET

Insert Google Contacts Data

PowerShell

ADO.NET

Delete Google Contacts Data

PowerShell

ADO.NET