VBScript

Datev - Get a List of Clients

See more Datev Examples

Demonstrates how to get a list of clients in the accounting:clients Datev API. VBScript

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

success = 0

set http = CreateObject("Chilkat.Http")

' 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

set queryParams = CreateObject("Chilkat.JsonObject")
' 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"

set resp = CreateObject("Chilkat.HttpResponse")
success = http.HttpParams("GET","https://accounting-clients.api.datev.de/platform-sandbox/v2/clients",queryParams,resp)
If (success = 0) Then
    outFile.WriteLine(http.LastErrorText)
    WScript.Quit
End If

outFile.WriteLine(resp.StatusCode)
outFile.WriteLine(resp.BodyStr)

set jarr = CreateObject("Chilkat.JsonArray")

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

i = 0
count_i = jarr.Size
Do While i < count_i
    ' json is a Chilkat.JsonObject
    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

outFile.Close