Goto APIs

Reports API

General:

Basics:

Base-URL: https://capi.lagerkoll.com/v1/reports/
Parameters in the url should all be encoded and all data sent should be UTF-8

MAX number of requests per minute is set to 200.
When the limit is hit an error with code 429 is returned, with the header "Retry-After" containing the number of seconds you have to wait for your next request.

Headers:

There are 2 ways to be authenticated when using this API. in both ways you add headers to the request.
1) Use an API-key together with store-id. This would be used when communicating machine to machine and no real person is involved. The API-key is available from where you activated the API. The store-id is also available in the same place.
2) Use a user_id and user_token together with a store-id. You get these values from the login-request. The values are connected to a person and are gained when an actual login to the system has been made.
store: <<STORE>>
user_id: <<USER_ID>>
user_token: <<USER_TOKEN>>
api_key: <<API_KEY>>
Accept: application/json
Content-Type: application/json

Errors:

Code Description
900001 Credentials don't match
900101 Common error
900429 Too many requests
904001 Error when getting report data
{
  "errorCode" : 900101,
  "errorMessage" : "Something went wrong on the server",
  "errorField" : null,
  "errorData" : null
}

Reports API:

Reports

Get customer orders

GETUrl: /customerorders
Headers:
Accept: application/json or application/xml
Get customer orders data for report

Valid parameters:

Parameter Description Default value Allowed values
days 30
end_date

Body:
Successfull response:

{"stats": [{ "date": 4212, "orderAmount": 9857.422117655602, "orderProducts": 1267.2932253070578, "orderValue": 1799.056912176331 }]}

Get summary alcoholic beverage

GETUrl: /alcoholic_beverage/summary
Headers:
Accept: application/json or application/xml
Get summary of volume, tax cost for volume for alcoholic beverage statistics during chosen period

Valid parameters:

Parameter Description Default value Allowed values
start_date
end_date
account -1

Body:
Successfull response:

{ "totalVolume": 4678.71826723853, "taxCostVolume": 7248.355156936236 }

Get summary for tobacco and nicotine

GETUrl: /tobacco/summary
Headers:
Accept: application/json or application/xml
Get summary of weight, volume, tax cost for weight and tax cost for volume for tobacco and nicotine statistics during chosen period

Valid parameters:

Parameter Description Default value Allowed values
include_tobacco true
include_nicotine true
start_date
end_date
tag
account -1

Body:
Successfull response:

{"vats": [{ "isDefault": false, "code": "code", "vat": 1381.4755855554051, "description": "description", "id": 3142, "account": 9379 }]}

Get articles stock state

GETUrl: /articles_stockstate
Headers:
Accept: application/json or application/xml
Get articles stock state data for report

Valid parameters:

Parameter Description Default value Allowed values
article_id
end_date

Body:
Successfull response:

{"states": [{ "stockAmount": 1570.7926795097171, "date": 1746, "incoming": 7960.01223798659, "outgoing": 9927.986164987884, "articleId": "articleId" }]}

Get customers

GETUrl: /customers
Headers:
Accept: application/json or application/xml
Get customers data for report

Valid parameters:

Parameter Description Default value Allowed values
days 30
end_date
max_customers 10

Body:
Successfull response:

{"stats": [{ "customerId": 7113, "orderValue": 1727.8197614599821, "customerName": "customerName" }]}

Get stockworth

GETUrl: /stockworth
Headers:
Accept: application/json or application/xml
Get stockworth data for report

Valid parameters:

Parameter Description Default value Allowed values
days 30
end_date

Body:
Successfull response:

{"stats": [{ "stockValue": 7809.264805002329, "date": 7439, "stockValueFIFO": 2725.9196175469733 }]}

Get orders for article

GETUrl: /orders/{id : .+}
Headers:
Accept: application/json or application/xml
Get customer and purchase orders data for article for report

Valid parameters:

Parameter Description Default value Allowed values
end_date

Body:
Successfull response:

{ "customerOrders": [{}], "purchaseOrders": [{}] }

Get customer orders for article

GETUrl: /customerorders/{id : .+}
Headers:
Accept: application/json or application/xml
Get customer orders data for article for report

Valid parameters:

Parameter Description Default value Allowed values
batch
serialnumber
days 30
end_date

Body:
Successfull response:

{"stats": [{ "orderCreated": 4235, "articleName": "articleName", "articleValue": 69.96653635464867, "orderId": 2147, "orderDisplayId": "orderDisplayId", "articleAmount": 1614.27602945596, "articleDiscount": 842.626600474553, "articleId": "articleId", "orderValue": 1493.3418116757136, "articleDiscountType": "articleDiscountType", "customerName": "customerName", "orderState": "orderState", "customerId": 4, "customerDisplayId": "customerDisplayId" }]}

Get customers for article

GETUrl: /customers_for_article/{id : .+}
Headers:
Accept: application/json or application/xml
Get customers data for article for report

Valid parameters:

Parameter Description Default value Allowed values
start
end
batch_id
serial_nr
delivered true
not_delivered true

Body:
Successfull response:

{"stats": [{ "customerId": 4199, "orderValue": 8262.317428911596, "customerName": "customerName" }]}

Get customer products

GETUrl: /customers/{customer_id}/products
Headers:
Accept: application/json or application/xml
Get customer products data for report

Valid parameters:

Parameter Description Default value Allowed values
days 30
end_date

Body:
Successfull response:

{"stats": [{ "amount": 734.2719766129846, "articleName": "articleName", "articleId": "articleId", "value": 4103.691135457874 }]}

Get articles most sold

GETUrl: /articles_most_sold
Headers:
Accept: application/json or application/xml
Get articles most sold data for report

Valid parameters:

Parameter Description Default value Allowed values
days 30
end_date
max_articles 10
type amount

Body:
Successfull response:

{"stats": [{ "amount": 5055.875030234942, "articleName": "articleName", "articleId": "articleId", "value": 7379.206532711797 }]}

Get articles per account

GETUrl: /articles_per_account
Headers:
Accept: application/json or application/xml
Get articles data sold per account for report

Valid parameters:

Parameter Description Default value Allowed values
days 30
end_date
max_accounts 0

Body:
Successfull response:

{"stats": [{ "amount": 1671.1766164976782, "articleName": "articleName", "articleId": "articleId", "value": 1470.9130511560554 }]}

Get ordered articles

GETUrl: /ordered_articles
Headers:
Accept: application/json or application/xml
Get last ordered articles data for article for report
Body:
Successfull response:

{ "customerOrders": [{}], "purchaseOrders": [{}] }

Get alcoholic beverage statistics

GETUrl: /alcoholic_beverage
Headers:
Accept: application/json or application/xml
Get alcoholic beverage statistics for chosen period

Valid parameters:

Parameter Description Default value Allowed values
page 0
limit 50
start_date
end_date
account -1

Body:
Successfull response:

{ "pages": 2991, "stats": [{}], "pageSize": 5845, "page": 5731, "articlesCount": 1036 }

Get alcoholic beverage sales accounts

GETUrl: /alcoholic_beverage_sales_account
Headers:
Accept: application/json or application/xml
Get sales accounts for alcoholic beverage statistics for chosen period

Valid parameters:

Parameter Description Default value Allowed values
start_date
end_date

Body:
Successfull response:

{"vats": [{ "isDefault": true, "code": "code", "vat": 650.9396944514401, "description": "description", "id": 6157, "account": 6175 }]}

Get tobacco and nicotine statistics

GETUrl: /tobacco
Headers:
Accept: application/json or application/xml
Get tobacco and nicotine statistics for chosen period

Valid parameters:

Parameter Description Default value Allowed values
page 0
limit 50
include_tobacco true
include_nicotine true
start_date
end_date
tag
account -1

Body:
Successfull response:

{ "pages": 7603, "stats": [{}], "pageSize": 7341, "page": 5990, "articlesCount": 8124 }

Get tobacco and nicotine sales accounts

GETUrl: /tobacco_sales_account
Headers:
Accept: application/json or application/xml
Get sales accounts for tobacco and nicotine statistics for chosen period

Valid parameters:

Parameter Description Default value Allowed values
include_tobacco true
include_nicotine true
start_date
end_date
tag

Body:
Successfull response:

{"vats": [{ "isDefault": false, "code": "code", "vat": 1736.9298957418944, "description": "description", "id": 3410, "account": 882 }]}

Get bestseller article

GETUrl: /category/{id}/bestseller_article
Headers:
Accept: application/json or application/xml
Get the bestseller article of a category

Valid parameters:

Parameter Description Default value Allowed values
start
end

Body:
Successfull response:

Get category rate

GETUrl: /category/{id}/category_rate
Headers:
Accept: application/json or application/xml
Get the rate of a category

Valid parameters:

Parameter Description Default value Allowed values
start
end

Body:
Successfull response:

Get articles to chart

GETUrl: /category/{id}/articles_chart
Headers:
Accept: application/json or application/xml
Get a list of articles for a category to display in the chart. If an article is missing value for specific day it means it has a value of 0

Valid parameters:

Parameter Description Default value Allowed values
start
end
limiter quarter

Body:
Successfull response:

Get stock count change

GETUrl: /stock_count_change
Headers:
Accept: application/json or application/xml
Get a list of articles where stock has changed during a specified period

Valid parameters:

Parameter Description Default value Allowed values
start_date
end_date
page 0
limit 25
order desc asc,desc
sort_column article_id article_id,name,category,count,in_delivery,out_delivery

Body:
Successfull response:

{ "pages": 616, "pageSize": 7601, "page": 407, "articlesCount": 3237, "articles": [{}] }

Get annual sales to category chart

GETUrl: /category/{id}/category_chart
Headers:
Accept: application/json or application/xml
Get a list of annual sales to display in the chart. If a category is missing value for specific year it means it has a value of 0

Valid parameters:

Parameter Description Default value Allowed values
start
end
limiter quarter

Body:
Successfull response:

Get sales to categories chart

GETUrl: /categories_chart
Headers:
Accept: application/json or application/xml
Get a list of sales to display in the chart. If a category is missing value for specific day, week, month, quarter or year it means it has a value of 0

Valid parameters:

Parameter Description Default value Allowed values
start
end
limiter quarter

Body:
Successfull response:

Classes:

ArticlesForStockCountChangeResponseDto

Field Type Description Default Mandatory Accepted values Example values Access
page int R
pages int R
pageSize int R
articlesCount int R
articles List R

ReportsAlcoholicSummaryDto

Field Type Description Default Mandatory Accepted values Example values Access
totalVolume double R
taxCostVolume double R

ReportsArticleDto

Field Type Description Default Mandatory Accepted values Example values Access
articleId String R
articleName String R
amount double R
value double R

ReportsArticlesResponseDto

Field Type Description Default Mandatory Accepted values Example values Access
stats List R

ReportsArticleStockStateDto

Field Type Description Default Mandatory Accepted values Example values Access
articleId String R
stockAmount double R
incoming double R
outgoing double R
date long R

ReportsArticleStockStatesResponseDto

Field Type Description Default Mandatory Accepted values Example values Access
states List R

ReportsBeverageSalesAccountsResponseDto

Field Type Description Default Mandatory Accepted values Example values Access
vats List R

ReportsBeverageStatisticsResponseDto

Field Type Description Default Mandatory Accepted values Example values Access
page int R
pages int R
pageSize int R
articlesCount int R
stats List R

ReportsCustomerDto

Field Type Description Default Mandatory Accepted values Example values Access
customerId Long R
customerName String R
orderValue Double R

ReportsCustomerOrderDto

Field Type Description Default Mandatory Accepted values Example values Access
orderId Long R
orderDisplayId String R
orderCreated Long R
orderValue Double R
orderState String R
articleId String R
articleName String R
articleAmount Double R
articleValue Double R
articleDiscount Double R
articleDiscountType String R
customerId Long R
customerDisplayId String R
customerName String R

ReportsCustomerOrdersResponseDto

Field Type Description Default Mandatory Accepted values Example values Access
stats List R

ReportsCustomerOrderSummariesResponseDto

Field Type Description Default Mandatory Accepted values Example values Access
stats List R

ReportsCustomerOrderSummaryDto

Field Type Description Default Mandatory Accepted values Example values Access
orderValue Double R
orderAmount Double R
orderProducts Double R
date Long R

ReportsCustomersResponseDto

Field Type Description Default Mandatory Accepted values Example values Access
stats List R

ReportsOrdersResponseDto

Field Type Description Default Mandatory Accepted values Example values Access
customerOrders List R
purchaseOrders List R

ReportsStockWorthDto

Field Type Description Default Mandatory Accepted values Example values Access
stockValue Double R
stockValueFIFO Double R
date Long R

ReportsStockWorthResponseDto

Field Type Description Default Mandatory Accepted values Example values Access
stats List R

ReportsTobaccoStatisticsResponseDto

Field Type Description Default Mandatory Accepted values Example values Access
page int R
pages int R
pageSize int R
articlesCount int R
stats List R

VATDto

Field Type Description Default Mandatory Accepted values Example values Access
id long R
vat double VAT value in percentage R
account int sales account R
code String vat code R
description String description of vat R
isDefault Boolean default vat R