Chilkat Online Tools

DataFlex / easybill REST API / Fetch projects list

Back to Collection Items

Use ChilkatAx-win32.pkg

Procedure Test
    Handle hoHttp
    Boolean iSuccess
    Variant vQueryParams
    Handle hoQueryParams
    Variant vResp
    Handle hoResp
    Variant vSbResponseBody
    Handle hoSbResponseBody
    Handle hoJResp
    Integer iRespStatusCode
    String sName
    Integer iBudget_amount
    Integer iBudget_time
    String sCustomer_id
    String sHourly_rate
    String sId
    String sLogin_id
    String sNote
    String sStatus
    String sDue_at
    String sBudget_notify_frequency
    String sConsumed_time
    String sConsumed_amount
    String sPage
    String sPages
    String sLimit
    String sTotal
    Integer i
    Integer iCount_i
    String sTemp1
    Boolean bTemp1

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

    Get Create (RefClass(cComChilkatHttp)) To hoHttp
    If (Not(IsComObjectCreated(hoHttp))) Begin
        Send CreateComObject of hoHttp
    End

    Get Create (RefClass(cComChilkatJsonObject)) To hoQueryParams
    If (Not(IsComObjectCreated(hoQueryParams))) Begin
        Send CreateComObject of hoQueryParams
    End
    Get ComUpdateString Of hoQueryParams "limit" "<integer>" To iSuccess
    Get ComUpdateString Of hoQueryParams "page" "<integer>" To iSuccess
    Get ComUpdateString Of hoQueryParams "customer_id" "<string>" To iSuccess
    Get ComUpdateString Of hoQueryParams "status" "DONE" To iSuccess

    Send ComSetRequestHeader To hoHttp "Authorization" "{{apiKey}}"
    Send ComSetRequestHeader To hoHttp "Accept" "application/json"

    Get pvComObject of hoQueryParams to vQueryParams
    Get ComQuickRequestParams Of hoHttp "GET" "https://api.easybill.de/rest/v1/projects" vQueryParams To vResp
    If (IsComObject(vResp)) Begin
        Get Create (RefClass(cComChilkatHttpResponse)) To hoResp
        Set pvComObject Of hoResp To vResp
    End
    Get ComLastMethodSuccess Of hoHttp To bTemp1
    If (bTemp1 = False) Begin
        Get ComLastErrorText Of hoHttp To sTemp1
        Showln sTemp1
        Procedure_Return
    End

    Get Create (RefClass(cComChilkatStringBuilder)) To hoSbResponseBody
    If (Not(IsComObjectCreated(hoSbResponseBody))) Begin
        Send CreateComObject of hoSbResponseBody
    End
    Get pvComObject of hoSbResponseBody to vSbResponseBody
    Get ComGetBodySb Of hoResp vSbResponseBody To iSuccess

    Get Create (RefClass(cComChilkatJsonObject)) To hoJResp
    If (Not(IsComObjectCreated(hoJResp))) Begin
        Send CreateComObject of hoJResp
    End
    Get pvComObject of hoSbResponseBody to vSbResponseBody
    Get ComLoadSb Of hoJResp vSbResponseBody To iSuccess
    Set ComEmitCompact Of hoJResp To False

    Showln "Response Body:"
    Get ComEmit Of hoJResp To sTemp1
    Showln sTemp1

    Get ComStatusCode Of hoResp To iRespStatusCode
    Showln "Response Status Code = " iRespStatusCode
    If (iRespStatusCode >= 400) Begin
        Showln "Response Header:"
        Get ComHeader Of hoResp To sTemp1
        Showln sTemp1
        Showln "Failed."
        Send Destroy of hoResp
        Procedure_Return
    End

    Send Destroy of hoResp

    // 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

    Get ComStringOf Of hoJResp "page" To sPage
    Get ComStringOf Of hoJResp "pages" To sPages
    Get ComStringOf Of hoJResp "limit" To sLimit
    Get ComStringOf Of hoJResp "total" To sTotal
    Move 0 To i
    Get ComSizeOfArray Of hoJResp "items" To iCount_i
    While (i < iCount_i)
        Set ComI Of hoJResp To i
        Get ComStringOf Of hoJResp "items[i].name" To sName
        Get ComIntOf Of hoJResp "items[i].budget_amount" To iBudget_amount
        Get ComIntOf Of hoJResp "items[i].budget_time" To iBudget_time
        Get ComStringOf Of hoJResp "items[i].customer_id" To sCustomer_id
        Get ComStringOf Of hoJResp "items[i].hourly_rate" To sHourly_rate
        Get ComStringOf Of hoJResp "items[i].id" To sId
        Get ComStringOf Of hoJResp "items[i].login_id" To sLogin_id
        Get ComStringOf Of hoJResp "items[i].note" To sNote
        Get ComStringOf Of hoJResp "items[i].status" To sStatus
        Get ComStringOf Of hoJResp "items[i].due_at" To sDue_at
        Get ComStringOf Of hoJResp "items[i].budget_notify_frequency" To sBudget_notify_frequency
        Get ComStringOf Of hoJResp "items[i].consumed_time" To sConsumed_time
        Get ComStringOf Of hoJResp "items[i].consumed_amount" To sConsumed_amount
        Move (i + 1) To i
    Loop



End_Procedure

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": ""
    }
  ]
}