PowerBuilder
PowerBuilder
Google Contacts - Retrieve as JSON
See more Google APIs Examples
Demonstrates how to retrieve Google Contacts as JSON.Chilkat PowerBuilder Downloads
integer li_rc
integer li_Success
oleobject loo_JsonToken
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
li_Success = 0
// 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.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.AuthGoogle")
loo_GAuth.AccessToken = loo_JsonToken.StringOf("access_token")
loo_Rest = create oleobject
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
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
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