VismaBouwsoftAPICalls.v1_GET_OrderLines Method
v1_GET_OrderLines() as String

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

HTTP method API version
GET v1

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

API Path: /OrderLines/
or
API Path: /OrderLines/{id}

You can make this API call:
* without the key field id to get a list of OrderLines
* with the key field id as the path parameter (the specific id of the OrderLine you want to get)

Fields

The following fields are available:

Field Name Type
id Number
source Number
nr1 String
nr2 String
description String
group String
name String
name_localized String
orderid Number
ordertype String
ordernr Number
order_address_id Number
order_address_name String
order_project_id Number
order_project_pnr Number
linenr Number
linkedto_type String
linkedto_type_localized String
linkedto_source Number
linkedto_id Number
unit1 String
unit2 String
unit1_localized String
unit2_localized String
quantity1 Number
quantity2 Number
quantity3 Number
quantity4 Number
quantity_total Number
all_quantities_are_included_in_quantity_total Boolean
price_unit Number
discount Number
price_total Number
vatcode String
vatpercent Number
vatcocontractor Boolean
ledger Number
price_unit_afterdiscount Number
cost_products Number
margin_products Number
cost_hours Number
margin_hours Number
hours_unit Number
hours_total Number
cost_machines Number
margin_machines Number
cost_subcontractors Number
margin_subcontractors Number
margin_fixed Number
info_brand String
info_type String
planned_quantity Number
project_id Number
project_pnr Number
project_unr Number
project_name String
supplier_id Number
supplier_nr Number
supplier_name String
include_line_in_total Boolean
include_line_on_print Boolean
start_on_new_page Boolean
ts_lastupdate String

/OrderLines/

API Path: /OrderLines/

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

with the following parameters :

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

Query Parameters :
ParameterName: filter, ParameterValue: orderid eq 6423

Success gives statuscode 200 And the following result

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

with the following parameters :

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

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

Success gives statuscode 200 And the following result

{ “Content-Range”:“0–4/62773”, “Records”: [
  {
    "id": 141,
    "orderid": 22,
    "ordertype": "OFFERTE",
    "ordernr": 20120002,
    "order_address_id": 24,
    "order_address_name": "Gasthof Lophem",
    "order_project_id": 3,
    "order_project_pnr": 20120003,
    "linenr": 1,
    "linkedto_type": "product",
    "linkedto_type_localized": "Article",
    "linkedto_source": 11,
    "linkedto_id": 7,
    "group": "Plaatsing parket dmv verlijming: European Oak: hall boven: Artikelen",
    "nr1": "249",
    "nr2": "",
    "description": "249 Express Elastische parketlijm",
    "unit1": "kg",
    "unit2": "",
    "unit1_localized": "kg",
    "unit2_localized": "",
    "quantity1": 380,
    "quantity2": 1,
    "quantity3": 1,
    "quantity4": 1,
    "quantity_total": 80,
    "all_quantities_are_included_in_quantity_total": true,
    "price_unit": 1.02,
    "discount": 0,
    "price_total": 81.599999999999994,
    "vatcode": "6",
    "vatpercent": 6,
    "vatcocontractor": false,
    "ledger": 70000,
    "price_unit_afterdiscount": 1.02,
    "cost_products": 3.0,
    "margin_products": 20,
    "cost_hours": 0.0,
    "margin_hours": 10,
    "hours_unit": 0,
    "hours_total": 0,
    "cost_machines": 0.0,
    "margin_machines": 0,
    "cost_subcontractors": 0.0,
    "margin_subcontractors": 0,
    "margin_fixed": 0,
    "info_brand": "",
    "info_type": "",
    "planned_quantity": 0,
    "project_id": 3,
    "project_pnr": 20120003,
    "project_unr": 3,
    "project_name": "Project Parketvloeren 2016",
    "supplier_id": 0,
    "supplier_nr": 0,
    "supplier_name": "",
    "include_line_in_total": true,
    "include_line_on_print": true,
    "start_on_new_page": false,
    "ts_lastupdate": "2022–04–28 12:40:30"
  },
  {
    "id": 142,
    "orderid": 22,
    "ordertype": "OFFERTE",
    "ordernr": 20120002,
    "order_address_id": 24,
    "order_address_name": "Gasthof Lophem",
    "order_project_id": 3,
    "order_project_pnr": 20120003,
    "linenr": 2,
    "linkedto_type": "product",
    "linkedto_type_localized": "Article",
    "linkedto_source": 11,
    "linkedto_id": 7,
    "group": "Plaatsing parket dmv verlijming: European Oak: hall boven: Artikelen",
    "nr1": "249",
    "nr2": "",
    "description": "249 Express Elastische parketlijm",
    "unit1": "kg",
    "unit2": "",
    "unit1_localized": "kg",
    "unit2_localized": "",
    "quantity1": 380,
    "quantity2": 1,
    "quantity3": 1,
    "quantity4": 1,
    "quantity_total": 90,
    "all_quantities_are_included_in_quantity_total": true,
    "price_unit": 30.460000000000001,
    "discount": 0,
    "price_total": 2741.400000000000091,
    "vatcode": "6",
    "vatpercent": 6,
    "vatcocontractor": false,
    "ledger": 70000,
    "price_unit_afterdiscount": 30.460000000000001,
    "cost_products": 3.0,
    "margin_products": 20,
    "cost_hours": 0.0,
    "margin_hours": 10,
    "hours_unit": 0,
    "hours_total": 0,
    "cost_machines": 0.0,
    "margin_machines": 0,
    "cost_subcontractors": 0.0,
    "margin_subcontractors": 0,
    "margin_fixed": 0,
    "info_brand": "",
    "info_type": "",
    "planned_quantity": 0,
    "project_id": 3,
    "project_pnr": 20120003,
    "project_unr": 3,
    "project_name": "Project Parketvloeren 2016",
    "supplier_id": 0,
    "supplier_nr": 0,
    "supplier_name": "",
    "include_line_in_total": true,
    "include_line_on_print": true,
    "start_on_new_page": false,
    "ts_lastupdate": "2022–04–28 12:40:30"
  }
,

]
}

/OrderLines/{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/OrderLines/139692

with the following parameters :

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

Success gives statuscode 200 And the following result

{ “Content-Range”:“0–0/1”, “Records”: [
  {
    "id": 139692,
    "orderid": 16124,
    "ordertype": "FAKTUUR",
    "ordernr": 2020001046,
    "order_address_id": 42178,
    "order_address_name": "SupportTest Andy",
    "order_project_id": 278,
    "order_project_pnr": 20140143,
    "linenr": 2,
    "linkedto_type": "",
    "linkedto_type_localized": "",
    "linkedto_source": 0,
    "linkedto_id": 0,
    "group": "",
    "nr1": "",
    "nr2": "",
    "description": "",
    "unit1": "",
    "unit2": "",
    "unit1_localized": "",
    "unit2_localized": "",
    "quantity1": 0,
    "quantity2": 1,
    "quantity3": 1,
    "quantity4": 1,
    "quantity_total": 0,
    "all_quantities_are_included_in_quantity_total": true,
    "price_unit": 0.0,
    "discount": 0,
    "price_total": 0.0,
    "vatcode": "21",
    "vatpercent": 21,
    "vatcocontractor": false,
    "ledger": 700000,
    "price_unit_afterdiscount": 0.0,
    "cost_products": 0.0,
    "margin_products": 0,
    "cost_hours": 0.0,
    "margin_hours": 0,
    "hours_unit": 0,
    "hours_total": 0,
    "cost_machines": 0.0,
    "margin_machines": 0,
    "cost_subcontractors": 0.0,
    "margin_subcontractors": 0,
    "margin_fixed": 0,
    "info_brand": "",
    "info_type": "",
    "planned_quantity": 0,
    "project_id": 278,
    "project_pnr": 20140143,
    "project_unr": 0,
    "project_name": "SupportTest Andy Plaatsen Deuren",
    "supplier_id": 0,
    "supplier_nr": 0,
    "supplier_name": "",
    "include_line_in_total": true,
    "include_line_on_print": true,
    "start_on_new_page": false,
    "ts_lastupdate": "2025–02–12 14:30:15"
  }
]
}

https://ra.bouwsoft.be/api/v1/OrderLines/141

with the following parameters :

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

Success gives statuscode 200 And the following result

{ “Content-Range”:“0–0/1”, “Records”: [
  {
    "id": 141,
    "orderid": 22,
    "ordertype": "OFFERTE",
    "ordernr": 20120002,
    "order_address_id": 24,
    "order_address_name": "Gasthof Lophem",
    "order_project_id": 3,
    "order_project_pnr": 20120003,
    "linenr": 1,
    "linkedto_type": "product",
    "linkedto_type_localized": "Article",
    "linkedto_source": 11,
    "linkedto_id": 7,
    "group": "Plaatsing parket dmv verlijming: European Oak: hall boven: Artikelen",
    "nr1": "249",
    "nr2": "",
    "description": "249 Express Elastische parketlijm",
    "unit1": "kg",
    "unit2": "",
    "unit1_localized": "kg",
    "unit2_localized": "",
    "quantity1": 380,
    "quantity2": 1,
    "quantity3": 1,
    "quantity4": 1,
    "quantity_total": 80,
    "all_quantities_are_included_in_quantity_total": true,
    "price_unit": 1.02,
    "discount": 0,
    "price_total": 81.599999999999994,
    "vatcode": "6",
    "vatpercent": 6,
    "vatcocontractor": false,
    "ledger": 70000,
    "price_unit_afterdiscount": 1.02,
    "cost_products": 3.0,
    "margin_products": 20,
    "cost_hours": 0.0,
    "margin_hours": 10,
    "hours_unit": 0,
    "hours_total": 0,
    "cost_machines": 0.0,
    "margin_machines": 0,
    "cost_subcontractors": 0.0,
    "margin_subcontractors": 0,
    "margin_fixed": 0,
    "info_brand": "",
    "info_type": "",
    "planned_quantity": 0,
    "project_id": 3,
    "project_pnr": 20120003,
    "project_unr": 3,
    "project_name": "Project Parketvloeren 2016",
    "supplier_id": 0,
    "supplier_nr": 0,
    "supplier_name": "",
    "include_line_in_total": true,
    "include_line_on_print": true,
    "start_on_new_page": false,
    "ts_lastupdate": "2022–04–28 12:40:30"
  }
]
}