PowerBuilder

Google Search Console API - List

See more Google Search Console Examples

Lists the user's Search Console sites. PowerBuilder

integer li_rc
integer li_Success
oleobject loo_JsonToken
oleobject loo_Http
string ls_ResponseStr
integer li_StatusCode
oleobject loo_Json
string ls_SiteUrl
string ls_PermissionLevel
integer i
integer 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