(Excel) Xero Get Full Set of Tenants

Check the full set of tenants you've been authorized to access

For more information, see https://developer.xero.com/documentation/oauth2/auth-flow

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.

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

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

success = jsonToken.LoadFile("qa_data/tokens/xero-access-token.json")
If (success = False) Then
    Debug.Print jsonToken.LastErrorText
    Exit Sub
End If

http.AuthToken = jsonToken.StringOf("access_token")

http.Accept = "application/json"


Set resp = http.QuickRequest("GET","https://api.xero.com/connections")
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print "Response Status Code: "; resp.StatusCode

Dim jarr As Chilkat.JsonArray
Set jarr = Chilkat.NewJsonArray
Dim success As Boolean
success = jarr.Load(resp.BodyStr)
jarr.EmitCompact = False
Debug.Print jarr.Emit()

If (resp.StatusCode <> 200) Then
    Debug.Print "Failed."

    Exit Sub
End If

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

' [
'     {
'         "id": "c869f3b7-6435-4c7e-8cb2-122721b04a69",
'         "tenantId": "45e4708e-d862-4111-ab3a-dd8cd03913e1",
'         "tenantType": "ORGANISATION",
'         "createdDateUtc": "2020-02-02T19:17:58.1117990",
'         "updatedDateUtc": "2020-02-02T19:17:58.1117990"
'     },
'     {
'         "id": "74305bf3-12e0-45e2-8dc8-e3ec73e3b1f9",
'         "tenantId": "c3d5e782-2153-4cda-bdb4-cec791ceb90d",
'         "tenantType": "ORGANISATION",
'         "createdDateUtc": "2020-01-30T01:33:36.2717380",
'         "updatedDateUtc": "2020-02-02T19:21:08.5739590"
'     }
' ]


i = 0

count_i = jarr.Size
Do While i < count_i
    Set json = jarr.ObjectAt(i)
    id = json.StringOf("id")
    tenantId = json.StringOf("tenantId")
    tenantType = json.StringOf("tenantType")
    createdDateUtc = json.StringOf("createdDateUtc")
    updatedDateUtc = json.StringOf("updatedDateUtc")

    i = i + 1
Loop