(PowerBuilder) Page Through All Contacts

Demonstrates how to page through the entire list of Google Contacts.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

integer li_rc
oleobject loo_JsonToken
integer li_Success
oleobject loo_GAuth
oleobject loo_Rest
integer li_BAutoReconnect
integer li_StartIndex
integer li_MaxResults
integer li_TotalResults
oleobject loo_SbMaxResults
oleobject loo_SbStartIndex
integer li_LoopIteration
oleobject loo_SbResponseBody
oleobject loo_Xml
integer li_StartIndex2
integer li_ItemsPerPage
integer li_NumEntries
integer i
string ls_IdUrl
string ls_FullName
string ls_EmailAddress
oleobject loo_XLink
integer li_BHasPhoto

// 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

loo_JsonToken = create oleobject
li_rc = loo_JsonToken.ConnectToNewObject("Chilkat_9_5_0.JsonObject")
if li_rc < 0 then
    destroy loo_JsonToken
    MessageBox("Error","Connecting to COM object failed")
    return
end if
li_Success = loo_JsonToken.LoadFile("qa_data/tokens/googleContacts.json")
if li_Success <> 1 then
    Write-Debug "Failed to load googleContacts.json"
    destroy loo_JsonToken
    return
end if

loo_GAuth = create oleobject
li_rc = loo_GAuth.ConnectToNewObject("Chilkat_9_5_0.AuthGoogle")

loo_GAuth.AccessToken = loo_JsonToken.StringOf("access_token")

loo_Rest = create oleobject
li_rc = loo_Rest.ConnectToNewObject("Chilkat_9_5_0.Rest")

// Connect using TLS.
li_BAutoReconnect = 1
li_Success = loo_Rest.Connect("www.google.com",443,1,li_BAutoReconnect)

// Provide the authentication credentials (i.e. the access token)
loo_Rest.SetAuthGoogle(loo_GAuth)

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

li_StartIndex = 1
li_MaxResults = 25
// The totalResults will get updated with the correct value in the 1st loop iteration..
li_TotalResults = 100
// To retrieve the contacts in pages of 25 each, we need to send the following for each page.

// 	GET /m8/feeds/contacts/default/full?max-results=25&start-index=<startIndex>
// 	GData-Version: 3.0

loo_SbMaxResults = create oleobject
li_rc = loo_SbMaxResults.ConnectToNewObject("Chilkat_9_5_0.StringBuilder")

loo_SbMaxResults.AppendInt(li_MaxResults)
loo_SbStartIndex = create oleobject
li_rc = loo_SbStartIndex.ConnectToNewObject("Chilkat_9_5_0.StringBuilder")

li_LoopIteration = 0
do while li_StartIndex <= li_TotalResults

    loo_SbStartIndex.Clear()
    loo_SbStartIndex.AppendInt(li_StartIndex)

    loo_Rest.ClearAllHeaders()
    loo_Rest.ClearAllQueryParams()
    loo_Rest.AddHeader("GData-Version","3.0")
    loo_Rest.AddQueryParam("start-index",loo_SbStartIndex.GetAsString())
    loo_Rest.AddQueryParam("max-results",loo_SbMaxResults.GetAsString())

    loo_SbResponseBody = create oleobject
    li_rc = loo_SbResponseBody.ConnectToNewObject("Chilkat_9_5_0.StringBuilder")

    li_Success = loo_Rest.FullRequestNoBodySb("GET","/m8/feeds/contacts/default/full",loo_SbResponseBody)
    if li_Success <> 1 then
        Write-Debug loo_Rest.LastErrorText
        destroy loo_JsonToken
        destroy loo_GAuth
        destroy loo_Rest
        destroy loo_SbMaxResults
        destroy loo_SbStartIndex
        destroy loo_SbResponseBody
        return
    end if

    // A successful response will have a status code equal to 200.
    if loo_Rest.ResponseStatusCode <> 200 then
        Write-Debug "response status code = " + string(loo_Rest.ResponseStatusCode)
        Write-Debug "response status text = " + loo_Rest.ResponseStatusText
        Write-Debug "response header: " + loo_Rest.ResponseHeader
        Write-Debug "response body: " + loo_SbResponseBody.GetAsString()
        destroy loo_JsonToken
        destroy loo_GAuth
        destroy loo_Rest
        destroy loo_SbMaxResults
        destroy loo_SbStartIndex
        destroy loo_SbResponseBody
        return
    end if

    // If the 200 response was received, then the contacts XML is contained
    // in the response body.
    loo_Xml = create oleobject
    li_rc = loo_Xml.ConnectToNewObject("Chilkat_9_5_0.Xml")

    loo_Xml.LoadSb(loo_SbResponseBody,0)

    // 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.
    li_TotalResults = loo_Xml.GetChildIntValue("openSearch:totalResults")
    li_StartIndex2 = loo_Xml.GetChildIntValue("openSearch:startIndex")
    li_ItemsPerPage = loo_Xml.GetChildIntValue("openSearch:itemsPerPage")
    Write-Debug "totalResults = " + string(li_TotalResults)
    Write-Debug "startIndex = " + string(li_StartIndex2)
    Write-Debug "itemsPerPage = " + string(li_ItemsPerPage)

    // Iterate over each contact.
    li_NumEntries = loo_Xml.NumChildrenHavingTag("entry")
    i = 0
    do while i < li_NumEntries
        loo_Xml.I = i
        Write-Debug string(li_LoopIteration * li_MaxResults + i + 1) + " ----"
        Write-Debug "title: " + loo_Xml.GetChildContent("entry[i]|title")

        ls_IdUrl = loo_Xml.GetChildContent("entry[i]|id")
        Write-Debug "id: " + ls_IdUrl

        ls_FullName = loo_Xml.ChilkatPath("entry[i]|gd:name|gd:fullName|*")
        if loo_Xml.LastMethodSuccess = 1 then
            Write-Debug "fullName: " + ls_FullName
        end if

        ls_EmailAddress = loo_Xml.ChilkatPath("entry[i]|gd:email|(address)")
        if loo_Xml.LastMethodSuccess = 1 then
            Write-Debug "email address: " + ls_EmailAddress
        end if

        // Find the photo link and check to see if this contact has a photo.
        loo_XLink = loo_Xml.GetChildWithAttr("link","rel","http://schemas.google.com/contacts/2008/rel#photo")
        if loo_Xml.LastMethodSuccess = 1 then
            // Get the photo etag.
            li_BHasPhoto = loo_XLink.HasAttribute("gd:etag")
            if li_BHasPhoto = 1 then
                Write-Debug "This contact has a photo."
            end if

            destroy loo_XLink
        end if

        i = i + 1
    loop

    li_StartIndex = li_StartIndex + li_MaxResults
    li_LoopIteration = li_LoopIteration + 1
loop


destroy loo_JsonToken
destroy loo_GAuth
destroy loo_Rest
destroy loo_SbMaxResults
destroy loo_SbStartIndex
destroy loo_SbResponseBody
destroy loo_Xml