(Visual Basic 6.0) Datev - Get a List of Clients

See more Datev Examples

Note: This example requires Chilkat v10.1.3 or greater.

For more information, see https://developer.datev.de/en/product-detail/accounting-clients/2.0/reference/reference-api-overview/accountingclients/clients-get

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

Dim http As New ChilkatHttp
Dim success As Long

' Implements the following CURL command:

' curl --request GET \
'   --url "https://accounting-clients.api.datev.de/platform/v2/clients?filter=REPLACE_THIS_VALUE&skip=REPLACE_THIS_VALUE&top=REPLACE_THIS_VALUE" \
'   --header "Authorization: Bearer REPLACE_BEARER_TOKEN" \
'   --header "X-Datev-Client-ID: clientId" \
'   --header "accept: application/json;charset=utf-8"

' Use the following online tool to generate HTTP code from a CURL command
' Convert a cURL Command to HTTP Source Code

Dim queryParams As New ChilkatJsonObject
' ignore = queryParams.UpdateString("filter","REPLACE_THIS_VALUE");
' ignore = queryParams.UpdateString("skip","REPLACE_THIS_VALUE");
' ignore = queryParams.UpdateString("top","REPLACE_THIS_VALUE");

' Adds the "Authorization: Bearer REPLACE_BEARER_TOKEN" header.
http.AuthToken = "REPLACE_BEARER_TOKEN"
http.SetRequestHeader "accept","application/json;charset=utf-8"
http.SetRequestHeader "X-Datev-Client-ID","DATEV_CLIENT_ID"

Dim resp As ChilkatHttpResponse
Set resp = http.QuickRequestParams("GET","https://accounting-clients.api.datev.de/platform-sandbox/v2/clients",queryParams)
If (http.LastMethodSuccess = 0) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print resp.StatusCode
Debug.Print resp.BodyStr

Dim jarr As New ChilkatJsonArray

' Insert code here to load the above JSON array into the jarr object.
success = jarr.Load(resp.BodyStr)

Dim json As ChilkatJsonObject
Dim client_number As Long
Dim consultant_number As Long
Dim id As String
Dim name As String
Dim j As Long
Dim count_j As Long
Dim k As Long
Dim count_k As Long
Dim strVal 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)
    client_number = json.IntOf("client_number")
    consultant_number = json.IntOf("consultant_number")
    id = json.StringOf("id")
    name = json.StringOf("name")
    j = 0
    count_j = json.SizeOfArray("services")
    Do While j < count_j
        json.J = j
        name = json.StringOf("services[j].name")
        k = 0
        count_k = json.SizeOfArray("services[j].scopes")
        Do While k < count_k
            json.K = k
            strVal = json.StringOf("services[j].scopes[k]")
            k = k + 1
        Loop
        j = j + 1
    Loop

    i = i + 1
Loop