(Visual Basic 6.0) 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

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

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

Dim http As New ChilkatHttp

Dim jsonToken As New ChilkatJsonObject
Dim success As Long
success = jsonToken.LoadFile("qa_data/tokens/xero-access-token.json")
If (success = 0) Then
    Debug.Print jsonToken.LastErrorText
    Exit Sub
End If

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

http.Accept = "application/json"

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

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

Dim jarr As New ChilkatJsonArray
success = jarr.Load(resp.BodyStr)
jarr.EmitCompact = 0
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"
'     }
' ]

Dim json As ChilkatJsonObject
Dim id As String
Dim tenantId As String
Dim tenantType As String
Dim createdDateUtc As String
Dim updatedDateUtc As String

Dim i As Long
i = 0
Dim count_i As Long
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