(Excel) Google Search Console API - List

Lists the user's Search Console sites.

For more information, see https://developers.google.com/webmaster-tools/search-console-api-original/v3/sites/list

Download Excel Class Modules Chilkat Excel Class Modules

' 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..
Dim jsonToken As Chilkat.JsonObject
Set jsonToken = Chilkat.NewJsonObject

success = jsonToken.LoadFile("qa_data/tokens/googleSearchConsole.json")
If (jsonToken.HasMember("access_token") = False) Then
    Debug.Print "No access token found."
    Exit Sub
End If

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp
http.AuthToken = jsonToken.StringOf("access_token")


responseStr = http.QuickGetStr("https://www.googleapis.com/webmasters/v3/sites")
If (http.LastMethodSuccess = False) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If


statusCode = http.LastStatus
Debug.Print "Response Status Code: "; statusCode

' Sample response:

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

Debug.Print responseStr

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

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject

success = json.Load(responseStr)


i = 0

count_i = json.SizeOfArray("siteEntry")
Do While i < count_i
    json.I = i
    siteUrl = json.StringOf("siteEntry[i].siteUrl")
    Debug.Print "siteUrl: "; siteUrl
    permissionLevel = json.StringOf("siteEntry[i].permissionLevel")
    Debug.Print "permissionLevel: "; permissionLevel
    i = i + 1
Loop