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
Dim queryParams As New ChilkatJsonObject
success = queryParams.UpdateString("fields","<string>")
success = queryParams.UpdateString("fieldset","basic")
success = queryParams.UpdateString("sort","<string>")
success = queryParams.UpdateInt("page",1)
success = queryParams.UpdateInt("per_page",5)
success = queryParams.UpdateString("q","<string>")
' Adds the "Authorization: Bearer <access_token>" header.
http.AuthToken = "<access_token>"
http.SetRequestHeader "Accept","application/json"
Dim resp As ChilkatHttpResponse
Set resp = http.QuickRequestParams("GET","https://api-v2.fattureincloud.it/c/:company_id/entities/clients",queryParams)
If (http.LastMethodSuccess = 0) Then
Debug.Print http.LastErrorText
Exit Sub
End If
Dim sbResponseBody As New ChilkatStringBuilder
success = resp.GetBodySb(sbResponseBody)
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 = resp.StatusCode
Debug.Print "Response Status Code = " & respStatusCode
If (respStatusCode >= 400) Then
Debug.Print "Response Header:"
Debug.Print resp.Header
Debug.Print "Failed."
Exit Sub
End If
' Sample JSON response:
' (Sample code for parsing the JSON response is shown below)
' {
' "current_page": "<integer>",
' "first_page_url": "<uri>",
' "from": "<integer>",
' "last_page": "<integer>",
' "last_page_url": "<uri>",
' "next_page_url": "<uri>",
' "path": "<uri>",
' "per_page": "<integer>",
' "prev_page_url": "<uri>",
' "to": "<integer>",
' "total": "<integer>",
' "data": [
' {
' "id": "<integer>",
' "code": "<string>",
' "name": "<string>",
' "type": null,
' "first_name": "<string>",
' "last_name": "<string>",
' "contact_person": "<string>",
' "vat_number": "<string>",
' "tax_code": "<string>",
' "address_street": "<string>",
' "address_postal_code": "<string>",
' "address_city": "<string>",
' "address_province": "<string>",
' "address_extra": "<string>",
' "country": "<string>",
' "email": "<string>",
' "certified_email": "<string>",
' "phone": "<string>",
' "fax": "<string>",
' "notes": "<string>",
' "default_vat": {
' "id": "<integer>",
' "value": "<number>",
' "description": "<string>",
' "notes": "<string>",
' "e_invoice": "<boolean>",
' "ei_type": "<string>",
' "ei_description": "<string>",
' "editable": "<boolean>",
' "is_disabled": "<boolean>"
' },
' "default_payment_terms": "<integer>",
' "default_payment_terms_type": "standard",
' "default_payment_method": {
' "id": "<integer>",
' "name": "<string>",
' "type": "standard",
' "is_default": "<boolean>",
' "default_payment_account": {
' "id": "<integer>",
' "name": "<string>",
' "type": "standard",
' "iban": "<string>",
' "sia": "<string>",
' "cuc": "<string>",
' "virtual": "<boolean>"
' },
' "details": [
' {
' "title": "<string>",
' "description": "<string>"
' },
' {
' "title": "<string>",
' "description": "<string>"
' }
' ],
' "bank_iban": "<string>",
' "bank_name": "<string>",
' "bank_beneficiary": "<string>",
' "ei_payment_method": "<string>"
' },
' "bank_name": "<string>",
' "bank_iban": "<string>",
' "bank_swift_code": "<string>",
' "shipping_address": "<string>",
' "e_invoice": "<boolean>",
' "ei_code": "<string>",
' "discount_highlight": "<boolean>",
' "default_discount": "<number>",
' "has_intent_declaration": "<boolean>",
' "intent_declaration_protocol_number": "<string>",
' "intent_declaration_protocol_date": "<date>",
' "created_at": "<string>",
' "updated_at": "<string>"
' },
' {
' "id": "<integer>",
' "code": "<string>",
' "name": "<string>",
' "type": null,
' "first_name": "<string>",
' "last_name": "<string>",
' "contact_person": "<string>",
' "vat_number": "<string>",
' "tax_code": "<string>",
' "address_street": "<string>",
' "address_postal_code": "<string>",
' "address_city": "<string>",
' "address_province": "<string>",
' "address_extra": "<string>",
' "country": "<string>",
' "email": "<string>",
' "certified_email": "<string>",
' "phone": "<string>",
' "fax": "<string>",
' "notes": "<string>",
' "default_vat": {
' "id": "<integer>",
' "value": "<number>",
' "description": "<string>",
' "notes": "<string>",
' "e_invoice": "<boolean>",
' "ei_type": "<string>",
' "ei_description": "<string>",
' "editable": "<boolean>",
' "is_disabled": "<boolean>"
' },
' "default_payment_terms": "<integer>",
' "default_payment_terms_type": "standard",
' "default_payment_method": {
' "id": "<integer>",
' "name": "<string>",
' "type": "standard",
' "is_default": "<boolean>",
' "default_payment_account": {
' "id": "<integer>",
' "name": "<string>",
' "type": "standard",
' "iban": "<string>",
' "sia": "<string>",
' "cuc": "<string>",
' "virtual": "<boolean>"
' },
' "details": [
' {
' "title": "<string>",
' "description": "<string>"
' },
' {
' "title": "<string>",
' "description": "<string>"
' }
' ],
' "bank_iban": "<string>",
' "bank_name": "<string>",
' "bank_beneficiary": "<string>",
' "ei_payment_method": "<string>"
' },
' "bank_name": "<string>",
' "bank_iban": "<string>",
' "bank_swift_code": "<string>",
' "shipping_address": "<string>",
' "e_invoice": "<boolean>",
' "ei_code": "<string>",
' "discount_highlight": "<boolean>",
' "default_discount": "<number>",
' "has_intent_declaration": "<boolean>",
' "intent_declaration_protocol_number": "<string>",
' "intent_declaration_protocol_date": "<date>",
' "created_at": "<string>",
' "updated_at": "<string>"
' }
' ]
' }
' Sample code for parsing the JSON response...
' Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
Dim id As String
Dim code As String
Dim name As String
Dim v_type As String
Dim first_name As String
Dim last_name As String
Dim contact_person As String
Dim vat_number As String
Dim tax_code As String
Dim address_street As String
Dim address_postal_code As String
Dim address_city As String
Dim address_province As String
Dim address_extra As String
Dim country As String
Dim email As String
Dim certified_email As String
Dim phone As String
Dim fax As String
Dim notes As String
Dim Id As String
Dim Value As String
Dim Description As String
Dim Notes As String
Dim E_invoice As String
Dim Ei_type As String
Dim Ei_description As String
Dim Editable As String
Dim Is_disabled As String
Dim default_payment_terms As String
Dim default_payment_terms_type As String
Dim default_payment_methodId As String
Dim Name As String
Dim v_Type As String
Dim Is_default As String
Dim Default_payment_accountId As String
Dim Default_payment_accountName As String
Dim Default_payment_accountType As String
Dim Iban As String
Dim Sia As String
Dim Cuc As String
Dim v_Virtual As String
Dim Bank_iban As String
Dim Bank_name As String
Dim Bank_beneficiary As String
Dim Ei_payment_method As String
Dim bank_name As String
Dim bank_iban As String
Dim bank_swift_code As String
Dim shipping_address As String
Dim e_invoice As String
Dim ei_code As String
Dim discount_highlight As String
Dim default_discount As String
Dim has_intent_declaration As String
Dim intent_declaration_protocol_number As String
Dim intent_declaration_protocol_date As String
Dim created_at As String
Dim updated_at As String
Dim j As Long
Dim count_j As Long
Dim title As String
Dim description As String
Dim current_page As String
current_page = jResp.StringOf("current_page")
Dim first_page_url As String
first_page_url = jResp.StringOf("first_page_url")
Dim from As String
from = jResp.StringOf("from")
Dim last_page As String
last_page = jResp.StringOf("last_page")
Dim last_page_url As String
last_page_url = jResp.StringOf("last_page_url")
Dim next_page_url As String
next_page_url = jResp.StringOf("next_page_url")
Dim path As String
path = jResp.StringOf("path")
Dim per_page As String
per_page = jResp.StringOf("per_page")
Dim prev_page_url As String
prev_page_url = jResp.StringOf("prev_page_url")
Dim v_to As String
v_to = jResp.StringOf("to")
Dim total As String
total = jResp.StringOf("total")
Dim i As Long
i = 0
Dim count_i As Long
count_i = jResp.SizeOfArray("data")
Do While i < count_i
jResp.I = i
id = jResp.StringOf("data[i].id")
code = jResp.StringOf("data[i].code")
name = jResp.StringOf("data[i].name")
v_type = jResp.StringOf("data[i].type")
first_name = jResp.StringOf("data[i].first_name")
last_name = jResp.StringOf("data[i].last_name")
contact_person = jResp.StringOf("data[i].contact_person")
vat_number = jResp.StringOf("data[i].vat_number")
tax_code = jResp.StringOf("data[i].tax_code")
address_street = jResp.StringOf("data[i].address_street")
address_postal_code = jResp.StringOf("data[i].address_postal_code")
address_city = jResp.StringOf("data[i].address_city")
address_province = jResp.StringOf("data[i].address_province")
address_extra = jResp.StringOf("data[i].address_extra")
country = jResp.StringOf("data[i].country")
email = jResp.StringOf("data[i].email")
certified_email = jResp.StringOf("data[i].certified_email")
phone = jResp.StringOf("data[i].phone")
fax = jResp.StringOf("data[i].fax")
notes = jResp.StringOf("data[i].notes")
Id = jResp.StringOf("data[i].default_vat.id")
Value = jResp.StringOf("data[i].default_vat.value")
Description = jResp.StringOf("data[i].default_vat.description")
Notes = jResp.StringOf("data[i].default_vat.notes")
E_invoice = jResp.StringOf("data[i].default_vat.e_invoice")
Ei_type = jResp.StringOf("data[i].default_vat.ei_type")
Ei_description = jResp.StringOf("data[i].default_vat.ei_description")
Editable = jResp.StringOf("data[i].default_vat.editable")
Is_disabled = jResp.StringOf("data[i].default_vat.is_disabled")
default_payment_terms = jResp.StringOf("data[i].default_payment_terms")
default_payment_terms_type = jResp.StringOf("data[i].default_payment_terms_type")
default_payment_methodId = jResp.StringOf("data[i].default_payment_method.id")
Name = jResp.StringOf("data[i].default_payment_method.name")
v_Type = jResp.StringOf("data[i].default_payment_method.type")
Is_default = jResp.StringOf("data[i].default_payment_method.is_default")
Default_payment_accountId = jResp.StringOf("data[i].default_payment_method.default_payment_account.id")
Default_payment_accountName = jResp.StringOf("data[i].default_payment_method.default_payment_account.name")
Default_payment_accountType = jResp.StringOf("data[i].default_payment_method.default_payment_account.type")
Iban = jResp.StringOf("data[i].default_payment_method.default_payment_account.iban")
Sia = jResp.StringOf("data[i].default_payment_method.default_payment_account.sia")
Cuc = jResp.StringOf("data[i].default_payment_method.default_payment_account.cuc")
v_Virtual = jResp.StringOf("data[i].default_payment_method.default_payment_account.virtual")
Bank_iban = jResp.StringOf("data[i].default_payment_method.bank_iban")
Bank_name = jResp.StringOf("data[i].default_payment_method.bank_name")
Bank_beneficiary = jResp.StringOf("data[i].default_payment_method.bank_beneficiary")
Ei_payment_method = jResp.StringOf("data[i].default_payment_method.ei_payment_method")
bank_name = jResp.StringOf("data[i].bank_name")
bank_iban = jResp.StringOf("data[i].bank_iban")
bank_swift_code = jResp.StringOf("data[i].bank_swift_code")
shipping_address = jResp.StringOf("data[i].shipping_address")
e_invoice = jResp.StringOf("data[i].e_invoice")
ei_code = jResp.StringOf("data[i].ei_code")
discount_highlight = jResp.StringOf("data[i].discount_highlight")
default_discount = jResp.StringOf("data[i].default_discount")
has_intent_declaration = jResp.StringOf("data[i].has_intent_declaration")
intent_declaration_protocol_number = jResp.StringOf("data[i].intent_declaration_protocol_number")
intent_declaration_protocol_date = jResp.StringOf("data[i].intent_declaration_protocol_date")
created_at = jResp.StringOf("data[i].created_at")
updated_at = jResp.StringOf("data[i].updated_at")
j = 0
count_j = jResp.SizeOfArray("data[i].default_payment_method.details")
Do While j < count_j
jResp.J = j
title = jResp.StringOf("data[i].default_payment_method.details[j].title")
description = jResp.StringOf("data[i].default_payment_method.details[j].description")
j = j + 1
Loop
i = i + 1
Loop
Curl Command
curl -G -d "fields=%3Cstring%3E"
-d "fieldset=basic"
-d "sort=%3Cstring%3E"
-d "page=1"
-d "per_page=5"
-d "q=%3Cstring%3E"
-H "Authorization: Bearer <access_token>"
-H "Accept: application/json"
https://api-v2.fattureincloud.it/c/:company_id/entities/clients
Postman Collection Item JSON
{
"name": "List Clients",
"request": {
"auth": {
"type": "oauth2",
"oauth2": [
{
"key": "scope",
"value": "entity.clients:r entity.clients:a entity.suppliers:r entity.suppliers:a products:r products:a issued_documents.invoices:r issued_documents.credit_notes:r issued_documents.receipts:r issued_documents.orders:r issued_documents.quotes:r issued_documents.proformas:r issued_documents.delivery_notes:r issued_documents.work_reports:r issued_documents.supplier_orders:r issued_documents.self_invoices:r issued_documents.invoices:a issued_documents.credit_notes:a issued_documents.receipts:a issued_documents.orders:a issued_documents.quotes:a issued_documents.proformas:a issued_documents.delivery_notes:a issued_documents.work_reports:a issued_documents.supplier_orders:a issued_documents.self_invoices:a received_documents:r received_documents:a stock:r stock:a receipts:r receipts:a taxes:r taxes:a archive:r archive:a cashbook:r cashbook:a settings:r settings:a situation:r",
"type": "string"
},
{
"key": "redirect_uri",
"value": "https://api-v2.fattureincloud.it/oauth/token",
"type": "string"
},
{
"key": "accessTokenUrl",
"value": "https://api-v2.fattureincloud.it/oauth/token",
"type": "string"
},
{
"key": "authUrl",
"value": "https://api-v2.fattureincloud.it/oauth/authorize",
"type": "string"
},
{
"key": "grant_type",
"value": "authorization_code",
"type": "string"
}
]
},
"method": "GET",
"header": [
{
"key": "Accept",
"value": "application/json"
}
],
"url": {
"raw": "{{baseUrl}}/c/:company_id/entities/clients?fields=<string>&fieldset=basic&sort=<string>&page=1&per_page=5&q=<string>",
"host": [
"{{baseUrl}}"
],
"path": [
"c",
":company_id",
"entities",
"clients"
],
"query": [
{
"key": "fields",
"value": "<string>",
"description": "List of comma-separated fields."
},
{
"key": "fieldset",
"value": "basic",
"description": "Name of the fieldset."
},
{
"key": "sort",
"value": "<string>",
"description": "List of comma-separated fields for result sorting (minus for desc sorting)."
},
{
"key": "page",
"value": "1",
"description": "The page to retrieve."
},
{
"key": "per_page",
"value": "5",
"description": "The size of the page."
},
{
"key": "q",
"value": "<string>",
"description": "Query for filtering the results."
}
],
"variable": [
{
"key": "company_id",
"value": "<integer>"
}
]
},
"description": "Lists the clients."
},
"response": [
{
"name": "Example response",
"originalRequest": {
"method": "GET",
"header": [
{
"key": "Accept",
"value": "application/json"
},
{
"description": "Added as a part of security scheme: oauth2",
"key": "Authorization",
"value": "<token>"
}
],
"url": {
"raw": "{{baseUrl}}/c/:company_id/entities/clients?fields=<string>&fieldset=basic&sort=<string>&page=1&per_page=5&q=<string>",
"host": [
"{{baseUrl}}"
],
"path": [
"c",
":company_id",
"entities",
"clients"
],
"query": [
{
"key": "fields",
"value": "<string>",
"description": "List of comma-separated fields."
},
{
"key": "fieldset",
"value": "basic",
"description": "Name of the fieldset."
},
{
"key": "sort",
"value": "<string>",
"description": "List of comma-separated fields for result sorting (minus for desc sorting)."
},
{
"key": "page",
"value": "1",
"description": "The page to retrieve."
},
{
"key": "per_page",
"value": "5",
"description": "The size of the page."
},
{
"key": "q",
"value": "<string>",
"description": "Query for filtering the results."
}
],
"variable": [
{
"key": "company_id"
}
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
}
],
"cookie": [
],
"body": "{\n \"current_page\": \"<integer>\",\n \"first_page_url\": \"<uri>\",\n \"from\": \"<integer>\",\n \"last_page\": \"<integer>\",\n \"last_page_url\": \"<uri>\",\n \"next_page_url\": \"<uri>\",\n \"path\": \"<uri>\",\n \"per_page\": \"<integer>\",\n \"prev_page_url\": \"<uri>\",\n \"to\": \"<integer>\",\n \"total\": \"<integer>\",\n \"data\": [\n {\n \"id\": \"<integer>\",\n \"code\": \"<string>\",\n \"name\": \"<string>\",\n \"type\": null,\n \"first_name\": \"<string>\",\n \"last_name\": \"<string>\",\n \"contact_person\": \"<string>\",\n \"vat_number\": \"<string>\",\n \"tax_code\": \"<string>\",\n \"address_street\": \"<string>\",\n \"address_postal_code\": \"<string>\",\n \"address_city\": \"<string>\",\n \"address_province\": \"<string>\",\n \"address_extra\": \"<string>\",\n \"country\": \"<string>\",\n \"email\": \"<string>\",\n \"certified_email\": \"<string>\",\n \"phone\": \"<string>\",\n \"fax\": \"<string>\",\n \"notes\": \"<string>\",\n \"default_vat\": {\n \"id\": \"<integer>\",\n \"value\": \"<number>\",\n \"description\": \"<string>\",\n \"notes\": \"<string>\",\n \"e_invoice\": \"<boolean>\",\n \"ei_type\": \"<string>\",\n \"ei_description\": \"<string>\",\n \"editable\": \"<boolean>\",\n \"is_disabled\": \"<boolean>\"\n },\n \"default_payment_terms\": \"<integer>\",\n \"default_payment_terms_type\": \"standard\",\n \"default_payment_method\": {\n \"id\": \"<integer>\",\n \"name\": \"<string>\",\n \"type\": \"standard\",\n \"is_default\": \"<boolean>\",\n \"default_payment_account\": {\n \"id\": \"<integer>\",\n \"name\": \"<string>\",\n \"type\": \"standard\",\n \"iban\": \"<string>\",\n \"sia\": \"<string>\",\n \"cuc\": \"<string>\",\n \"virtual\": \"<boolean>\"\n },\n \"details\": [\n {\n \"title\": \"<string>\",\n \"description\": \"<string>\"\n },\n {\n \"title\": \"<string>\",\n \"description\": \"<string>\"\n }\n ],\n \"bank_iban\": \"<string>\",\n \"bank_name\": \"<string>\",\n \"bank_beneficiary\": \"<string>\",\n \"ei_payment_method\": \"<string>\"\n },\n \"bank_name\": \"<string>\",\n \"bank_iban\": \"<string>\",\n \"bank_swift_code\": \"<string>\",\n \"shipping_address\": \"<string>\",\n \"e_invoice\": \"<boolean>\",\n \"ei_code\": \"<string>\",\n \"discount_highlight\": \"<boolean>\",\n \"default_discount\": \"<number>\",\n \"has_intent_declaration\": \"<boolean>\",\n \"intent_declaration_protocol_number\": \"<string>\",\n \"intent_declaration_protocol_date\": \"<date>\",\n \"created_at\": \"<string>\",\n \"updated_at\": \"<string>\"\n },\n {\n \"id\": \"<integer>\",\n \"code\": \"<string>\",\n \"name\": \"<string>\",\n \"type\": null,\n \"first_name\": \"<string>\",\n \"last_name\": \"<string>\",\n \"contact_person\": \"<string>\",\n \"vat_number\": \"<string>\",\n \"tax_code\": \"<string>\",\n \"address_street\": \"<string>\",\n \"address_postal_code\": \"<string>\",\n \"address_city\": \"<string>\",\n \"address_province\": \"<string>\",\n \"address_extra\": \"<string>\",\n \"country\": \"<string>\",\n \"email\": \"<string>\",\n \"certified_email\": \"<string>\",\n \"phone\": \"<string>\",\n \"fax\": \"<string>\",\n \"notes\": \"<string>\",\n \"default_vat\": {\n \"id\": \"<integer>\",\n \"value\": \"<number>\",\n \"description\": \"<string>\",\n \"notes\": \"<string>\",\n \"e_invoice\": \"<boolean>\",\n \"ei_type\": \"<string>\",\n \"ei_description\": \"<string>\",\n \"editable\": \"<boolean>\",\n \"is_disabled\": \"<boolean>\"\n },\n \"default_payment_terms\": \"<integer>\",\n \"default_payment_terms_type\": \"standard\",\n \"default_payment_method\": {\n \"id\": \"<integer>\",\n \"name\": \"<string>\",\n \"type\": \"standard\",\n \"is_default\": \"<boolean>\",\n \"default_payment_account\": {\n \"id\": \"<integer>\",\n \"name\": \"<string>\",\n \"type\": \"standard\",\n \"iban\": \"<string>\",\n \"sia\": \"<string>\",\n \"cuc\": \"<string>\",\n \"virtual\": \"<boolean>\"\n },\n \"details\": [\n {\n \"title\": \"<string>\",\n \"description\": \"<string>\"\n },\n {\n \"title\": \"<string>\",\n \"description\": \"<string>\"\n }\n ],\n \"bank_iban\": \"<string>\",\n \"bank_name\": \"<string>\",\n \"bank_beneficiary\": \"<string>\",\n \"ei_payment_method\": \"<string>\"\n },\n \"bank_name\": \"<string>\",\n \"bank_iban\": \"<string>\",\n \"bank_swift_code\": \"<string>\",\n \"shipping_address\": \"<string>\",\n \"e_invoice\": \"<boolean>\",\n \"ei_code\": \"<string>\",\n \"discount_highlight\": \"<boolean>\",\n \"default_discount\": \"<number>\",\n \"has_intent_declaration\": \"<boolean>\",\n \"intent_declaration_protocol_number\": \"<string>\",\n \"intent_declaration_protocol_date\": \"<date>\",\n \"created_at\": \"<string>\",\n \"updated_at\": \"<string>\"\n }\n ]\n}"
},
{
"name": "Unauthorized",
"originalRequest": {
"method": "GET",
"header": [
{
"description": "Added as a part of security scheme: oauth2",
"key": "Authorization",
"value": "<token>"
}
],
"url": {
"raw": "{{baseUrl}}/c/:company_id/entities/clients?fields=<string>&fieldset=basic&sort=<string>&page=1&per_page=5&q=<string>",
"host": [
"{{baseUrl}}"
],
"path": [
"c",
":company_id",
"entities",
"clients"
],
"query": [
{
"key": "fields",
"value": "<string>",
"description": "List of comma-separated fields."
},
{
"key": "fieldset",
"value": "basic",
"description": "Name of the fieldset."
},
{
"key": "sort",
"value": "<string>",
"description": "List of comma-separated fields for result sorting (minus for desc sorting)."
},
{
"key": "page",
"value": "1",
"description": "The page to retrieve."
},
{
"key": "per_page",
"value": "5",
"description": "The size of the page."
},
{
"key": "q",
"value": "<string>",
"description": "Query for filtering the results."
}
],
"variable": [
{
"key": "company_id"
}
]
}
},
"status": "Unauthorized",
"code": 401,
"_postman_previewlanguage": "text",
"header": [
],
"cookie": [
],
"body": ""
}
]
}
