(PowerBuilder) Google Contacts - Retrieve as JSON

Demonstrates how to retrieve Google Contacts as JSON.

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
oleobject loo_SbResponseBody
oleobject loo_Json
integer li_TotalResults
integer li_StartIndex
integer li_ItemsPerPage
integer li_NumEntries
integer i
string ls_FullName
integer li_NumEmailAddresses
integer j
string ls_EmailAddress

// 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
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
li_rc = loo_JsonToken.ConnectToNewObject("Chilkat.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
// Use "Chilkat_9_5_0.AuthGoogle" for versions of Chilkat < 10.0.0
li_rc = loo_GAuth.ConnectToNewObject("Chilkat.AuthGoogle")

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

loo_Rest = create oleobject
// Use "Chilkat_9_5_0.Rest" for versions of Chilkat < 10.0.0
li_rc = loo_Rest.ConnectToNewObject("Chilkat.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..
// ----------------------------------------------

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

// 	GET /m8/feeds/contacts/default/full
// 	GData-Version: 3.0

// To get the contacts data in JSON format, set the "alt" query parameter to "json"
loo_Rest.AddQueryParam("alt","json")
loo_Rest.AddHeader("GData-Version","3.0")

loo_SbResponseBody = create oleobject
// Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
li_rc = loo_SbResponseBody.ConnectToNewObject("Chilkat.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_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_SbResponseBody
    return
end if

// If the 200 response was received, then the contacts JSON is contained
// in the response body.
loo_Json = create oleobject
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
li_rc = loo_Json.ConnectToNewObject("Chilkat.JsonObject")

loo_Json.LoadSb(loo_SbResponseBody)
loo_Json.EmitCompact = 0

// Save the pretty-printed JSON response to a file.
loo_SbResponseBody.Clear()
loo_Json.EmitSb(loo_SbResponseBody)
loo_SbResponseBody.WriteFile("qa_output/google_contacts.json","utf-8",0)

// Parse the Google Contacts JSON, and iterate over the contacts..
li_TotalResults = loo_Json.IntOf("feed.openSearch$totalResults.$t")
li_StartIndex = loo_Json.IntOf("feed.openSearch$startIndex.$t")
li_ItemsPerPage = loo_Json.IntOf("feed.openSearch$itemsPerPage.$t")
Write-Debug "totalResults = " + string(li_TotalResults)
Write-Debug "startIndex = " + string(li_StartIndex)
Write-Debug "itemsPerPage = " + string(li_ItemsPerPage)

li_NumEntries = loo_Json.SizeOfArray("feed.entry")
i = 0
do while i < li_NumEntries
    loo_Json.I = i
    Write-Debug string(i + 1) + " ----"
    Write-Debug "title: " + loo_Json.StringOf("feed.entry[i].title.$t")

    ls_FullName = loo_Json.StringOf("feed.entry[i].gd$name.gd$fullName.$t")
    if loo_Json.LastMethodSuccess = 1 then
        Write-Debug "fullName: " + ls_FullName
    end if

    // There can be multiple email addresses, so it's stored as a JSON array..
    li_NumEmailAddresses = loo_Json.SizeOfArray("feed.entry[i].gd$email")
    j = 0
    do while j < li_NumEmailAddresses
        ls_EmailAddress = loo_Json.StringOf("feed.entry[i].gd$email[j].address")
        if loo_Json.LastMethodSuccess = 1 then
            Write-Debug "email address: " + ls_EmailAddress
        end if

        j = j + 1
    loop

    i = i + 1
loop

// A sample Google Contacts JSON response:

// 	{ 
// 	  "version": "1.0",
// 	  "encoding": "UTF-8",
// 	  "feed": { 
// 	    "xmlns": "http://www.w3.org/2005/Atom",
// 	    "xmlns$openSearch": "http://a9.com/-/spec/opensearch/1.1/",
// 	    "xmlns$gContact": "http://schemas.google.com/contact/2008",
// 	    "xmlns$batch": "http://schemas.google.com/gdata/batch",
// 	    "xmlns$gd": "http://schemas.google.com/g/2005",
// 	    "gd$etag": "\"QHw5eTVSLyt7I2A9XRFaE0kNTwI.\"",
// 	    "id": { 
// 	      "$t": "chilkat.support@gmail.com"
// 	    },
// 	    "updated": { 
// 	      "$t": "2016-11-17T01:57:41.221Z"
// 	    },
// 	    "category": [
// 	      { 
// 	        "scheme": "http://schemas.google.com/g/2005#kind",
// 	        "term": "http://schemas.google.com/contact/2008#contact"
// 	      }
// 	    ],
// 	    "title": { 
// 	      "$t": "Chilkat Support's Contacts"
// 	    },
// 	    "link": [
// 	      { 
// 	        "rel": "alternate",
// 	        "type": "text/html",
// 	        "href": "https://www.googleapis.com/"
// 	      },
// 	      { 
// 	        "rel": "http://schemas.google.com/g/2005#feed",
// 	        "type": "application/atom+xml",
// 	        "href": "https://www.googleapis.com/m8/feeds/contacts/chilkat.support%40gmail.com/full"
// 	      },
// 	      { 
// 	        "rel": "http://schemas.google.com/g/2005#post",
// 	        "type": "application/atom+xml",
// 	        "href": "https://www.googleapis.com/m8/feeds/contacts/chilkat.support%40gmail.com/full"
// 	      },
// 	      { 
// 	        "rel": "http://schemas.google.com/g/2005#batch",
// 	        "type": "application/atom+xml",
// 	        "href": "https://www.googleapis.com/m8/feeds/contacts/chilkat.support%40gmail.com/full/batch"
// 	      },
// 	      { 
// 	        "rel": "self",
// 	        "type": "application/atom+xml",
// 	        "href": "https://www.googleapis.com/m8/feeds/contacts/chilkat.support%40gmail.com/full?max-results=25&alt=json"
// 	      },
// 	      { 
// 	        "rel": "next",
// 	        "type": "application/atom+xml",
// 	        "href": "https://www.googleapis.com/m8/feeds/contacts/chilkat.support%40gmail.com/full?max-results=25&alt=json&start-index=26"
// 	      }
// 	    ],
// 	    "author": [
// 	      { 
// 	        "name": { 
// 	          "$t": "Chilkat Support"
// 	        },
// 	        "email": { 
// 	          "$t": "chilkat.support@gmail.com"
// 	        }
// 	      }
// 	    ],
// 	    "generator": { 
// 	      "version": "1.0",
// 	      "uri": "http://www.google.com/m8/feeds",
// 	      "$t": "Contacts"
// 	    },
// 	    "openSearch$totalResults": { 
// 	      "$t": "350"
// 	    },
// 	    "openSearch$startIndex": { 
// 	      "$t": "1"
// 	    },
// 	    "openSearch$itemsPerPage": { 
// 	      "$t": "25"
// 	    },
// 	    "entry": [
// 	      { 
// 	        "id": { 
// 	          "$t": "http://www.google.com/m8/feeds/contacts/chilkat.support%40gmail.com/base/0"
// 	        },
// 	        "gd$etag": "\"SX8zcTVSLyt7I2A9WxBXFU4MQwI.\"",
// 	        "updated": { 
// 	          "$t": "2010-01-26T20:07:48.189Z"
// 	        },
// 	        "app$edited": { 
// 	          "xmlns$app": "http://www.w3.org/2007/app",
// 	          "$t": "2010-01-26T20:07:48.189Z"
// 	        },
// 	        "category": [
// 	          { 
// 	            "scheme": "http://schemas.google.com/g/2005#kind",
// 	            "term": "http://schemas.google.com/contact/2008#contact"
// 	          }
// 	        ],
// 	        "title": { 
// 	          "$t": "Joe Sample"
// 	        },
// 	        "link": [
// 	          { 
// 	            "rel": "http://schemas.google.com/contacts/2008/rel#photo",
// 	            "type": "image/*",
// 	            "href": "https://www.googleapis.com/m8/feeds/photos/media/chilkat.support%40gmail.com/0"
// 	          },
// 	          { 
// 	            "rel": "self",
// 	            "type": "application/atom+xml",
// 	            "href": "https://www.googleapis.com/m8/feeds/contacts/chilkat.support%40gmail.com/full/0"
// 	          },
// 	          { 
// 	            "rel": "edit",
// 	            "type": "application/atom+xml",
// 	            "href": "https://www.googleapis.com/m8/feeds/contacts/chilkat.support%40gmail.com/full/0"
// 	          }
// 	        ],
// 	        "gd$name": { 
// 	          "gd$fullName": { 
// 	            "$t": "Joe Sample"
// 	          },
// 	          "gd$givenName": { 
// 	            "$t": "Joe"
// 	          },
// 	          "gd$familyName": { 
// 	            "$t": "Sample"
// 	          }
// 	        },
// 	        "gd$email": [
// 	          { 
// 	            "address": "somebody@gmail.com",
// 	            "primary": "true",
// 	            "rel": "http://schemas.google.com/g/2005#other"
// 	          }
// 	        ]
// 	      },
// 		... more entries ...
// 	


destroy loo_JsonToken
destroy loo_GAuth
destroy loo_Rest
destroy loo_SbResponseBody
destroy loo_Json