PowerBuilder

Google Search Console API - List

See more Google Search Console Examples

Lists the user's Search Console sites. PowerBuilder

integer li_rc
long li_Success
oleobject loo_JsonToken
oleobject loo_Http
string ls_ResponseStr
long li_StatusCode
oleobject loo_Json
string ls_SiteUrl
string ls_PermissionLevel
long i
long li_Count_i

li_Success = 0

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

//  This example uses a previously obtained access token having permission for the 
//  Google Search Console scope.

//  In this example, Get a Google Search Console OAuth2 Access Token, the access
//  token was saved to a JSON file.  This example fetches the access token from the file..
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/googleSearchConsole.json")
if loo_JsonToken.HasMember("access_token") = 0 then
    Write-Debug "No access token found."
    destroy loo_JsonToken
    return
end if

loo_Http = create oleobject
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")

loo_Http.AuthToken = loo_JsonToken.StringOf("access_token")

ls_ResponseStr = loo_Http.QuickGetStr("https://www.googleapis.com/webmasters/v3/sites")
if loo_Http.LastMethodSuccess = 0 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_JsonToken
    destroy loo_Http
    return
end if

li_StatusCode = loo_Http.LastStatus
Write-Debug "Response Status Code: " + string(li_StatusCode)

//  Sample response:

//  {
//   "siteEntry": [
//    {
//     "siteUrl": "https://www.example.com/",
//     "permissionLevel": "siteUnverifiedUser"
//    },
//    {
//     "siteUrl": "http://www.chilkatsoft.com/",
//     "permissionLevel": "siteOwner"
//    }
//   ]
//  }

Write-Debug ls_ResponseStr

//  Use this online tool to generate parsing code from sample JSON: 
//  Generate Parsing Code from JSON

loo_Json = create oleobject
li_rc = loo_Json.ConnectToNewObject("Chilkat.JsonObject")

li_Success = loo_Json.Load(ls_ResponseStr)

i = 0
li_Count_i = loo_Json.SizeOfArray("siteEntry")
do while i < li_Count_i
    loo_Json.I = i
    ls_SiteUrl = loo_Json.StringOf("siteEntry[i].siteUrl")
    Write-Debug "siteUrl: " + ls_SiteUrl
    ls_PermissionLevel = loo_Json.StringOf("siteEntry[i].permissionLevel")
    Write-Debug "permissionLevel: " + ls_PermissionLevel
    i = i + 1
loop


destroy loo_JsonToken
destroy loo_Http
destroy loo_Json