(Excel) Find Contact Having Email Address

Demonstrates how to fetch the Google Contact for a given email address.

Download Excel Class Modules Chilkat Excel Class Modules

' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

' --------------------------------------------------------------------------------------------------------
' Note: The code for setting up the Chilkat REST object and making the initial connection can be done once.
' Once connected, the REST object may be re-used for many REST API calls.
' (It's a good idea to put the connection setup code in a separate function/subroutine.)
' --------------------------------------------------------------------------------------------------------

' It is assumed we previously obtained an OAuth2 access token.
' This example loads the JSON access token file 
' saved by this example: Get Google Contacts OAuth2 Access Token

Dim jsonToken As Chilkat.JsonObject
Set jsonToken = Chilkat.NewJsonObject

success = jsonToken.LoadFile("qa_data/tokens/googleContacts.json")
If (success <> True) Then
    Debug.Print "Failed to load googleContacts.json"
    Exit Sub
End If

Dim gAuth As Chilkat.AuthGoogle
Set gAuth = Chilkat.NewAuthGoogle
gAuth.AccessToken = jsonToken.StringOf("access_token")

Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest

' Connect using TLS.

bAutoReconnect = True
success = rest.Connect("www.google.com",443,True,bAutoReconnect)

' Provide the authentication credentials (i.e. the access token)
Dim success As Boolean
success = rest.SetAuthGoogle(gAuth)

' ----------------------------------------------
' OK, the REST connection setup is completed..
' ----------------------------------------------

' To retrieve the contacts, we need to send the following:

' 	GET /m8/feeds/contacts/default/full?q=<emailAddress>
' 	GData-Version: 3.0

' Get the contact (or contacts) with this email address:

emailAddressToFind = "admin@chilkatsoft.com"

success = rest.AddHeader("GData-Version","3.0")
success = rest.AddQueryParam("q",emailAddressToFind)

Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
success = rest.FullRequestNoBodySb("GET","/m8/feeds/contacts/default/full",sbResponseBody)
If (success <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' A successful response will have a status code equal to 200.
If (rest.ResponseStatusCode <> 200) Then
    Debug.Print "response status code = "; rest.ResponseStatusCode
    Debug.Print "response status text = "; rest.ResponseStatusText
    Debug.Print "response header: "; rest.ResponseHeader
    Debug.Print "response body: "; sbResponseBody.GetAsString()
    Exit Sub
End If

' If the 200 response was received, then the contacts XML is contained
' in the response body.
Dim xml As Chilkat.Xml
Set xml = Chilkat.NewXml
success = xml.LoadSb(sbResponseBody,False)

' See below for a sample response body.
success = xml.SaveXml("qa_output/google_contacts.xml")

' Now let's parse the XML...

' Get the the total number of results, the start index, and the items per page.
' We'll likely NOT get the full list, but will instead get the 1st page.

totalResults = xml.GetChildIntValue("openSearch:totalResults")

startIndex = xml.GetChildIntValue("openSearch:startIndex")

itemsPerPage = xml.GetChildIntValue("openSearch:itemsPerPage")
Debug.Print "totalResults = "; totalResults
Debug.Print "startIndex = "; startIndex
Debug.Print "itemsPerPage = "; itemsPerPage

' We'll borrow a method from FileAccess to get the contactId from the URL string (see the code in the while loop)
Dim fac As Chilkat.FileAccess
Set fac = Chilkat.NewFileAccess

' Iterate over each contact.

numEntries = xml.NumChildrenHavingTag("entry")

i = 0
Do While i < numEntries
    xml.I = i
    Debug.Print (i + 1); " ----"
    Debug.Print "title: "; xml.GetChildContent("entry[i]|title")

    ' The entry "id" child contains a URL having this format:
    ' <id>http://www.google.com/m8/feeds/contacts/{userEmail}/base/{contactId}</id>
    ' Let's get the URL and parse the contactId from it..

    idUrl = xml.GetChildContent("entry[i]|id")
    Debug.Print "id: "; idUrl

    ' Use the parsing ability of GetFileName to get the contactId

    contactId = fac.GetFileName(idUrl)
    Debug.Print "contactId: "; contactId


    fullName = xml.ChilkatPath("entry[i]|gd:name|gd:fullName|*")
    If (xml.LastMethodSuccess = True) Then
        Debug.Print "fullName: "; fullName
    End If


    emailAddress = xml.ChilkatPath("entry[i]|gd:email|(address)")
    If (xml.LastMethodSuccess = True) Then
        Debug.Print "email address: "; emailAddress
    End If

    i = i + 1
Loop