Visual FoxPro

Datev - Get a List of Clients

See more Datev Examples

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

LOCAL lnSuccess
LOCAL loHttp
LOCAL loQueryParams
LOCAL loResp
LOCAL loJarr
LOCAL loJson
LOCAL lnClient_number
LOCAL lnConsultant_number
LOCAL lcId
LOCAL lcName
LOCAL j
LOCAL lnCount_j
LOCAL k
LOCAL lnCount_k
LOCAL lcStrVal
LOCAL i
LOCAL lnCount_i

lnSuccess = 0

loHttp = 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

loQueryParams = 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.
loHttp.AuthToken = "REPLACE_BEARER_TOKEN"
loHttp.SetRequestHeader("accept","application/json;charset=utf-8")
loHttp.SetRequestHeader("X-Datev-Client-ID","DATEV_CLIENT_ID")

loResp = CreateObject('Chilkat.HttpResponse')
lnSuccess = loHttp.HttpParams("GET","https://accounting-clients.api.datev.de/platform-sandbox/v2/clients",loQueryParams,loResp)
IF (lnSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loQueryParams
    RELEASE loResp
    CANCEL
ENDIF

? STR(loResp.StatusCode)
? loResp.BodyStr

loJarr = CreateObject('Chilkat.JsonArray')

* Insert code here to load the above JSON array into the jarr object.
loJarr.Load(loResp.BodyStr)

i = 0
lnCount_i = loJarr.Size
DO WHILE i < lnCount_i
    loJson = loJarr.ObjectAt(i)
    lnClient_number = loJson.IntOf("client_number")
    lnConsultant_number = loJson.IntOf("consultant_number")
    lcId = loJson.StringOf("id")
    lcName = loJson.StringOf("name")
    j = 0
    lnCount_j = loJson.SizeOfArray("services")
    DO WHILE j < lnCount_j
        loJson.J = j
        lcName = loJson.StringOf("services[j].name")
        k = 0
        lnCount_k = loJson.SizeOfArray("services[j].scopes")
        DO WHILE k < lnCount_k
            loJson.K = k
            lcStrVal = loJson.StringOf("services[j].scopes[k]")
            k = k + 1
        ENDDO
        j = j + 1
    ENDDO
    RELEASE loJson
    i = i + 1
ENDDO

RELEASE loHttp
RELEASE loQueryParams
RELEASE loResp
RELEASE loJarr