Chilkat Online Tools

PowerBuilder / easybill REST API / Fetch customer

Back to Collection Items

integer li_rc
oleobject loo_Http
integer li_Success
oleobject loo_SbResponseBody
oleobject loo_JResp
integer li_RespStatusCode
string ls_StrVal
string ls_Last_name
string ls_Company_name
integer li_Acquire_options
string ls_Bank_account
string ls_Bank_account_owner
string ls_Bank_bic
string ls_Bank_code
string ls_Bank_iban
string ls_Bank_name
string ls_Birth_date
string ls_Cash_allowance
integer li_Cash_allowance_days
string ls_Cash_discount
string ls_Cash_discount_type
string ls_City
string ls_State
string ls_Country
string ls_Created_at
string ls_Updated_at
string ls_Delivery_title
string ls_Delivery_city
string ls_Delivery_state
string ls_Delivery_company_name
string ls_Delivery_country
string ls_Delivery_first_name
string ls_Delivery_last_name
string ls_Delivery_personal
integer li_Delivery_salutation
string ls_Delivery_street
string ls_Delivery_suffix_1
string ls_Delivery_suffix_2
string ls_Delivery_zip_code
string ls_Display_name
string ls_Fax
string ls_First_name
string ls_Grace_period
string ls_Due_in_days
string ls_Group_id
string ls_Id
string ls_Info_1
string ls_Info_2
string ls_Internet
string ls_Login_id
string ls_Mobile
string ls_Note
string ls_V_number
integer li_Payment_options
integer li_Personal
string ls_Phone_1
string ls_Phone_2
string ls_Postbox
string ls_Postbox_city
string ls_Postbox_state
string ls_Postbox_country
string ls_Postbox_zip_code
string ls_Sale_price_level
integer li_Salutation
string ls_Sepa_agreement
string ls_Sepa_agreement_date
string ls_Sepa_mandate_reference
string ls_Since_date
string ls_Street
string ls_Suffix_1
string ls_Suffix_2
string ls_Tax_number
string ls_Court
string ls_Court_registry_number
string ls_Tax_options
string ls_Title
string ls_Archived
string ls_Vat_identifier
string ls_Zip_code
string ls_Document_pdf_type
string ls_Buyer_reference
string ls_Foreign_supplier_number
integer i
integer li_Count_i

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

loo_Http = create oleobject
// Use "Chilkat_9_5_0.Http" for versions of Chilkat < 10.0.0
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")
if li_rc < 0 then
    destroy loo_Http
    MessageBox("Error","Connecting to COM object failed")
    return
end if

loo_Http.SetRequestHeader("Authorization","{{apiKey}}")
loo_Http.SetRequestHeader("Accept","application/json")

loo_SbResponseBody = create oleobject
// Use "Chilkat_9_5_0.StringBuilder" for versions of Chilkat < 10.0.0
li_rc = loo_SbResponseBody.ConnectToNewObject("Chilkat.StringBuilder")

li_Success = loo_Http.QuickGetSb("https://api.easybill.de/rest/v1/customers/:id",loo_SbResponseBody)
if li_Success = 0 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    destroy loo_SbResponseBody
    return
end if

loo_JResp = create oleobject
// Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
li_rc = loo_JResp.ConnectToNewObject("Chilkat.JsonObject")

loo_JResp.LoadSb(loo_SbResponseBody)
loo_JResp.EmitCompact = 0

Write-Debug "Response Body:"
Write-Debug loo_JResp.Emit()

li_RespStatusCode = loo_Http.LastStatus
Write-Debug "Response Status Code = " + string(li_RespStatusCode)
if li_RespStatusCode >= 400 then
    Write-Debug "Response Header:"
    Write-Debug loo_Http.LastHeader
    Write-Debug "Failed."
    destroy loo_Http
    destroy loo_SbResponseBody
    destroy loo_JResp
    return
end if

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

// {
//   "last_name": "<string>",
//   "company_name": "<string>",
//   "acquire_options": 2,
//   "additional_groups_ids": [
//     "<integer>",
//     "<integer>"
//   ],
//   "bank_account": "<string>",
//   "bank_account_owner": "<string>",
//   "bank_bic": "<string>",
//   "bank_code": "<string>",
//   "bank_iban": "<string>",
//   "bank_name": "<string>",
//   "birth_date": "<date>",
//   "cash_allowance": "<float>",
//   "cash_allowance_days": 7,
//   "cash_discount": "<float>",
//   "cash_discount_type": "AMOUNT",
//   "city": "<string>",
//   "state": "<string>",
//   "country": "<string>",
//   "created_at": "<date>",
//   "updated_at": "<string>",
//   "delivery_title": "<string>",
//   "delivery_city": "<string>",
//   "delivery_state": "<string>",
//   "delivery_company_name": "<string>",
//   "delivery_country": "<string>",
//   "delivery_first_name": "<string>",
//   "delivery_last_name": "<string>",
//   "delivery_personal": "<boolean>",
//   "delivery_salutation": 0,
//   "delivery_street": "<string>",
//   "delivery_suffix_1": "<string>",
//   "delivery_suffix_2": "<string>",
//   "delivery_zip_code": "<string>",
//   "display_name": "<string>",
//   "emails": [
//     "<string>",
//     "<string>"
//   ],
//   "fax": "<string>",
//   "first_name": "<string>",
//   "grace_period": "<integer>",
//   "due_in_days": "<integer>",
//   "group_id": "<integer>",
//   "id": "<long>",
//   "info_1": "<string>",
//   "info_2": "<string>",
//   "internet": "<string>",
//   "login_id": "<long>",
//   "mobile": "<string>",
//   "note": "<string>",
//   "number": "<string>",
//   "payment_options": 5,
//   "personal": false,
//   "phone_1": "<string>",
//   "phone_2": "<string>",
//   "postbox": "<string>",
//   "postbox_city": "<string>",
//   "postbox_state": "<string>",
//   "postbox_country": "<string>",
//   "postbox_zip_code": "<string>",
//   "sale_price_level": "SALEPRICE10",
//   "salutation": 0,
//   "sepa_agreement": "BASIC",
//   "sepa_agreement_date": "<date>",
//   "sepa_mandate_reference": "<string>",
//   "since_date": "<date>",
//   "street": "<string>",
//   "suffix_1": "<string>",
//   "suffix_2": "<string>",
//   "tax_number": "<string>",
//   "court": "<string>",
//   "court_registry_number": "<string>",
//   "tax_options": "nStbUstID",
//   "title": "<string>",
//   "archived": "<boolean>",
//   "vat_identifier": "<string>",
//   "zip_code": "<string>",
//   "document_pdf_type": "default",
//   "buyer_reference": "<string>",
//   "foreign_supplier_number": "<string>"
// }

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

ls_Last_name = loo_JResp.StringOf("last_name")
ls_Company_name = loo_JResp.StringOf("company_name")
li_Acquire_options = loo_JResp.IntOf("acquire_options")
ls_Bank_account = loo_JResp.StringOf("bank_account")
ls_Bank_account_owner = loo_JResp.StringOf("bank_account_owner")
ls_Bank_bic = loo_JResp.StringOf("bank_bic")
ls_Bank_code = loo_JResp.StringOf("bank_code")
ls_Bank_iban = loo_JResp.StringOf("bank_iban")
ls_Bank_name = loo_JResp.StringOf("bank_name")
ls_Birth_date = loo_JResp.StringOf("birth_date")
ls_Cash_allowance = loo_JResp.StringOf("cash_allowance")
li_Cash_allowance_days = loo_JResp.IntOf("cash_allowance_days")
ls_Cash_discount = loo_JResp.StringOf("cash_discount")
ls_Cash_discount_type = loo_JResp.StringOf("cash_discount_type")
ls_City = loo_JResp.StringOf("city")
ls_State = loo_JResp.StringOf("state")
ls_Country = loo_JResp.StringOf("country")
ls_Created_at = loo_JResp.StringOf("created_at")
ls_Updated_at = loo_JResp.StringOf("updated_at")
ls_Delivery_title = loo_JResp.StringOf("delivery_title")
ls_Delivery_city = loo_JResp.StringOf("delivery_city")
ls_Delivery_state = loo_JResp.StringOf("delivery_state")
ls_Delivery_company_name = loo_JResp.StringOf("delivery_company_name")
ls_Delivery_country = loo_JResp.StringOf("delivery_country")
ls_Delivery_first_name = loo_JResp.StringOf("delivery_first_name")
ls_Delivery_last_name = loo_JResp.StringOf("delivery_last_name")
ls_Delivery_personal = loo_JResp.StringOf("delivery_personal")
li_Delivery_salutation = loo_JResp.IntOf("delivery_salutation")
ls_Delivery_street = loo_JResp.StringOf("delivery_street")
ls_Delivery_suffix_1 = loo_JResp.StringOf("delivery_suffix_1")
ls_Delivery_suffix_2 = loo_JResp.StringOf("delivery_suffix_2")
ls_Delivery_zip_code = loo_JResp.StringOf("delivery_zip_code")
ls_Display_name = loo_JResp.StringOf("display_name")
ls_Fax = loo_JResp.StringOf("fax")
ls_First_name = loo_JResp.StringOf("first_name")
ls_Grace_period = loo_JResp.StringOf("grace_period")
ls_Due_in_days = loo_JResp.StringOf("due_in_days")
ls_Group_id = loo_JResp.StringOf("group_id")
ls_Id = loo_JResp.StringOf("id")
ls_Info_1 = loo_JResp.StringOf("info_1")
ls_Info_2 = loo_JResp.StringOf("info_2")
ls_Internet = loo_JResp.StringOf("internet")
ls_Login_id = loo_JResp.StringOf("login_id")
ls_Mobile = loo_JResp.StringOf("mobile")
ls_Note = loo_JResp.StringOf("note")
ls_V_number = loo_JResp.StringOf("number")
li_Payment_options = loo_JResp.IntOf("payment_options")
li_Personal = loo_JResp.BoolOf("personal")
ls_Phone_1 = loo_JResp.StringOf("phone_1")
ls_Phone_2 = loo_JResp.StringOf("phone_2")
ls_Postbox = loo_JResp.StringOf("postbox")
ls_Postbox_city = loo_JResp.StringOf("postbox_city")
ls_Postbox_state = loo_JResp.StringOf("postbox_state")
ls_Postbox_country = loo_JResp.StringOf("postbox_country")
ls_Postbox_zip_code = loo_JResp.StringOf("postbox_zip_code")
ls_Sale_price_level = loo_JResp.StringOf("sale_price_level")
li_Salutation = loo_JResp.IntOf("salutation")
ls_Sepa_agreement = loo_JResp.StringOf("sepa_agreement")
ls_Sepa_agreement_date = loo_JResp.StringOf("sepa_agreement_date")
ls_Sepa_mandate_reference = loo_JResp.StringOf("sepa_mandate_reference")
ls_Since_date = loo_JResp.StringOf("since_date")
ls_Street = loo_JResp.StringOf("street")
ls_Suffix_1 = loo_JResp.StringOf("suffix_1")
ls_Suffix_2 = loo_JResp.StringOf("suffix_2")
ls_Tax_number = loo_JResp.StringOf("tax_number")
ls_Court = loo_JResp.StringOf("court")
ls_Court_registry_number = loo_JResp.StringOf("court_registry_number")
ls_Tax_options = loo_JResp.StringOf("tax_options")
ls_Title = loo_JResp.StringOf("title")
ls_Archived = loo_JResp.StringOf("archived")
ls_Vat_identifier = loo_JResp.StringOf("vat_identifier")
ls_Zip_code = loo_JResp.StringOf("zip_code")
ls_Document_pdf_type = loo_JResp.StringOf("document_pdf_type")
ls_Buyer_reference = loo_JResp.StringOf("buyer_reference")
ls_Foreign_supplier_number = loo_JResp.StringOf("foreign_supplier_number")
i = 0
li_Count_i = loo_JResp.SizeOfArray("additional_groups_ids")
do while i < li_Count_i
    loo_JResp.I = i
    ls_StrVal = loo_JResp.StringOf("additional_groups_ids[i]")
    i = i + 1
loop
i = 0
li_Count_i = loo_JResp.SizeOfArray("emails")
do while i < li_Count_i
    loo_JResp.I = i
    ls_StrVal = loo_JResp.StringOf("emails[i]")
    i = i + 1
loop


destroy loo_Http
destroy loo_SbResponseBody
destroy loo_JResp

Curl Command

curl -X GET
	-H "Authorization: {{apiKey}}"
	-H "Accept: application/json"
https://api.easybill.de/rest/v1/customers/:id

Postman Collection Item JSON

{
  "name": "Fetch customer",
  "request": {
    "method": "GET",
    "header": [
      {
        "key": "Accept",
        "value": "application/json"
      }
    ],
    "url": {
      "raw": "{{baseUrl}}/customers/:id",
      "host": [
        "{{baseUrl}}"
      ],
      "path": [
        "customers",
        ":id"
      ],
      "variable": [
        {
          "key": "id",
          "value": "<long>",
          "description": "(Required) ID of customer that needs to be fetched"
        }
      ]
    }
  },
  "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}}/customers/:id",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "customers",
            ":id"
          ],
          "variable": [
            {
              "key": "id"
            }
          ]
        }
      },
      "status": "OK",
      "code": 200,
      "_postman_previewlanguage": "json",
      "header": [
        {
          "key": "Content-Type",
          "value": "application/json"
        }
      ],
      "cookie": [
      ],
      "body": "{\n  \"last_name\": \"<string>\",\n  \"company_name\": \"<string>\",\n  \"acquire_options\": 2,\n  \"additional_groups_ids\": [\n    \"<integer>\",\n    \"<integer>\"\n  ],\n  \"bank_account\": \"<string>\",\n  \"bank_account_owner\": \"<string>\",\n  \"bank_bic\": \"<string>\",\n  \"bank_code\": \"<string>\",\n  \"bank_iban\": \"<string>\",\n  \"bank_name\": \"<string>\",\n  \"birth_date\": \"<date>\",\n  \"cash_allowance\": \"<float>\",\n  \"cash_allowance_days\": 7,\n  \"cash_discount\": \"<float>\",\n  \"cash_discount_type\": \"AMOUNT\",\n  \"city\": \"<string>\",\n  \"state\": \"<string>\",\n  \"country\": \"<string>\",\n  \"created_at\": \"<date>\",\n  \"updated_at\": \"<string>\",\n  \"delivery_title\": \"<string>\",\n  \"delivery_city\": \"<string>\",\n  \"delivery_state\": \"<string>\",\n  \"delivery_company_name\": \"<string>\",\n  \"delivery_country\": \"<string>\",\n  \"delivery_first_name\": \"<string>\",\n  \"delivery_last_name\": \"<string>\",\n  \"delivery_personal\": \"<boolean>\",\n  \"delivery_salutation\": 0,\n  \"delivery_street\": \"<string>\",\n  \"delivery_suffix_1\": \"<string>\",\n  \"delivery_suffix_2\": \"<string>\",\n  \"delivery_zip_code\": \"<string>\",\n  \"display_name\": \"<string>\",\n  \"emails\": [\n    \"<string>\",\n    \"<string>\"\n  ],\n  \"fax\": \"<string>\",\n  \"first_name\": \"<string>\",\n  \"grace_period\": \"<integer>\",\n  \"due_in_days\": \"<integer>\",\n  \"group_id\": \"<integer>\",\n  \"id\": \"<long>\",\n  \"info_1\": \"<string>\",\n  \"info_2\": \"<string>\",\n  \"internet\": \"<string>\",\n  \"login_id\": \"<long>\",\n  \"mobile\": \"<string>\",\n  \"note\": \"<string>\",\n  \"number\": \"<string>\",\n  \"payment_options\": 5,\n  \"personal\": false,\n  \"phone_1\": \"<string>\",\n  \"phone_2\": \"<string>\",\n  \"postbox\": \"<string>\",\n  \"postbox_city\": \"<string>\",\n  \"postbox_state\": \"<string>\",\n  \"postbox_country\": \"<string>\",\n  \"postbox_zip_code\": \"<string>\",\n  \"sale_price_level\": \"SALEPRICE10\",\n  \"salutation\": 0,\n  \"sepa_agreement\": \"BASIC\",\n  \"sepa_agreement_date\": \"<date>\",\n  \"sepa_mandate_reference\": \"<string>\",\n  \"since_date\": \"<date>\",\n  \"street\": \"<string>\",\n  \"suffix_1\": \"<string>\",\n  \"suffix_2\": \"<string>\",\n  \"tax_number\": \"<string>\",\n  \"court\": \"<string>\",\n  \"court_registry_number\": \"<string>\",\n  \"tax_options\": \"nStbUstID\",\n  \"title\": \"<string>\",\n  \"archived\": \"<boolean>\",\n  \"vat_identifier\": \"<string>\",\n  \"zip_code\": \"<string>\",\n  \"document_pdf_type\": \"default\",\n  \"buyer_reference\": \"<string>\",\n  \"foreign_supplier_number\": \"<string>\"\n}"
    },
    {
      "name": "Not found",
      "originalRequest": {
        "method": "GET",
        "header": [
          {
            "description": "Added as a part of security scheme: apikey",
            "key": "Authorization",
            "value": "<API Key>"
          }
        ],
        "url": {
          "raw": "{{baseUrl}}/customers/:id",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "customers",
            ":id"
          ],
          "variable": [
            {
              "key": "id"
            }
          ]
        }
      },
      "status": "Not Found",
      "code": 404,
      "_postman_previewlanguage": "text",
      "header": [
      ],
      "cookie": [
      ],
      "body": ""
    },
    {
      "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}}/customers/:id",
          "host": [
            "{{baseUrl}}"
          ],
          "path": [
            "customers",
            ":id"
          ],
          "variable": [
            {
              "key": "id"
            }
          ]
        }
      },
      "status": "Too Many Requests",
      "code": 429,
      "_postman_previewlanguage": "text",
      "header": [
      ],
      "cookie": [
      ],
      "body": ""
    }
  ]
}