Skip to main content

Ladu20 API

API structure

Ladu20 API is REST based, queries are processed via CURL POST requests.

API base URL: henceforth BASEURL, will be provided by KMA.
API key: henceforth APIKEY, will be provided by KMA
Request data is posted in CURLOPT_POSTFIELDS as JSON.
Response data is JSON formatted and returns request status, request type, result data and rowcount.

HTTP header Content-Type needs to be set to application/json

PHP sample request
<?php
$curl = curl_init();
curl_setopt_array($curl, array(
  CURLOPT_URL => 'https://baseurl/product',
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => '',
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 0,
  CURLOPT_FOLLOWLOCATION => true,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => 'POST',
  CURLOPT_POSTFIELDS =>'{"id":"21161"}',
  CURLOPT_HTTPHEADER => array(
    'Content-Type: application/json',
    'x-api-key: APIKEY'
  ),
));
$response = curl_exec($curl);
curl_close($curl);
echo $response;
Result handling

Query success or failure is defined in the boolean response field "ok". Response data and error descriptions are available in the field "data".

Successful response with results:
{"timestamp":"2023-10-13T10:00:35.133","ok":true,"query":"customer","row_count":1,"data":[{"customer_code":"1234","main_customer_code":"1234","receiving_customer_code":"1234","last_update":"2023-10-06T10:35:56.177","name":"TEST OÜ","reg_code":"1234568","vat_in_use":1,"vat_no":"EE1234567","is_private_person":0,"is_customer":1,"is_supplier":0,"is_producer":0,"is_transporter":0,"is_owner":0,"phone":"555555555","address1":"Mustamäe tee 46","address2":"Harjumaa","address3":"Tallinn","postcode":"10612","country":"EE","language":"","email":"info@kma.ee","currency":"EUR","ref_no":"0","old":0,"rowno":1}]}

Successful response with no results:
{"timestamp":"2023-10-13T09:54:22.303","ok":true,"query":"customer","row_count":0}

Unsuccessful request:
{"timestamp":"2023-10-13T09:56:54.410","ok":false,"query":"customer","data":{"message":"Technical error occurred"}}

Data output requests

API requests serve data from Ladu20 by predefined filterable POST requests. Filter parameters are defined per request and are not mandatory.

Currently the following standard outputs are available:

  • Customer data
  • Product data
  • Stocklevels
  • Order
  • Dispatch
  • Invoice

Customer data

URL: BASEURL/customer

Returns customer data from Ladu20 database. Ladu20 defines customers as one collection of data with several statuses. The latter means the customer cards for suppliers, customers, producers etc are the same data unit, with several statuses defining the customer state (eg is_supplier=1 means that the customer is also regarded a supplier in Ladu20).

Filter parameters
PARAMETER NAME TYPE DESCRIPTION Default value
last_update string returns data which is update later than the timestamp;
format: 2023-10-11T00:00:00
last 240 hours
old bool returns results marked as old in Ladu20; false
id string customer id in Ladu20  
page int Range 1-n 1
rowcount int Range 1-1000 300
Sample request data

'{"last_update":"2023-10-11T00:00:00","rowcount":2,"page":1}'

Response data
FIELD NAME TYPE DESCRIPTION
customer_code int  
main_customer_code int payer customer code
receiving_customer_code int  
last_update date format: 2023-10-11T00:00:00, created date
name string  
reg_code string  
vat_in_use int  
vat_no string  
is_private_person boolean  
customer boolean customer status
supplier boolean customer status
producer boolean customer status
transporter boolean customer status
owner string  
info string  
phone string  
address1 string street
address2 string city
address3 string county
postcode string  
country string  
language string  
email string  
currency decimal  
bank string bank name
bankaccount string  
ref_no int reference no
glncode int  
lat int latitude
long int longitude
credit_limit decimal  
debt_min_amount decimal  
debt_from int debt from days
owner_customer string  

Product data

URL: BASEURL/product

Returns product data from Ladu20 database. Ladu20 defines all product information with prices, replacements, parameters, lots, images and price agreements. In addition, the current state of the products, ordered and reserved quantities. 
The price of the goods ("price excluding VAT") is usually the main selling price. To classify products more easily, we have created groups of products. You can also add subgroups to item groups. For example product group1 no is 1 and, code V1 and description vegetables then under group1 and no 1 may be V12(apples), V13 (citrus) etc. 

Filter parameters
PARAMETER NAME TYPE DESCRIPTION Default value
last_update string returns data which is update later than the timestamp;
format: 2023-10-11T00:00:00
last 240 hours
old bool returns results marked as old in Ladu20; false
id string customer id in Ladu20  
page int Range 1-n 1
rowcount int Range 1-1000 300
group1 string    
group2 string    
group3 string    
group4 string    
Sample request data

'{"last_update":"2023-10-11T00:00:00","rowcount":10,"page":4}'

Response data
FIELD NAME TYPE DESCRIPTION
product_id int product code
product_code int siffer
barcode string  
product_name string  
baseunit string  
large_unit string  
large_unit_multiplier string  
aidunit string  
aidunit_multiplier string aidunits in one package
min_sales_qty decimal minimum quantity on sale
sales_qty_step decimal minimum quantity step on sale
is_expireable boolean product is expirable or not (1,0)
product_shelf_life string  
cn8 string cn8 code
coo string country of origin
min_temp string minimum temperature
max_temp string maximum temperature
stock_qty decimal stock quantity
ordered_qty decimal ordered quantity
reserved_qty decimal reserved quantity
netweight int  
brutweight int  
volume int  
price decimal  
vat int vat on sale
group1 boolean product qroup
group2 boolean product qroup
group3 boolean product qroup
group4 boolean product qroup
group5 boolean product qroup
last_update date format: 2023-10-11T00:00:00
web_groups/group_id int product webgroup id
web_groups/group_code int product group id
web_groups/group_name string product group name
flex_groups/group_id int product webgroup id
flex_groups/group_code int product group id
flex_groups/group_name string product group name

Stockbalance

URL: BASEURL/stockbalance

Returns stockbalance data from Ladu20 database. 

Filter parameters
PARAMETER NAME TYPE DESCRIPTION Default value
id int product id  
page int Range 1-n 1
rowcount string Range 1-1000 300
Sample request data

'{"last_update":"2023-10-11T00:00:00","rowcount":10,"page":4}'

Response data
FIELD NAME TYPE DESCRIPTION
product_id int  
product_code string  
stock_balance decimal  
ordered_amount decimal  
reserved_amount decimal  
product_id int  
rows/owner string  
rows/owner_stock_balance decimal  

Order

URL: BASEURL/order

Returns order data from Ladu20 database. 

Filter parameters
PARAMETER NAME TYPE DESCRIPTION Default value
start string date from, 
format: 2023-10-11T00:00:00
l
id int order id  
end date date until, format: 2023-10-11T00:00:00  
customer_id string customer code  
page int Range 1-n 1
rowcount int Range 1-1000 300
Sample request data

'{"last_update":"2023-10-11T00:00:00","rowcount":10,"page":4}'

Response data
FIELD NAME TYPE DESCRIPTION
customer_code int  
doc_no string order no
doc_date date order date, format: 2023-10-11T00:00:00
del_due date delivery date, format: 2023-10-11T00:00:00
status string order status
additional_info string  
inserter string  
dicount_per decimal discount percent
doc_no2 string customer order no
confirmed boolean  
currency decimal  
currency_rate decimal  
customer_date date format: 2023-10-11T00:00:00
pre_order boolean  
payer string payer customer
warning string  
xml_done boolean  
owner string  
customer string customer who placed the order
phone string customer phone no
country string customer country
picking_in_prog boolean picking in progress
payment_due date format: 2023-10-11T00:00:00
payment_type string cash, transfer etc
weborder_id int  
customer_name string customer contact who placed the order
doc_sum decimal  
recip_customer string recipient customer
original_quantity decimal  
quantity decimal  
price decimal  
baseprice decimal  

Dispatch

URL: BASEURL/dispatch

Returns order data from Ladu20 database. 

Filter parameters
PARAMETER NAME TYPE DESCRIPTION Default value
start string date from, 
format: 2023-10-11T00:00:00
l
id int dispatch id  
end date date until, format: 2023-10-11T00:00:00  
customer_id string customer code  
page int Range 1-n 1
rowcount int Range 1-1000 300
Sample request data

'{"last_update":"2023-10-11T00:00:00","rowcount":10,"page":4}'

Response data
FIELD NAME TYPE DESCRIPTION
dispatch_code int  
customer_id int  
dispatch_type_id string  
date date format: 2023-10-11T00:00:00
doc_no string dispatch document no
discount_per int discount percent
inserter string  
sum_net decimal  
sum_incl_vat decimal sum including vat
due string payment due
payer string payer customer
additional_info string  
currency decimal  
payment_type string cash, transfer etc
warehouse_aadress string  
account string bank account
country string  
rec_customer string recipient customer
needed_due date  
owner string  
ship_customer string  
tracking_no string  
paid decimal  
amount_of_boxes decimal  
product_id string  
batch int batch code
amount decimal  
discount_per int discount percent
price decimal product price
net_value int  
discount_price decimal  
base_price decimal  
brut_weight int  
set string set of products
account string bank account
row_amount decimal  
stockaddress string  
set_amount decimal how many products in set
pieces int  
warning string  
sales_id int saleorder id
pricelist_id int  
price_type string  
vat_sale string  
fix_net_value string  
warehouse_agent string warehouse agent name
added boolean dispatch added (1,0)
package_id string  
picker string warehouse agent who picked products
agent string agent on sale
base_code string  
batch_id int  
description string  
expiration_date date format: 2023-10-11T00:00:00

Invoice

URL: BASEURL/invoice

Returns invoice data from Ladu20 database. Invoices are accounting outputs from dispatches.

Filter parameters
PARAMETER NAME TYPE DESCRIPTION Default value
last_update string returns data which is update later than the timestamp;
format: 2023-10-11T00:00:00
last 240 hours
end date format: 2023-10-11T00:00:00  
customer_id string customer code  
id int invoice id  
page int Range 1-n 1
rowcount string Range 1-1000 300
Sample request data

'{"last_update":"2023-10-11T00:00:00","rowcount":10,"page":4}'

Response data
FIELD NAME TYPE DESCRIPTION
customer_code int  
invoice_date date invoice (document created) date
invoice_no string invoice number
total decimal total sum
paid decimal  
paid_date date format: 2023-10-11T00:00:00
fine_for_delay String  
deadline date format: 2023-10-11T00:00:00
paym_meth string payment method
printed boolean  
post_date date format: 2023-10-11T00:00:00
partial string partial payment
cred_invoice_no string credit invoice no
from_stock string sent out from stock
report_done boolean  
warning string  
owner string  
ref_no string reference no
add_info string additional information
prepaym_amount decimal  
prepaym_info string  
returned boolean  
product_id long  
batch long products batch
amount decimal  
discount_percent int %
price decimal  
net_value int  
discount_price decimal  
base_price decimal  
brut_weight int  
set string set of products
account string  
row_amount decimal  
stockaddress string  
set_amount decimal how many products in set
pieces int  
vat_sale boolean