Back to Collection Items
' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.
Dim http As New ChilkatHttp
Dim success As Long
http.SetRequestHeader "Authorization","{{apiKey}}"
http.SetRequestHeader "Accept","application/json"
Dim sbResponseBody As New ChilkatStringBuilder
success = http.QuickGetSb("https://api.easybill.de/rest/v1/documents/:id",sbResponseBody)
If (success = 0) Then
Debug.Print http.LastErrorText
Exit Sub
End If
Dim jResp As New ChilkatJsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = 0
Debug.Print "Response Body:"
Debug.Print jResp.Emit()
Dim respStatusCode As Long
respStatusCode = http.LastStatus
Debug.Print "Response Status Code = " & respStatusCode
If (respStatusCode >= 400) Then
Debug.Print "Response Header:"
Debug.Print http.LastHeader
Debug.Print "Failed."
Exit Sub
End If
' Sample JSON response:
' (Sample code for parsing the JSON response is shown below)
' {
' "address": {
' "salutation": "<integer>",
' "personal": "<boolean>",
' "title": "<string>",
' "first_name": "<string>",
' "last_name": "<string>",
' "suffix_1": "<string>",
' "suffix_2": "<string>",
' "company_name": "<string>",
' "street": "<string>",
' "zip_code": "<string>",
' "city": "<string>",
' "state": "<string>",
' "country": "<string>"
' },
' "attachment_ids": [
' "<integer>",
' "<integer>"
' ],
' "label_address": {
' "salutation": "<integer>",
' "personal": "<boolean>",
' "title": "<string>",
' "first_name": "<string>",
' "last_name": "<string>",
' "suffix_1": "<string>",
' "suffix_2": "<string>",
' "company_name": "<string>",
' "street": "<string>",
' "zip_code": "<string>",
' "city": "<string>",
' "state": "<string>",
' "country": "<string>"
' },
' "amount": "<integer>",
' "amount_net": "<integer>",
' "bank_debit_form": null,
' "billing_country": "<string>",
' "calc_vat_from": 0,
' "cancel_id": "<long>",
' "cash_allowance": null,
' "cash_allowance_days": null,
' "cash_allowance_text": null,
' "contact_id": null,
' "contact_label": "",
' "contact_text": "",
' "created_at": "<dateTime>",
' "currency": "EUR",
' "customer_id": null,
' "customer_snapshot": {
' "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": 1,
' "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": "SALEPRICE6",
' "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": "nStbIm",
' "title": "<string>",
' "archived": "<boolean>",
' "vat_identifier": "<string>",
' "zip_code": "<string>",
' "document_pdf_type": "default",
' "buyer_reference": "<string>",
' "foreign_supplier_number": "<string>"
' },
' "discount": null,
' "discount_type": null,
' "document_date": "<date>",
' "due_date": "<date>",
' "edited_at": "<dateTime>",
' "external_id": null,
' "replica_url": null,
' "grace_period": "<integer>",
' "due_in_days": "<integer>",
' "id": "<long>",
' "is_acceptable_on_public_domain": false,
' "is_archive": false,
' "is_draft": "<boolean>",
' "is_replica": false,
' "is_oss": false,
' "item_notes": [
' "<string>",
' "<string>"
' ],
' "items": [
' {
' "number": null,
' "description": null,
' "document_note": "<string>",
' "quantity": 1,
' "quantity_str": "<string>",
' "unit": null,
' "type": "POSITION",
' "position": "<integer>",
' "single_price_net": null,
' "single_price_gross": "<float>",
' "vat_percent": 0,
' "discount": null,
' "discount_type": null,
' "position_id": null,
' "total_price_net": "<float>",
' "total_price_gross": "<float>",
' "total_vat": "<float>",
' "serial_number_id": "<string>",
' "serial_number": "<string>",
' "booking_account": null,
' "export_cost_1": null,
' "export_cost_2": null,
' "cost_price_net": null,
' "cost_price_total": "<float>",
' "cost_price_charge": "<float>",
' "cost_price_charge_type": "PERCENT",
' "itemType": "UNDEFINED",
' "id": "<long>"
' },
' {
' "number": null,
' "description": null,
' "document_note": "<string>",
' "quantity": 1,
' "quantity_str": "<string>",
' "unit": null,
' "type": "POSITION",
' "position": "<integer>",
' "single_price_net": null,
' "single_price_gross": "<float>",
' "vat_percent": 0,
' "discount": null,
' "discount_type": null,
' "position_id": null,
' "total_price_net": "<float>",
' "total_price_gross": "<float>",
' "total_vat": "<float>",
' "serial_number_id": "<string>",
' "serial_number": "<string>",
' "booking_account": null,
' "export_cost_1": null,
' "export_cost_2": null,
' "cost_price_net": null,
' "cost_price_total": "<float>",
' "cost_price_charge": "<float>",
' "cost_price_charge_type": "PERCENT",
' "itemType": "UNDEFINED",
' "id": "<long>"
' }
' ],
' "last_postbox_id": "<long>",
' "login_id": "<long>",
' "number": null,
' "order_number": "",
' "buyer_reference": "",
' "paid_amount": "<integer>",
' "paid_at": "<date>",
' "pdf_pages": "<integer>",
' "pdf_template": "<string>",
' "project_id": null,
' "recurring_options": {
' "next_date": "<date>",
' "frequency": "MONTHLY",
' "frequency_special": null,
' "interval": 1,
' "end_date_or_count": null,
' "status": "WAITING",
' "as_draft": false,
' "is_notify": false,
' "send_as": null,
' "is_sign": false,
' "is_paid": false,
' "paid_date_option": "created_date",
' "is_sepa": false,
' "sepa_local_instrument": null,
' "sepa_sequence_type": null,
' "sepa_reference": null,
' "sepa_remittance_information": null,
' "target_type": "INVOICE"
' },
' "ref_id": null,
' "root_id": null,
' "service_date": {
' "type": "SERVICE",
' "date": "<date>",
' "date_from": "<date>",
' "date_to": "<date>",
' "text": null
' },
' "shipping_country": null,
' "status": null,
' "text": "<string>",
' "text_prefix": "<string>",
' "text_tax": null,
' "title": null,
' "type": "INVOICE",
' "use_shipping_address": false,
' "vat_country": null,
' "vat_id": "",
' "fulfillment_country": null,
' "vat_option": null,
' "file_format_config": [
' {
' "type": "xrechnung2_2_xml"
' },
' {
' "type": "xrechnung3_0_xml"
' }
' ]
' }
' Sample code for parsing the JSON response...
' Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
Dim Date_from As New DtObj
Dim Date_to As New DtObj
Dim strVal As String
Dim description As String
Dim document_note As String
Dim quantity As Long
Dim quantity_str As String
Dim unit As String
Dim position As String
Dim single_price_net As String
Dim single_price_gross As String
Dim vat_percent As Long
Dim position_id As String
Dim total_price_net As String
Dim total_price_gross As String
Dim total_vat As String
Dim serial_number_id As String
Dim serial_number As String
Dim booking_account As String
Dim export_cost_1 As String
Dim export_cost_2 As String
Dim cost_price_net As String
Dim cost_price_total As String
Dim cost_price_charge As String
Dim cost_price_charge_type As String
Dim itemType As String
Dim Salutation As String
Salutation = jResp.StringOf("address.salutation")
Dim Personal As String
Personal = jResp.StringOf("address.personal")
Dim Title As String
Title = jResp.StringOf("address.title")
Dim First_name As String
First_name = jResp.StringOf("address.first_name")
Dim Last_name As String
Last_name = jResp.StringOf("address.last_name")
Dim Suffix_1 As String
Suffix_1 = jResp.StringOf("address.suffix_1")
Dim Suffix_2 As String
Suffix_2 = jResp.StringOf("address.suffix_2")
Dim Company_name As String
Company_name = jResp.StringOf("address.company_name")
Dim Street As String
Street = jResp.StringOf("address.street")
Dim Zip_code As String
Zip_code = jResp.StringOf("address.zip_code")
Dim City As String
City = jResp.StringOf("address.city")
Dim State As String
State = jResp.StringOf("address.state")
Dim Country As String
Country = jResp.StringOf("address.country")
Dim label_addressSalutation As String
label_addressSalutation = jResp.StringOf("label_address.salutation")
Dim label_addressPersonal As String
label_addressPersonal = jResp.StringOf("label_address.personal")
Dim label_addressTitle As String
label_addressTitle = jResp.StringOf("label_address.title")
Dim label_addressFirst_name As String
label_addressFirst_name = jResp.StringOf("label_address.first_name")
Dim label_addressLast_name As String
label_addressLast_name = jResp.StringOf("label_address.last_name")
Dim label_addressSuffix_1 As String
label_addressSuffix_1 = jResp.StringOf("label_address.suffix_1")
Dim label_addressSuffix_2 As String
label_addressSuffix_2 = jResp.StringOf("label_address.suffix_2")
Dim label_addressCompany_name As String
label_addressCompany_name = jResp.StringOf("label_address.company_name")
Dim label_addressStreet As String
label_addressStreet = jResp.StringOf("label_address.street")
Dim label_addressZip_code As String
label_addressZip_code = jResp.StringOf("label_address.zip_code")
Dim label_addressCity As String
label_addressCity = jResp.StringOf("label_address.city")
Dim label_addressState As String
label_addressState = jResp.StringOf("label_address.state")
Dim label_addressCountry As String
label_addressCountry = jResp.StringOf("label_address.country")
Dim amount As String
amount = jResp.StringOf("amount")
Dim amount_net As String
amount_net = jResp.StringOf("amount_net")
Dim bank_debit_form As String
bank_debit_form = jResp.StringOf("bank_debit_form")
Dim billing_country As String
billing_country = jResp.StringOf("billing_country")
Dim calc_vat_from As Long
calc_vat_from = jResp.IntOf("calc_vat_from")
Dim cancel_id As String
cancel_id = jResp.StringOf("cancel_id")
Dim cash_allowance As String
cash_allowance = jResp.StringOf("cash_allowance")
Dim cash_allowance_days As String
cash_allowance_days = jResp.StringOf("cash_allowance_days")
Dim cash_allowance_text As String
cash_allowance_text = jResp.StringOf("cash_allowance_text")
Dim contact_id As String
contact_id = jResp.StringOf("contact_id")
Dim contact_label As String
contact_label = jResp.StringOf("contact_label")
Dim contact_text As String
contact_text = jResp.StringOf("contact_text")
Dim created_at As String
created_at = jResp.StringOf("created_at")
Dim v_currency As String
v_currency = jResp.StringOf("currency")
Dim customer_id As String
customer_id = jResp.StringOf("customer_id")
Dim customer_snapshotLast_name As String
customer_snapshotLast_name = jResp.StringOf("customer_snapshot.last_name")
Dim customer_snapshotCompany_name As String
customer_snapshotCompany_name = jResp.StringOf("customer_snapshot.company_name")
Dim Acquire_options As Long
Acquire_options = jResp.IntOf("customer_snapshot.acquire_options")
Dim Bank_account As String
Bank_account = jResp.StringOf("customer_snapshot.bank_account")
Dim Bank_account_owner As String
Bank_account_owner = jResp.StringOf("customer_snapshot.bank_account_owner")
Dim Bank_bic As String
Bank_bic = jResp.StringOf("customer_snapshot.bank_bic")
Dim Bank_code As String
Bank_code = jResp.StringOf("customer_snapshot.bank_code")
Dim Bank_iban As String
Bank_iban = jResp.StringOf("customer_snapshot.bank_iban")
Dim Bank_name As String
Bank_name = jResp.StringOf("customer_snapshot.bank_name")
Dim Birth_date As String
Birth_date = jResp.StringOf("customer_snapshot.birth_date")
Dim Cash_allowance As String
Cash_allowance = jResp.StringOf("customer_snapshot.cash_allowance")
Dim Cash_allowance_days As Long
Cash_allowance_days = jResp.IntOf("customer_snapshot.cash_allowance_days")
Dim Cash_discount As String
Cash_discount = jResp.StringOf("customer_snapshot.cash_discount")
Dim Cash_discount_type As String
Cash_discount_type = jResp.StringOf("customer_snapshot.cash_discount_type")
Dim customer_snapshotCity As String
customer_snapshotCity = jResp.StringOf("customer_snapshot.city")
Dim customer_snapshotState As String
customer_snapshotState = jResp.StringOf("customer_snapshot.state")
Dim customer_snapshotCountry As String
customer_snapshotCountry = jResp.StringOf("customer_snapshot.country")
Dim Created_at As String
Created_at = jResp.StringOf("customer_snapshot.created_at")
Dim Updated_at As String
Updated_at = jResp.StringOf("customer_snapshot.updated_at")
Dim Delivery_title As String
Delivery_title = jResp.StringOf("customer_snapshot.delivery_title")
Dim Delivery_city As String
Delivery_city = jResp.StringOf("customer_snapshot.delivery_city")
Dim Delivery_state As String
Delivery_state = jResp.StringOf("customer_snapshot.delivery_state")
Dim Delivery_company_name As String
Delivery_company_name = jResp.StringOf("customer_snapshot.delivery_company_name")
Dim Delivery_country As String
Delivery_country = jResp.StringOf("customer_snapshot.delivery_country")
Dim Delivery_first_name As String
Delivery_first_name = jResp.StringOf("customer_snapshot.delivery_first_name")
Dim Delivery_last_name As String
Delivery_last_name = jResp.StringOf("customer_snapshot.delivery_last_name")
Dim Delivery_personal As String
Delivery_personal = jResp.StringOf("customer_snapshot.delivery_personal")
Dim Delivery_salutation As Long
Delivery_salutation = jResp.IntOf("customer_snapshot.delivery_salutation")
Dim Delivery_street As String
Delivery_street = jResp.StringOf("customer_snapshot.delivery_street")
Dim Delivery_suffix_1 As String
Delivery_suffix_1 = jResp.StringOf("customer_snapshot.delivery_suffix_1")
Dim Delivery_suffix_2 As String
Delivery_suffix_2 = jResp.StringOf("customer_snapshot.delivery_suffix_2")
Dim Delivery_zip_code As String
Delivery_zip_code = jResp.StringOf("customer_snapshot.delivery_zip_code")
Dim Display_name As String
Display_name = jResp.StringOf("customer_snapshot.display_name")
Dim Fax As String
Fax = jResp.StringOf("customer_snapshot.fax")
Dim customer_snapshotFirst_name As String
customer_snapshotFirst_name = jResp.StringOf("customer_snapshot.first_name")
Dim Grace_period As String
Grace_period = jResp.StringOf("customer_snapshot.grace_period")
Dim Due_in_days As String
Due_in_days = jResp.StringOf("customer_snapshot.due_in_days")
Dim Group_id As String
Group_id = jResp.StringOf("customer_snapshot.group_id")
Dim Id As String
Id = jResp.StringOf("customer_snapshot.id")
Dim Info_1 As String
Info_1 = jResp.StringOf("customer_snapshot.info_1")
Dim Info_2 As String
Info_2 = jResp.StringOf("customer_snapshot.info_2")
Dim Internet As String
Internet = jResp.StringOf("customer_snapshot.internet")
Dim Login_id As String
Login_id = jResp.StringOf("customer_snapshot.login_id")
Dim Mobile As String
Mobile = jResp.StringOf("customer_snapshot.mobile")
Dim Note As String
Note = jResp.StringOf("customer_snapshot.note")
Dim v_Number As String
v_Number = jResp.StringOf("customer_snapshot.number")
Dim Payment_options As Long
Payment_options = jResp.IntOf("customer_snapshot.payment_options")
Dim customer_snapshotPersonal As Long
customer_snapshotPersonal = jResp.BoolOf("customer_snapshot.personal")
Dim Phone_1 As String
Phone_1 = jResp.StringOf("customer_snapshot.phone_1")
Dim Phone_2 As String
Phone_2 = jResp.StringOf("customer_snapshot.phone_2")
Dim Postbox As String
Postbox = jResp.StringOf("customer_snapshot.postbox")
Dim Postbox_city As String
Postbox_city = jResp.StringOf("customer_snapshot.postbox_city")
Dim Postbox_state As String
Postbox_state = jResp.StringOf("customer_snapshot.postbox_state")
Dim Postbox_country As String
Postbox_country = jResp.StringOf("customer_snapshot.postbox_country")
Dim Postbox_zip_code As String
Postbox_zip_code = jResp.StringOf("customer_snapshot.postbox_zip_code")
Dim Sale_price_level As String
Sale_price_level = jResp.StringOf("customer_snapshot.sale_price_level")
Dim customer_snapshotSalutation As Long
customer_snapshotSalutation = jResp.IntOf("customer_snapshot.salutation")
Dim Sepa_agreement As String
Sepa_agreement = jResp.StringOf("customer_snapshot.sepa_agreement")
Dim Sepa_agreement_date As String
Sepa_agreement_date = jResp.StringOf("customer_snapshot.sepa_agreement_date")
Dim Sepa_mandate_reference As String
Sepa_mandate_reference = jResp.StringOf("customer_snapshot.sepa_mandate_reference")
Dim Since_date As String
Since_date = jResp.StringOf("customer_snapshot.since_date")
Dim customer_snapshotStreet As String
customer_snapshotStreet = jResp.StringOf("customer_snapshot.street")
Dim customer_snapshotSuffix_1 As String
customer_snapshotSuffix_1 = jResp.StringOf("customer_snapshot.suffix_1")
Dim customer_snapshotSuffix_2 As String
customer_snapshotSuffix_2 = jResp.StringOf("customer_snapshot.suffix_2")
Dim Tax_number As String
Tax_number = jResp.StringOf("customer_snapshot.tax_number")
Dim Court As String
Court = jResp.StringOf("customer_snapshot.court")
Dim Court_registry_number As String
Court_registry_number = jResp.StringOf("customer_snapshot.court_registry_number")
Dim Tax_options As String
Tax_options = jResp.StringOf("customer_snapshot.tax_options")
Dim customer_snapshotTitle As String
customer_snapshotTitle = jResp.StringOf("customer_snapshot.title")
Dim Archived As String
Archived = jResp.StringOf("customer_snapshot.archived")
Dim Vat_identifier As String
Vat_identifier = jResp.StringOf("customer_snapshot.vat_identifier")
Dim customer_snapshotZip_code As String
customer_snapshotZip_code = jResp.StringOf("customer_snapshot.zip_code")
Dim Document_pdf_type As String
Document_pdf_type = jResp.StringOf("customer_snapshot.document_pdf_type")
Dim Buyer_reference As String
Buyer_reference = jResp.StringOf("customer_snapshot.buyer_reference")
Dim Foreign_supplier_number As String
Foreign_supplier_number = jResp.StringOf("customer_snapshot.foreign_supplier_number")
Dim discount As String
discount = jResp.StringOf("discount")
Dim discount_type As String
discount_type = jResp.StringOf("discount_type")
Dim document_date As String
document_date = jResp.StringOf("document_date")
Dim due_date As String
due_date = jResp.StringOf("due_date")
Dim edited_at As String
edited_at = jResp.StringOf("edited_at")
Dim external_id As String
external_id = jResp.StringOf("external_id")
Dim replica_url As String
replica_url = jResp.StringOf("replica_url")
Dim grace_period As String
grace_period = jResp.StringOf("grace_period")
Dim due_in_days As String
due_in_days = jResp.StringOf("due_in_days")
Dim id As String
id = jResp.StringOf("id")
Dim is_acceptable_on_public_domain As Long
is_acceptable_on_public_domain = jResp.BoolOf("is_acceptable_on_public_domain")
Dim is_archive As Long
is_archive = jResp.BoolOf("is_archive")
Dim is_draft As String
is_draft = jResp.StringOf("is_draft")
Dim is_replica As Long
is_replica = jResp.BoolOf("is_replica")
Dim is_oss As Long
is_oss = jResp.BoolOf("is_oss")
Dim last_postbox_id As String
last_postbox_id = jResp.StringOf("last_postbox_id")
Dim login_id As String
login_id = jResp.StringOf("login_id")
Dim v_number As String
v_number = jResp.StringOf("number")
Dim order_number As String
order_number = jResp.StringOf("order_number")
Dim buyer_reference As String
buyer_reference = jResp.StringOf("buyer_reference")
Dim paid_amount As String
paid_amount = jResp.StringOf("paid_amount")
Dim paid_at As String
paid_at = jResp.StringOf("paid_at")
Dim pdf_pages As String
pdf_pages = jResp.StringOf("pdf_pages")
Dim pdf_template As String
pdf_template = jResp.StringOf("pdf_template")
Dim project_id As String
project_id = jResp.StringOf("project_id")
Dim Next_date As String
Next_date = jResp.StringOf("recurring_options.next_date")
Dim Frequency As String
Frequency = jResp.StringOf("recurring_options.frequency")
Dim Frequency_special As String
Frequency_special = jResp.StringOf("recurring_options.frequency_special")
Dim Interval As Long
Interval = jResp.IntOf("recurring_options.interval")
Dim End_date_or_count As String
End_date_or_count = jResp.StringOf("recurring_options.end_date_or_count")
Dim Status As String
Status = jResp.StringOf("recurring_options.status")
Dim As_draft As Long
As_draft = jResp.BoolOf("recurring_options.as_draft")
Dim Is_notify As Long
Is_notify = jResp.BoolOf("recurring_options.is_notify")
Dim Send_as As String
Send_as = jResp.StringOf("recurring_options.send_as")
Dim Is_sign As Long
Is_sign = jResp.BoolOf("recurring_options.is_sign")
Dim Is_paid As Long
Is_paid = jResp.BoolOf("recurring_options.is_paid")
Dim Paid_date_option As String
Paid_date_option = jResp.StringOf("recurring_options.paid_date_option")
Dim Is_sepa As Long
Is_sepa = jResp.BoolOf("recurring_options.is_sepa")
Dim Sepa_local_instrument As String
Sepa_local_instrument = jResp.StringOf("recurring_options.sepa_local_instrument")
Dim Sepa_sequence_type As String
Sepa_sequence_type = jResp.StringOf("recurring_options.sepa_sequence_type")
Dim Sepa_reference As String
Sepa_reference = jResp.StringOf("recurring_options.sepa_reference")
Dim Sepa_remittance_information As String
Sepa_remittance_information = jResp.StringOf("recurring_options.sepa_remittance_information")
Dim Target_type As String
Target_type = jResp.StringOf("recurring_options.target_type")
Dim ref_id As String
ref_id = jResp.StringOf("ref_id")
Dim root_id As String
root_id = jResp.StringOf("root_id")
Dim v_Type As String
v_Type = jResp.StringOf("service_date.type")
Dim Date As String
Date = jResp.StringOf("service_date.date")
success = jResp.DtOf("service_date.date_from",0,Date_from)
success = jResp.DtOf("service_date.date_to",0,Date_to)
Dim Text As String
Text = jResp.StringOf("service_date.text")
Dim shipping_country As String
shipping_country = jResp.StringOf("shipping_country")
Dim status As String
status = jResp.StringOf("status")
Dim text As String
text = jResp.StringOf("text")
Dim text_prefix As String
text_prefix = jResp.StringOf("text_prefix")
Dim text_tax As String
text_tax = jResp.StringOf("text_tax")
Dim title As String
title = jResp.StringOf("title")
Dim v_type As String
v_type = jResp.StringOf("type")
Dim use_shipping_address As Long
use_shipping_address = jResp.BoolOf("use_shipping_address")
Dim vat_country As String
vat_country = jResp.StringOf("vat_country")
Dim vat_id As String
vat_id = jResp.StringOf("vat_id")
Dim fulfillment_country As String
fulfillment_country = jResp.StringOf("fulfillment_country")
Dim vat_option As String
vat_option = jResp.StringOf("vat_option")
Dim i As Long
i = 0
Dim count_i As Long
count_i = jResp.SizeOfArray("attachment_ids")
Do While i < count_i
jResp.I = i
strVal = jResp.StringOf("attachment_ids[i]")
i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("customer_snapshot.additional_groups_ids")
Do While i < count_i
jResp.I = i
strVal = jResp.StringOf("customer_snapshot.additional_groups_ids[i]")
i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("customer_snapshot.emails")
Do While i < count_i
jResp.I = i
strVal = jResp.StringOf("customer_snapshot.emails[i]")
i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("item_notes")
Do While i < count_i
jResp.I = i
strVal = jResp.StringOf("item_notes[i]")
i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("items")
Do While i < count_i
jResp.I = i
v_number = jResp.StringOf("items[i].number")
description = jResp.StringOf("items[i].description")
document_note = jResp.StringOf("items[i].document_note")
quantity = jResp.IntOf("items[i].quantity")
quantity_str = jResp.StringOf("items[i].quantity_str")
unit = jResp.StringOf("items[i].unit")
v_type = jResp.StringOf("items[i].type")
position = jResp.StringOf("items[i].position")
single_price_net = jResp.StringOf("items[i].single_price_net")
single_price_gross = jResp.StringOf("items[i].single_price_gross")
vat_percent = jResp.IntOf("items[i].vat_percent")
discount = jResp.StringOf("items[i].discount")
discount_type = jResp.StringOf("items[i].discount_type")
position_id = jResp.StringOf("items[i].position_id")
total_price_net = jResp.StringOf("items[i].total_price_net")
total_price_gross = jResp.StringOf("items[i].total_price_gross")
total_vat = jResp.StringOf("items[i].total_vat")
serial_number_id = jResp.StringOf("items[i].serial_number_id")
serial_number = jResp.StringOf("items[i].serial_number")
booking_account = jResp.StringOf("items[i].booking_account")
export_cost_1 = jResp.StringOf("items[i].export_cost_1")
export_cost_2 = jResp.StringOf("items[i].export_cost_2")
cost_price_net = jResp.StringOf("items[i].cost_price_net")
cost_price_total = jResp.StringOf("items[i].cost_price_total")
cost_price_charge = jResp.StringOf("items[i].cost_price_charge")
cost_price_charge_type = jResp.StringOf("items[i].cost_price_charge_type")
itemType = jResp.StringOf("items[i].itemType")
id = jResp.StringOf("items[i].id")
i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("file_format_config")
Do While i < count_i
jResp.I = i
v_type = jResp.StringOf("file_format_config[i].type")
i = i + 1
Loop
Curl Command
curl -X GET
-H "Authorization: {{apiKey}}"
-H "Accept: application/json"
https://api.easybill.de/rest/v1/documents/:id
Postman Collection Item JSON
{
"name": "Fetch document",
"request": {
"method": "GET",
"header": [
{
"key": "Accept",
"value": "application/json"
}
],
"url": {
"raw": "{{baseUrl}}/documents/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"documents",
":id"
],
"variable": [
{
"key": "id",
"value": "<long>",
"description": "(Required) ID of document"
}
]
}
},
"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}}/documents/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"documents",
":id"
],
"variable": [
{
"key": "id"
}
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "{\n \"address\": {\n \"salutation\": \"<integer>\",\n \"personal\": \"<boolean>\",\n \"title\": \"<string>\",\n \"first_name\": \"<string>\",\n \"last_name\": \"<string>\",\n \"suffix_1\": \"<string>\",\n \"suffix_2\": \"<string>\",\n \"company_name\": \"<string>\",\n \"street\": \"<string>\",\n \"zip_code\": \"<string>\",\n \"city\": \"<string>\",\n \"state\": \"<string>\",\n \"country\": \"<string>\"\n },\n \"attachment_ids\": [\n \"<integer>\",\n \"<integer>\"\n ],\n \"label_address\": {\n \"salutation\": \"<integer>\",\n \"personal\": \"<boolean>\",\n \"title\": \"<string>\",\n \"first_name\": \"<string>\",\n \"last_name\": \"<string>\",\n \"suffix_1\": \"<string>\",\n \"suffix_2\": \"<string>\",\n \"company_name\": \"<string>\",\n \"street\": \"<string>\",\n \"zip_code\": \"<string>\",\n \"city\": \"<string>\",\n \"state\": \"<string>\",\n \"country\": \"<string>\"\n },\n \"amount\": \"<integer>\",\n \"amount_net\": \"<integer>\",\n \"bank_debit_form\": null,\n \"billing_country\": \"<string>\",\n \"calc_vat_from\": 0,\n \"cancel_id\": \"<long>\",\n \"cash_allowance\": null,\n \"cash_allowance_days\": null,\n \"cash_allowance_text\": null,\n \"contact_id\": null,\n \"contact_label\": \"\",\n \"contact_text\": \"\",\n \"created_at\": \"<dateTime>\",\n \"currency\": \"EUR\",\n \"customer_id\": null,\n \"customer_snapshot\": {\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\": 1,\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\": \"SALEPRICE6\",\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\": \"nStbIm\",\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 },\n \"discount\": null,\n \"discount_type\": null,\n \"document_date\": \"<date>\",\n \"due_date\": \"<date>\",\n \"edited_at\": \"<dateTime>\",\n \"external_id\": null,\n \"replica_url\": null,\n \"grace_period\": \"<integer>\",\n \"due_in_days\": \"<integer>\",\n \"id\": \"<long>\",\n \"is_acceptable_on_public_domain\": false,\n \"is_archive\": false,\n \"is_draft\": \"<boolean>\",\n \"is_replica\": false,\n \"is_oss\": false,\n \"item_notes\": [\n \"<string>\",\n \"<string>\"\n ],\n \"items\": [\n {\n \"number\": null,\n \"description\": null,\n \"document_note\": \"<string>\",\n \"quantity\": 1,\n \"quantity_str\": \"<string>\",\n \"unit\": null,\n \"type\": \"POSITION\",\n \"position\": \"<integer>\",\n \"single_price_net\": null,\n \"single_price_gross\": \"<float>\",\n \"vat_percent\": 0,\n \"discount\": null,\n \"discount_type\": null,\n \"position_id\": null,\n \"total_price_net\": \"<float>\",\n \"total_price_gross\": \"<float>\",\n \"total_vat\": \"<float>\",\n \"serial_number_id\": \"<string>\",\n \"serial_number\": \"<string>\",\n \"booking_account\": null,\n \"export_cost_1\": null,\n \"export_cost_2\": null,\n \"cost_price_net\": null,\n \"cost_price_total\": \"<float>\",\n \"cost_price_charge\": \"<float>\",\n \"cost_price_charge_type\": \"PERCENT\",\n \"itemType\": \"UNDEFINED\",\n \"id\": \"<long>\"\n },\n {\n \"number\": null,\n \"description\": null,\n \"document_note\": \"<string>\",\n \"quantity\": 1,\n \"quantity_str\": \"<string>\",\n \"unit\": null,\n \"type\": \"POSITION\",\n \"position\": \"<integer>\",\n \"single_price_net\": null,\n \"single_price_gross\": \"<float>\",\n \"vat_percent\": 0,\n \"discount\": null,\n \"discount_type\": null,\n \"position_id\": null,\n \"total_price_net\": \"<float>\",\n \"total_price_gross\": \"<float>\",\n \"total_vat\": \"<float>\",\n \"serial_number_id\": \"<string>\",\n \"serial_number\": \"<string>\",\n \"booking_account\": null,\n \"export_cost_1\": null,\n \"export_cost_2\": null,\n \"cost_price_net\": null,\n \"cost_price_total\": \"<float>\",\n \"cost_price_charge\": \"<float>\",\n \"cost_price_charge_type\": \"PERCENT\",\n \"itemType\": \"UNDEFINED\",\n \"id\": \"<long>\"\n }\n ],\n \"last_postbox_id\": \"<long>\",\n \"login_id\": \"<long>\",\n \"number\": null,\n \"order_number\": \"\",\n \"buyer_reference\": \"\",\n \"paid_amount\": \"<integer>\",\n \"paid_at\": \"<date>\",\n \"pdf_pages\": \"<integer>\",\n \"pdf_template\": \"<string>\",\n \"project_id\": null,\n \"recurring_options\": {\n \"next_date\": \"<date>\",\n \"frequency\": \"MONTHLY\",\n \"frequency_special\": null,\n \"interval\": 1,\n \"end_date_or_count\": null,\n \"status\": \"WAITING\",\n \"as_draft\": false,\n \"is_notify\": false,\n \"send_as\": null,\n \"is_sign\": false,\n \"is_paid\": false,\n \"paid_date_option\": \"created_date\",\n \"is_sepa\": false,\n \"sepa_local_instrument\": null,\n \"sepa_sequence_type\": null,\n \"sepa_reference\": null,\n \"sepa_remittance_information\": null,\n \"target_type\": \"INVOICE\"\n },\n \"ref_id\": null,\n \"root_id\": null,\n \"service_date\": {\n \"type\": \"SERVICE\",\n \"date\": \"<date>\",\n \"date_from\": \"<date>\",\n \"date_to\": \"<date>\",\n \"text\": null\n },\n \"shipping_country\": null,\n \"status\": null,\n \"text\": \"<string>\",\n \"text_prefix\": \"<string>\",\n \"text_tax\": null,\n \"title\": null,\n \"type\": \"INVOICE\",\n \"use_shipping_address\": false,\n \"vat_country\": null,\n \"vat_id\": \"\",\n \"fulfillment_country\": null,\n \"vat_option\": null,\n \"file_format_config\": [\n {\n \"type\": \"xrechnung2_2_xml\"\n },\n {\n \"type\": \"xrechnung3_0_xml\"\n }\n ]\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}}/documents/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"documents",
":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}}/documents/:id",
"host": [
"{{baseUrl}}"
],
"path": [
"documents",
":id"
],
"variable": [
{
"key": "id"
}
]
}
},
"status": "Too Many Requests",
"code": 429,
"_postman_previewlanguage": "text",
"header": [
],
"cookie": [
],
"body": ""
}
]
}
