(DataFlex) 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

Use ChilkatAx-win32.pkg

Procedure Test
    Handle hoHttp
    Handle hoJsonToken
    Boolean iSuccess
    Variant vResp
    Handle hoResp
    Handle hoJarr
    Variant vJson
    Handle hoJson
    String sId
    String sTenantId
    String sTenantType
    String sCreatedDateUtc
    String sUpdatedDateUtc
    Integer i
    Integer iCount_i
    String sTemp1
    Integer iTemp1
    Boolean bTemp1

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

    Get Create (RefClass(cComChilkatHttp)) To hoHttp
    If (Not(IsComObjectCreated(hoHttp))) Begin
        Send CreateComObject of hoHttp
    End

    Get Create (RefClass(cComChilkatJsonObject)) To hoJsonToken
    If (Not(IsComObjectCreated(hoJsonToken))) Begin
        Send CreateComObject of hoJsonToken
    End
    Get ComLoadFile Of hoJsonToken "qa_data/tokens/xero-access-token.json" To iSuccess
    If (iSuccess = False) Begin
        Get ComLastErrorText Of hoJsonToken To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    Get ComStringOf Of hoJsonToken "access_token" To sTemp1
    Set ComAuthToken Of hoHttp To sTemp1

    Set ComAccept Of hoHttp To "application/json"

    Get ComQuickRequest Of hoHttp "GET" "https://api.xero.com/connections" To vResp
    If (IsComObject(vResp)) Begin
        Get Create (RefClass(cComChilkatHttpResponse)) To hoResp
        Set pvComObject Of hoResp To vResp
    End
    Get ComLastMethodSuccess Of hoHttp To bTemp1
    If (bTemp1 <> True) Begin
        Get ComLastErrorText Of hoHttp To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    Get ComStatusCode Of hoResp To iTemp1
    Showln "Response Status Code: " iTemp1

    Get Create (RefClass(cComChilkatJsonArray)) To hoJarr
    If (Not(IsComObjectCreated(hoJarr))) Begin
        Send CreateComObject of hoJarr
    End
    Get ComBodyStr Of hoResp To sTemp1
    Get ComLoad Of hoJarr sTemp1 To iSuccess
    Set ComEmitCompact Of hoJarr To False
    Get ComEmit Of hoJarr To sTemp1
    Showln sTemp1

    Get ComStatusCode Of hoResp To iTemp1
    If (iTemp1 <> 200) Begin
        Showln "Failed."
        Send Destroy of hoResp
        Procedure_Return
    End

    Send Destroy of hoResp

    // 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"
    //     }
    // ]

    Move 0 To i
    Get ComSize Of hoJarr To iCount_i
    While (i < iCount_i)
        Get ComObjectAt Of hoJarr i To vJson
        If (IsComObject(vJson)) Begin
            Get Create (RefClass(cComChilkatJsonObject)) To hoJson
            Set pvComObject Of hoJson To vJson
        End
        Get ComStringOf Of hoJson "id" To sId
        Get ComStringOf Of hoJson "tenantId" To sTenantId
        Get ComStringOf Of hoJson "tenantType" To sTenantType
        Get ComStringOf Of hoJson "createdDateUtc" To sCreatedDateUtc
        Get ComStringOf Of hoJson "updatedDateUtc" To sUpdatedDateUtc
        Send Destroy of hoJson
        Move (i + 1) To i
    Loop



End_Procedure