(PowerShell) 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 .NET Downloads Chilkat .NET Assemblies

Add-Type -Path "C:\chilkat\ChilkatDotNet47-9.5.0-x64\ChilkatDotNet47.dll"

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

$http = New-Object Chilkat.Http

$jsonToken = New-Object Chilkat.JsonObject
$success = $jsonToken.LoadFile("qa_data/tokens/xero-access-token.json")
if ($success -eq $false) {
    $($jsonToken.LastErrorText)
    exit
}

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

$http.Accept = "application/json"

$resp = $http.QuickRequest("GET","https://api.xero.com/connections")
if ($http.LastMethodSuccess -ne $true) {
    $($http.LastErrorText)
    exit
}

$("Response Status Code: " + $resp.StatusCode)

$jarr = New-Object Chilkat.JsonArray
$jarr.Load($resp.BodyStr)
$jarr.EmitCompact = $false
$($jarr.Emit())

if ($resp.StatusCode -ne 200) {
    $("Failed.")

    exit
}

# 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
while ($i -lt $count_i) {
    $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
}