VismaBouwsoftAPICalls.v1_GET_Addresses Method
v1_GET_Addresses() as String

This API call is used to get fields of a(n) Address(s)

HTTP method API version
GET v1

Don’t forget to put the Authorization field in the header

API Path: /Addresses/
or
API Path: /Addresses/{id}
or
API Path: /Addresses/{id}/ProspectSourceAndStatus
or
API Path: /Addresses/{id}/ProspectSourceAndStatus/FieldInfo
or
API Path: /Addresses/{id}/image
or
API Path: /Addresses/{id}/note_html
or
API Path: /Addresses/{id}/note_plain
or
API Path: /Addresses/{id}/note_rtf
or
API Path: /Addresses/FieldInfo/

You can make this API call:
* without the key field id to get a list of Addresses
* with the key field id as the path parameter (the specific id of the Address you want to get)
* to request the FieldInfo for this call

Fields

The following fields are available:

Field Name Type Id Type Name Length Required Writeable Force Write Link
clientnr 1 tpLong 0 No Yes No
suppliernr 1 tpLong 0 No Yes No
groups 2 tpString 0 No No No
salutation 2 tpString 50 No Yes No
language_id 1 tpLong 0 No Yes No
name 2 tpString 150 Yes Yes No
address 2 tpString 63 No Yes No
addressline2 2 tpString 63 No Yes No
countrycode 2 tpString 2 No Yes No
zipcode 2 tpString 15 No Yes No
city 2 tpString 40 No Yes No
state 2 tpString 40 No Yes No
telephone1 9 tpTelefoon 25 No Yes No
telephone2 9 tpTelefoon 25 No Yes No
fax 15 tpFax 25 No Yes No
gsm 9 tpTelefoon 25 No Yes No
shippingaddress_id 1 tpLong 0 No No No
shippingaddress_address 2 tpString 63 No Yes No
shippingaddress_addressline2 2 tpString 63 No Yes No
shippingaddress_countrycode 2 tpString 2 No Yes No
shippingaddress_zipcode 2 tpString 15 No Yes No
shippingaddress_city 2 tpString 40 No Yes No
shippingaddress_state 2 tpString 40 No Yes No
email 10 tpEmail 100 No Yes No
website 2 tpString 100 No Yes No
contact_id 1 tpLong 0 No Yes No
project_id 1 tpLong 0 No Yes No
vatnr 2 tpString 30 No Yes No
vatregistered 5 tpBool 0 No Yes No
gln 2 tpString 13 No Yes No
be_rpr 2 tpString 50 No Yes No
iban1 2 tpString 35 No Yes No
bic1 2 tpString 11 No Yes No
iban2 2 tpString 35 No Yes No
bic2 2 tpString 11 No Yes No
term_of_payment 2 tpString 0 No No No
date_created 3 tpDate 0 No No No
active 5 tpBool 0 No No No
risk 5 tpBool 0 No Yes No
prospect_datefirstaction 6 tpDateNullString 0 No Yes No
prospect_source_id 1 tpLong 0 No Yes No
prospect_currentstatus_id 1 tpLong 0 No Yes No
ts_lastupdate 3 tpDate 0 No No No

/Addresses/

API Path: /Addresses/

If everything succeeds the HTTP response status is 200
(200 OK)

If there is something wrong with the request, the response status and code is 400
(400 Bad Request)

If you forget to send the Authorization, the response status is 401
(401 Unauthorized)

If what you sent can’t be processed, the response status is 500
(500 Internal Server Error)

For an explanation of all possible errors, please consult our section on possible answers to API calls here

Examples:

https://ra.bouwsoft.be/api/v1/Addresses

with the following parameters :

Header Parameters :
ParameterName: AccessToken, ParameterValue: fAjfWxfVkjzSflArttzRqbPPfjODIbPljbmbzPktIVkkUAImtA
ParameterName: Clientnr, ParameterValue: 1601

Query Parameters :
ParameterName: limit, ParameterValue: 5
ParameterName: sort, ParameterValue: id

Success gives statuscode 200 And the following result

{ “Content-Range”:“0–4/12874”, “Records”: [
  {
    "id": 1,
    "clientnr": 0,
    "suppliernr": 1,
    "groups": "VEILIGHEIDSCOORDINATOREN, VERTEGENWOORDIGERS",
    "salutation": "NV",
    "language_id": 1,
    "name": "Use It Group",
    "address": "Molenweg 9",
    "addressline2": "",
    "countrycode": "",
    "zipcode": "",
    "city": "",
    "state": "",
    "telephone1": "050 45 40 80 ",
    "telephone2": "",
    "fax": "050 32 38 08 ",
    "gsm": "",
    "shippingaddress_id": 0,
    "shippingaddress_address": "",
    "shippingaddress_addressline2": "",
    "shippingaddress_countrycode": "",
    "shippingaddress_zipcode": "",
    "shippingaddress_city": "",
    "shippingaddress_state": "",
    "email": "",
    "website": "http://support.bouwsoft.be",
    "contact_id": 0,
    "project_id": 512,
    "vatnr": "",
    "vatregistered": false,
    "gln": "",
    "be_rpr": "KvK H17159014",
    "iban1": "BE67 0013 3231 3487",
    "bic1": "GEBABEBB",
    "iban2": "NL94ABNA0848169875",
    "bic2": "ABNANL2A",
    "term_of_payment": "1 day",
    "date_created": "2012–09–04",
    "active": true,
    "risk": false,
    "prospect_datefirstaction": "",
    "prospect_source_id": 0,
    "prospect_currentstatus_id": 0,
    "ts_lastupdate": "2022–03–30 14:48:59"
  },
  {
    "id": 3,
    "clientnr": 0,
    "suppliernr": 2,
    "groups": "VEILIGHEIDSCOORDINATOREN",
    "salutation": "",
    "language_id": 1,
    "name": "Alvolas",
    "address": "Zandvoordeschorredijkstraat 303",
    "addressline2": "",
    "countrycode": "BE",
    "zipcode": "8400",
    "city": "Oostende",
    "state": "West-Vlaanderen",
    "telephone1": "",
    "telephone2": "",
    "fax": "",
    "gsm": "",
    "shippingaddress_id": 30,
    "shippingaddress_address": "",
    "shippingaddress_addressline2": "",
    "shippingaddress_countrycode": "",
    "shippingaddress_zipcode": "",
    "shippingaddress_city": "",
    "shippingaddress_state": "",
    "email": "",
    "website": "",
    "contact_id": 17,
    "project_id": 402,
    "vatnr": "BE 0479.835.145",
    "vatregistered": true,
    "gln": "",
    "be_rpr": "",
    "iban1": "BE0132.456789",
    "bic1": "",
    "iban2": "",
    "bic2": "",
    "term_of_payment": "14 days",
    "date_created": "2019–06–04",
    "active": true,
    "risk": false,
    "prospect_datefirstaction": "",
    "prospect_source_id": 0,
    "prospect_currentstatus_id": 0,
    "ts_lastupdate": "2026–01–15 07:43:54"
  }
,
…
]
}

https://ra.bouwsoft.be/api/v1/Addresses

with the following parameters :

Header Parameters :
ParameterName: AccessToken, ParameterValue: rPGfWxfVkGzSfIGUDtzRqkbbfGPkIOAAjVItztOADtrGDfrPPD
ParameterName: Clientnr, ParameterValue: 115

Query Parameters :
ParameterName: filter, ParameterValue: ‘matthias’
ParameterName: limit, ParameterValue: 3

Success gives statuscode 200 And the following result

{ “Content-Range”:“0–2/14”, “Records”: [
  {
    "id": 15779,
    "clientnr": 1000034,
    "suppliernr": 0,
    "groups": "Matthias",
    "salutation": "Dhr. En Mevr.",
    "language_id": 3,
    "name": "Matthias Bouwsoft",
    "address": "Molenweg 9",
    "addressline2": "",
    "countrycode": "BE",
    "zipcode": "8377",
    "city": "Houtave",
    "state": "West-vlaanderen",
    "telephone1": "+0 000 ",
    "telephone2": "+32 111 11 11 11 11 ",
    "fax": "+32 222 22 22 22 22 ",
    "gsm": "+32 3 333 33 33 33 33 ",
    "shippingaddress_id": 34963,
    "shippingaddress_address": "",
    "shippingaddress_addressline2": "",
    "shippingaddress_countrycode": "",
    "shippingaddress_zipcode": "",
    "shippingaddress_city": "",
    "shippingaddress_state": "",
    "email": "",
    "website": "",
    "contact_id": 26936,
    "project_id": 1027,
    "vatnr": "",
    "vatregistered": false,
    "gln": "",
    "be_rpr": "",
    "iban1": "",
    "bic1": "",
    "iban2": "",
    "bic2": "",
    "term_of_payment": "30 days",
    "date_created": "2013–11–06",
    "active": true,
    "risk": false,
    "prospect_datefirstaction": "",
    "prospect_source_id": 0,
    "prospect_currentstatus_id": 0,
    "ts_lastupdate": "2022–07–25 11:19:11"
  },
  {
    "id": 167169,
    "clientnr": 20170087,
    "suppliernr": 0,
    "groups": "",
    "salutation": "",
    "language_id": 1,
    "name": "Matthias Bouwsoft",
    "address": "Molenweg 9",
    "addressline2": "",
    "countrycode": "BE",
    "zipcode": "8377",
    "city": "Meetkerke",
    "state": "West-vlaanderen",
    "telephone1": "+32 50 45 40 80 ",
    "telephone2": "",
    "fax": "",
    "gsm": "",
    "shippingaddress_id": 370990,
    "shippingaddress_address": "",
    "shippingaddress_addressline2": "",
    "shippingaddress_countrycode": "",
    "shippingaddress_zipcode": "",
    "shippingaddress_city": "",
    "shippingaddress_state": "",
    "email": "",
    "website": "",
    "contact_id": 156508,
    "project_id": 2093,
    "vatnr": "",
    "vatregistered": false,
    "gln": "",
    "be_rpr": "",
    "iban1": "",
    "bic1": "",
    "iban2": "",
    "bic2": "",
    "term_of_payment": "30 days",
    "date_created": "2017–10–05",
    "active": true,
    "risk": false,
    "prospect_datefirstaction": "2017–10–05",
    "prospect_source_id": 0,
    "prospect_currentstatus_id": 0,
    "ts_lastupdate": "2022–07–25 09:46:54"
  }
,
…
]
}

https://ra.bouwsoft.be/api/v1/Addresses

with the following parameters :

Header Parameters :
ParameterName: AccessToken, ParameterValue: rPGfWxfVkGzSfIGUDtzRqkbbfGPkIOAAjVItztOADtrGDfrPPD
ParameterName: Clientnr, ParameterValue: 115

Query Parameters :
ParameterName: limit, ParameterValue: 3
ParameterName: nextid, ParameterValue: 42502

Success gives statuscode 200 And the following result

{ “Content-Range”:“1709–1711/25128”, “Records”: [
  {
    "id": 42502,
    "clientnr": 1002011,
    "suppliernr": 0,
    "groups": "",
    "salutation": "",
    "language_id": 1,
    "name": "Matthias Vienne",
    "address": "Diksmuidse Heerweg 56",
    "addressline2": "",
    "countrycode": "BE",
    "zipcode": "8200",
    "city": "Brugge",
    "state": "West-Vlaanderen",
    "telephone1": "",
    "telephone2": "",
    "fax": "",
    "gsm": "",
    "shippingaddress_id": 101500,
    "shippingaddress_address": "",
    "shippingaddress_addressline2": "",
    "shippingaddress_countrycode": "",
    "shippingaddress_zipcode": "",
    "shippingaddress_city": "",
    "shippingaddress_state": "",
    "email": "matthias@bouwsoft.be",
    "website": "",
    "contact_id": 0,
    "project_id": 0,
    "vatnr": "BE 0894.138.377",
    "vatregistered": true,
    "gln": "",
    "be_rpr": "",
    "iban1": "",
    "bic1": "",
    "iban2": "",
    "bic2": "",
    "term_of_payment": "30 days",
    "date_created": "2015–07–16",
    "active": true,
    "risk": false,
    "prospect_datefirstaction": "",
    "prospect_source_id": 0,
    "prospect_currentstatus_id": 0,
    "ts_lastupdate": "2025–12–18 18:15:03"
  },
  {
    "id": 15848,
    "clientnr": 1000077,
    "suppliernr": 0,
    "groups": "Bedrijven",
    "salutation": "De Heer",
    "language_id": 1,
    "name": "Matthias Vienne",
    "address": "veld 11",
    "addressline2": "",
    "countrycode": "BE",
    "zipcode": "8200",
    "city": "Sint-Michiels (Brugge)",
    "state": "West-Vlaanderen",
    "telephone1": "+32 49 45 66 43 ",
    "telephone2": "+32 50 76 64 69 ",
    "fax": "+32 50 67 64 69 ",
    "gsm": "",
    "shippingaddress_id": 36472,
    "shippingaddress_address": "Molenweg 9",
    "shippingaddress_addressline2": "",
    "shippingaddress_countrycode": "BE",
    "shippingaddress_zipcode": "8377",
    "shippingaddress_city": "Meetkerke",
    "shippingaddress_state": "West-vlaanderen",
    "email": "",
    "website": "http://www.matthias-vienne.be",
    "contact_id": 12129,
    "project_id": 866,
    "vatnr": "",
    "vatregistered": false,
    "gln": "",
    "be_rpr": "",
    "iban1": "",
    "bic1": "",
    "iban2": "",
    "bic2": "",
    "term_of_payment": "30 days",
    "date_created": "2014–01–24",
    "active": true,
    "risk": false,
    "prospect_datefirstaction": "",
    "prospect_source_id": 0,
    "prospect_currentstatus_id": 0,
    "ts_lastupdate": "2022–07–25 09:46:59"
  }
,
…
]
}

/Addresses/{id}

If everything succeeds the HTTP response status is 200
(200 OK)

If there is something wrong with the request, the response status and code is 400
(400 Bad Request)

If there is no record that has the requested id the HTTP response status and code is 404
(404 Not found)

If you forget to send the Authorization, the response status is 401
(401 Unauthorized)

If what you sent can’t be processed, the response status is 500
(500 Internal Server Error)

For an explanation of all possible errors, please consult our section on possible answers to API calls here

Examples:

https://ra.bouwsoft.be/api/v1/Addresses/329298

with the following parameters :

Header Parameters :
ParameterName: AccessToken, ParameterValue: rPGfWxfVkGzSfIGUDtzRqkbbfGPkIOAAjVItztOADtrGDfrPPD
ParameterName: Clientnr, ParameterValue: 115

Success gives statuscode 200 And the following result

{ “Content-Range”:“0–0/1”, “Records”: [
  {
    "id": 329298,
    "clientnr": 201700525,
    "suppliernr": 0,
    "groups": "",
    "salutation": "",
    "language_id": 1,
    "name": "DirkAPICust",
    "address": "Molleweg 9",
    "addressline2": "",
    "countrycode": "BE",
    "zipcode": "8377",
    "city": "Houtave",
    "state": "West-vlaanderen",
    "telephone1": "",
    "telephone2": "",
    "fax": "",
    "gsm": "",
    "shippingaddress_id": 722949,
    "shippingaddress_address": "",
    "shippingaddress_addressline2": "",
    "shippingaddress_countrycode": "",
    "shippingaddress_zipcode": "",
    "shippingaddress_city": "",
    "shippingaddress_state": "",
    "email": "",
    "website": "",
    "contact_id": 0,
    "project_id": 0,
    "vatnr": "",
    "vatregistered": false,
    "gln": "",
    "be_rpr": "",
    "iban1": "",
    "bic1": "",
    "iban2": "",
    "bic2": "",
    "term_of_payment": "30 days",
    "date_created": "2026–05–07",
    "active": true,
    "risk": false,
    "prospect_datefirstaction": "",
    "prospect_source_id": 0,
    "prospect_currentstatus_id": 0,
    "ts_lastupdate": "2026–05–07 09:18:25"
  }
]
}

https://ra.bouwsoft.be/api/v1/Addresses/329299

with the following parameters :

Header Parameters :
ParameterName: AccessToken, ParameterValue: rPGfWxfVkGzSfIGUDtzRqkbbfGPkIOAAjVItztOADtrGDfrPPD
ParameterName: Clientnr, ParameterValue: 115

Success gives statuscode 200 And the following result

{ “Content-Range”:“0–0/1”, “Records”: [
  {
    "id": 329299,
    "clientnr": 0,
    "suppliernr": 201700526,
    "groups": "",
    "salutation": "",
    "language_id": 1,
    "name": "DirkAPISupp",
    "address": "Molleweg 9",
    "addressline2": "",
    "countrycode": "BE",
    "zipcode": "8377",
    "city": "Meetkerke",
    "state": "West-vlaanderen",
    "telephone1": "",
    "telephone2": "",
    "fax": "",
    "gsm": "",
    "shippingaddress_id": 722951,
    "shippingaddress_address": "",
    "shippingaddress_addressline2": "",
    "shippingaddress_countrycode": "",
    "shippingaddress_zipcode": "",
    "shippingaddress_city": "",
    "shippingaddress_state": "",
    "email": "",
    "website": "",
    "contact_id": 0,
    "project_id": 0,
    "vatnr": "",
    "vatregistered": false,
    "gln": "",
    "be_rpr": "",
    "iban1": "",
    "bic1": "",
    "iban2": "",
    "bic2": "",
    "term_of_payment": "30 days",
    "date_created": "2026–05–07",
    "active": true,
    "risk": false,
    "prospect_datefirstaction": "",
    "prospect_source_id": 0,
    "prospect_currentstatus_id": 0,
    "ts_lastupdate": "2026–05–07 09:18:22"
  }
]
}

/Addresses/{id}/ProspectSourceAndStatus

If everything succeeds the HTTP response status is 200
(200 OK)

If there is something wrong with the request, the response status and code is 400
(400 Bad Request)

If there is no record that has the requested id the HTTP response status and code is 404
(404 Not found)

If you forget to send the Authorization, the response status is 401
(401 Unauthorized)

If what you sent can’t be processed, the response status is 500
(500 Internal Server Error)

For an explanation of all possible errors, please consult our section on possible answers to API calls here

Examples:

https://ra.bouwsoft.be/api/v1/Addresses/13/ProspectSourceAndStatus

with the following parameters :

Header Parameters :
ParameterName: AccessToken, ParameterValue: jPrfWxfOOmzSftOIktzRqbjOfDUOIOUfjVttzmfkOrjGmOkrAI
ParameterName: Clientnr, ParameterValue: 115

Success gives statuscode 200 And the following result

{ “Content-Range”:“0–0/1”, “Records”: [
  {
    "id": 13,
    "datefirstaction": "2026–03–11",
    "source_id": "4",
    "source": "Vakbeurs",
    "source_localized": "Vakbeurs",
    "currentstatus_id": "4",
    "currentstatus": "Nu geen geld",
    "currentstatus_localized": "Nu geen geld"
  }
]
}

/Addresses/{id}/ProspectSourceAndStatus/FieldInfo

If everything succeeds the HTTP response status is 200
(200 OK)

If there is something wrong with the request, the response status and code is 400
(400 Bad Request)

If there is no record that has the requested id the HTTP response status and code is 404
(404 Not found)

If you forget to send the Authorization, the response status is 401
(401 Unauthorized)

If what you sent can’t be processed, the response status is 500
(500 Internal Server Error)

For an explanation of all possible errors, please consult our section on possible answers to API calls here

Examples:

https://ra.bouwsoft.be/api/v1/Addresses/13/ProspectSourceAndStatus

with the following parameters :

Header Parameters :
ParameterName: AccessToken, ParameterValue: jPrfWxfOOmzSftOIktzRqbjOfDUOIOUfjVttzmfkOrjGmOkrAI
ParameterName: Clientnr, ParameterValue: 115

Success gives statuscode 200 And the following result

[
  {
    "name": "datefirstaction",
    "type_id": 6,
    "type_name": "tpDateNullString",
    "length": 0,
    "required": false,
    "writeable": false,
    "forcewrite": false,
    "link": ""
  },
  {
    "name": "source_id",
    "type_id": 2,
    "type_name": "tpString",
    "length": 0,
    "required": false,
    "writeable": false,
    "forcewrite": false,
    "link": ""
  }
,
…
]

/Addresses/{id}/image

If everything succeeds the HTTP response status is 200
(200 OK)

If there is something wrong with the request, the response status and code is 400
(400 Bad Request)

If there is no record that has the requested id the HTTP response status and code is 404
(404 Not found)

If you forget to send the Authorization, the response status is 401
(401 Unauthorized)

If what you sent can’t be processed, the response status is 500
(500 Internal Server Error)

For an explanation of all possible errors, please consult our section on possible answers to API calls here

Examples:

https://ra.bouwsoft.be/api/v1/Addresses/3759/image

with the following parameters :

Header Parameters :
ParameterName: AccessToken, ParameterValue: bbGfWxfOPfzSfVUjmtzRqrVffDAOIOftjmrtzPrbPGOGmmjrmD
ParameterName: Clientnr, ParameterValue: 115

Success gives statuscode 200 And the following result

image

/Addresses/{id}/note_html

If everything succeeds the HTTP response status is 200
(200 OK)

If there is something wrong with the request, the response status and code is 400
(400 Bad Request)

If there is no record that has the requested id the HTTP response status and code is 404
(404 Not found)

If you forget to send the Authorization, the response status is 401
(401 Unauthorized)

If what you sent can’t be processed, the response status is 500
(500 Internal Server Error)

For an explanation of all possible errors, please consult our section on possible answers to API calls here

Examples:

https://ra.bouwsoft.be/api/v1/Addresses/3759/note_html

with the following parameters :

Header Parameters :
ParameterName: Clientnr, ParameterValue: 115
ParameterName: AccessToken, ParameterValue: mrbfWxfAkOzSfkObIfzRqDkVfjVAGfblfDVbzDtrjbffIUjkAV

Success gives statuscode 200 And the following result

<HTML><BODY> <DIV STYLE="text-align: left;"><SPAN STYLE="font-family: Arial;font-size: 12pt;color: #000000;">a<B>B</B>c</SPAN></DIV> </BODY></HTML>

/Addresses/{id}/note_plain

If everything succeeds the HTTP response status is 200
(200 OK)

If there is something wrong with the request, the response status and code is 400
(400 Bad Request)

If there is no record that has the requested id the HTTP response status and code is 404
(404 Not found)

If you forget to send the Authorization, the response status is 401
(401 Unauthorized)

If what you sent can’t be processed, the response status is 500
(500 Internal Server Error)

For an explanation of all possible errors, please consult our section on possible answers to API calls here

Examples:

https://ra.bouwsoft.be/api/v1/Addresses/3759/note_plain

with the following parameters :

Header Parameters :
ParameterName: Clientnr, ParameterValue: 115
ParameterName: AccessToken, ParameterValue: mrbfWxfAkOzSfkObIfzRqDkVfjVAGfblfDVbzDtrjbffIUjkAV

Success gives statuscode 200 And the following result

aBc

/Addresses/{id}/note_rtf

If everything succeeds the HTTP response status is 200
(200 OK)

If there is something wrong with the request, the response status and code is 400
(400 Bad Request)

If there is no record that has the requested id the HTTP response status and code is 404
(404 Not found)

If you forget to send the Authorization, the response status is 401
(401 Unauthorized)

If what you sent can’t be processed, the response status is 500
(500 Internal Server Error)

For an explanation of all possible errors, please consult our section on possible answers to API calls here

Examples:

https://ra.bouwsoft.be/api/v1/Addresses/3759/note_rtf

with the following parameters :

Header Parameters :
ParameterName: Clientnr, ParameterValue: 115
ParameterName: AccessToken, ParameterValue: UfDfWxfOPkzSftIAGfzRqVrrfVmOkGrbftAkzbPDAbPIkfDkUb

Success gives statuscode 200 And the following result

{\rtf1\ansi\deff0{\fonttbl{\f0\fnil Arial;}}{\colortbl ;\red0\green0\blue0;}{*\generator Spikesoft 16.02;}\ql\li0\f0\fs24\cf1 a\b B\b0 c}

/Addresses/FieldInfo

If everything succeeds the HTTP response status is 200
(200 OK)

If there is something wrong with the request, the response status and code is 400
(400 Bad Request)

If there is no record that has the requested id the HTTP response status and code is 404
(404 Not found)

If you forget to send the Authorization, the response status is 401
(401 Unauthorized)

If what you sent can’t be processed, the response status is 500
(500 Internal Server Error)

For an explanation of all possible errors, please consult our section on possible answers to API calls here

Examples:

https://ra.bouwsoft.be/api/v1/Addresses/FieldInfo

with the following parameters :

Header Parameters :
ParameterName: AccessToken, ParameterValue: UOIfWxffkAzSfrUjPtzRqUUbfkrkIOlljbPtzDDlVrfGjAmtfb
ParameterName: Clientnr, ParameterValue: 115

Success gives statuscode 200 And the following result

[
  {
    "name": "clientnr",
    "type_id": 1,
    "type_name": "tpLong",
    "length": 0,
    "required": false,
    "writeable": true,
    "forcewrite": false,
    "link": ""
  },
  {
    "name": "suppliernr",
    "type_id": 1,
    "type_name": "tpLong",
    "length": 0,
    "required": false,
    "writeable": true,
    "forcewrite": false,
    "link": ""
  }
,
…
]