Chilkat Online Tools

autoit / easybill REST API / Fetch projects list

Back to Collection Items

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

$oHttp = ObjCreate("Chilkat.Http")
Local $bSuccess

$oQueryParams = ObjCreate("Chilkat.JsonObject")
$oQueryParams.UpdateString("limit","<integer>")
$oQueryParams.UpdateString("page","<integer>")
$oQueryParams.UpdateString("customer_id","<string>")
$oQueryParams.UpdateString("status","DONE")

$oHttp.SetRequestHeader "Authorization","{{apiKey}}"
$oHttp.SetRequestHeader "Accept","application/json"

Local $oResp = $oHttp.QuickRequestParams("GET","https://api.easybill.de/rest/v1/projects",$oQueryParams)
If ($oHttp.LastMethodSuccess = False) Then
    ConsoleWrite($oHttp.LastErrorText & @CRLF)
    Exit
EndIf

$oSbResponseBody = ObjCreate("Chilkat.StringBuilder")
$oResp.GetBodySb($oSbResponseBody)

$oJResp = ObjCreate("Chilkat.JsonObject")
$oJResp.LoadSb($oSbResponseBody)
$oJResp.EmitCompact = False

ConsoleWrite("Response Body:" & @CRLF)
ConsoleWrite($oJResp.Emit() & @CRLF)

Local $iRespStatusCode = $oResp.StatusCode
ConsoleWrite("Response Status Code = " & $iRespStatusCode & @CRLF)
If ($iRespStatusCode >= 400) Then
    ConsoleWrite("Response Header:" & @CRLF)
    ConsoleWrite($oResp.Header & @CRLF)
    ConsoleWrite("Failed." & @CRLF)

    Exit
EndIf

; Sample JSON response:
; (Sample code for parsing the JSON response is shown below)

; {
;   "page": "<integer>",
;   "pages": "<integer>",
;   "limit": "<integer>",
;   "total": "<integer>",
;   "items": [
;     {
;       "name": "<string>",
;       "budget_amount": 0,
;       "budget_time": 0,
;       "customer_id": null,
;       "hourly_rate": "<float>",
;       "id": "<long>",
;       "login_id": "<long>",
;       "note": null,
;       "status": "OPEN",
;       "due_at": null,
;       "budget_notify_frequency": "ALWAYS",
;       "consumed_time": "<integer>",
;       "consumed_amount": "<integer>"
;     },
;     {
;       "name": "<string>",
;       "budget_amount": 0,
;       "budget_time": 0,
;       "customer_id": null,
;       "hourly_rate": "<float>",
;       "id": "<long>",
;       "login_id": "<long>",
;       "note": null,
;       "status": "OPEN",
;       "due_at": null,
;       "budget_notify_frequency": "ALWAYS",
;       "consumed_time": "<integer>",
;       "consumed_amount": "<integer>"
;     }
;   ]
; }

; Sample code for parsing the JSON response...
; Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code

Local $sName
Local $iBudget_amount
Local $iBudget_time
Local $sCustomer_id
Local $sHourly_rate
Local $sId
Local $sLogin_id
Local $sNote
Local $status
Local $sDue_at
Local $sBudget_notify_frequency
Local $sConsumed_time
Local $sConsumed_amount

Local $sPage = $oJResp.StringOf("page")
Local $sPages = $oJResp.StringOf("pages")
Local $sLimit = $oJResp.StringOf("limit")
Local $sTotal = $oJResp.StringOf("total")
Local $i = 0
Local $iCount_i = $oJResp.SizeOfArray("items")
While $i < $iCount_i
    $oJResp.I = $i
    $sName = $oJResp.StringOf("items[i].name")
    $iBudget_amount = $oJResp.IntOf("items[i].budget_amount")
    $iBudget_time = $oJResp.IntOf("items[i].budget_time")
    $sCustomer_id = $oJResp.StringOf("items[i].customer_id")
    $sHourly_rate = $oJResp.StringOf("items[i].hourly_rate")
    $sId = $oJResp.StringOf("items[i].id")
    $sLogin_id = $oJResp.StringOf("items[i].login_id")
    $sNote = $oJResp.StringOf("items[i].note")
    $status = $oJResp.StringOf("items[i].status")
    $sDue_at = $oJResp.StringOf("items[i].due_at")
    $sBudget_notify_frequency = $oJResp.StringOf("items[i].budget_notify_frequency")
    $sConsumed_time = $oJResp.StringOf("items[i].consumed_time")
    $sConsumed_amount = $oJResp.StringOf("items[i].consumed_amount")
    $i = $i + 1
Wend

Curl Command

curl -G -d "limit=%3Cinteger%3E"
	-d "page=%3Cinteger%3E"
	-d "customer_id=%3Cstring%3E"
	-d "status=DONE"
	-H "Authorization: {{apiKey}}"
	-H "Accept: application/json"
https://api.easybill.de/rest/v1/projects

Postman Collection Item JSON

{
  "name": "Fetch projects list",
  "request": {
    "method": "GET",
    "header": [
      {
        "key": "Accept",
        "value": "application/json"
      }
    ],
    "url": {
      "raw": "{{baseUrl}}/projects?limit=<integer>&page=<integer>&customer_id=<string>&status=DONE",
      "host": [
        "{{baseUrl}}"
      ],
      "path": [
        "projects"
      ],
      "query": [
        {
          "key": "limit",
          "value": "<integer>",
          "description": "Limited the result. Default is 100. Maximum can be 1000."
        },
        {
          "key": "page",
          "value": "<integer>",
          "description": "Set current Page. Default is 1."
        },
        {
          "key": "customer_id",
          "value": "<string>",
          "description": "Filter projects by customer_id. You can add multiple ids separate by comma like id,id,id."
        },
        {
          "key": "status",
          "value": "DONE",
          "description": "Filter projects by status."
        }
      ]
    }
  },
  "response": [
    {
      "name": "Successful operation",
      "originalRequest": {
        "method": "GET",
        "header": [
          {
            "key": "Accept",
            "value": "application/json"
          },
          {
            "description": "Added as a part of security scheme: apikey",
            "key": "Authorization",
            "value": "<API Key>"
          }
        ],
        "url": {
          "raw": "{{baseUrl}}/projects?limit=<integer>&page=<integer>&customer_id=<string>&status=DONE",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "projects"
          ],
          "query": [
            {
              "key": "limit",
              "value": "<integer>",
              "description": "Limited the result. Default is 100. Maximum can be 1000."
            },
            {
              "key": "page",
              "value": "<integer>",
              "description": "Set current Page. Default is 1."
            },
            {
              "key": "customer_id",
              "value": "<string>",
              "description": "Filter projects by customer_id. You can add multiple ids separate by comma like id,id,id."
            },
            {
              "key": "status",
              "value": "DONE",
              "description": "Filter projects by status."
            }
          ]
        }
      },
      "status": "OK",
      "code": 200,
      "_postman_previewlanguage": "json",
      "header": [
        {
          "key": "Content-Type",
          "value": "application/json"
        }
      ],
      "cookie": [
      ],
      "body": "{\n  \"page\": \"<integer>\",\n  \"pages\": \"<integer>\",\n  \"limit\": \"<integer>\",\n  \"total\": \"<integer>\",\n  \"items\": [\n    {\n      \"name\": \"<string>\",\n      \"budget_amount\": 0,\n      \"budget_time\": 0,\n      \"customer_id\": null,\n      \"hourly_rate\": \"<float>\",\n      \"id\": \"<long>\",\n      \"login_id\": \"<long>\",\n      \"note\": null,\n      \"status\": \"OPEN\",\n      \"due_at\": null,\n      \"budget_notify_frequency\": \"ALWAYS\",\n      \"consumed_time\": \"<integer>\",\n      \"consumed_amount\": \"<integer>\"\n    },\n    {\n      \"name\": \"<string>\",\n      \"budget_amount\": 0,\n      \"budget_time\": 0,\n      \"customer_id\": null,\n      \"hourly_rate\": \"<float>\",\n      \"id\": \"<long>\",\n      \"login_id\": \"<long>\",\n      \"note\": null,\n      \"status\": \"OPEN\",\n      \"due_at\": null,\n      \"budget_notify_frequency\": \"ALWAYS\",\n      \"consumed_time\": \"<integer>\",\n      \"consumed_amount\": \"<integer>\"\n    }\n  ]\n}"
    },
    {
      "name": "Too Many Requests",
      "originalRequest": {
        "method": "GET",
        "header": [
          {
            "description": "Added as a part of security scheme: apikey",
            "key": "Authorization",
            "value": "<API Key>"
          }
        ],
        "url": {
          "raw": "{{baseUrl}}/projects?limit=<integer>&page=<integer>&customer_id=<string>&status=DONE",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "projects"
          ],
          "query": [
            {
              "key": "limit",
              "value": "<integer>",
              "description": "Limited the result. Default is 100. Maximum can be 1000."
            },
            {
              "key": "page",
              "value": "<integer>",
              "description": "Set current Page. Default is 1."
            },
            {
              "key": "customer_id",
              "value": "<string>",
              "description": "Filter projects by customer_id. You can add multiple ids separate by comma like id,id,id."
            },
            {
              "key": "status",
              "value": "DONE",
              "description": "Filter projects by status."
            }
          ]
        }
      },
      "status": "Too Many Requests",
      "code": 429,
      "_postman_previewlanguage": "text",
      "header": [
      ],
      "cookie": [
      ],
      "body": ""
    }
  ]
}