(Visual FoxPro) 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

LOCAL loHttp
LOCAL lnSuccess
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

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.Http')
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

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonObject')
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 = loHttp.QuickRequestParams("GET","https://accounting-clients.api.datev.de/platform-sandbox/v2/clients",loQueryParams)
IF (loHttp.LastMethodSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loQueryParams
    CANCEL
ENDIF

? STR(loResp.StatusCode)
? loResp.BodyStr

* For versions of Chilkat < 10.0.0, use CreateObject('Chilkat_9_5_0.JsonArray')
loJarr = CreateObject('Chilkat.JsonArray')

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

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 loJarr