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 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:

ReportsBeverageSalesAccountsResponseDto

{"vats": [{
    "isDefault": true,
    "code": "code",
    "vat": 1975.753707751947,
    "description": "description",
    "id": 4911,
    "account": 2903
}]}

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:

DataChartResponseDto

{}

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	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:

ArticlesForStockCountChangeResponseDto

{
    "pages": 1975,
    "pageSize": 2863,
    "page": 4286,
    "articlesCount": 1288,
    "articles": [{}]
}

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:

ReportsCustomerOrderSummariesResponseDto

{"stats": [{
    "date": 3785,
    "orderAmount": 5089.8960222407395,
    "orderProducts": 1072.929238181588,
    "orderValue": 1312.5661820465161
}]}

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:

ReportsCustomersResponseDto

{"stats": [{
    "customerId": 4441,
    "orderValue": 3754.371587610945,
    "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:

ReportsStockWorthResponseDto

{"stats": [{
    "stockValue": 8668.50076968769,
    "date": 5709,
    "stockValueFIFO": 4345.905217166161
}]}

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:

ReportsOrdersResponseDto

{
    "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:

ReportsCustomerOrdersResponseDto

{"stats": [{
    "orderCreated": 2781,
    "articleName": "articleName",
    "articleValue": 6885.043472386634,
    "orderId": 1679,
    "orderDisplayId": "orderDisplayId",
    "articleAmount": 507.5571463336692,
    "articleDiscount": 8765.96487211843,
    "articleId": "articleId",
    "orderValue": 4977.720209740874,
    "articleDiscountType": "articleDiscountType",
    "customerName": "customerName",
    "orderState": "orderState",
    "customerId": 9903,
    "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:

ReportsCustomersResponseDto

{"stats": [{
    "customerId": 8275,
    "orderValue": 6310.041975861813,
    "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:

ReportsArticlesResponseDto

{"stats": [{
    "amount": 5219.434904557321,
    "articleName": "articleName",
    "articleId": "articleId",
    "value": 8338.220059699657
}]}

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:

ReportsArticlesResponseDto

{"stats": [{
    "amount": 107.58450604677172,
    "articleName": "articleName",
    "articleId": "articleId",
    "value": 1428.3239918717861
}]}

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:

ReportsAccountsResponseDto

{"stats": [{
    "value": 2657.4101704791665,
    "account": "account"
}]}

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:

ReportsArticleStockStatesResponseDto

{"states": [{
    "stockAmount": 3429.7444825758616,
    "date": 6632,
    "incoming": 5327.473637568426,
    "outgoing": 1985.6457904587721,
    "articleId": "articleId"
}]}

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:

ReportsBeverageStatisticsResponseDto

{
    "pages": 5391,
    "stats": [{}],
    "pageSize": 5439,
    "page": 6236,
    "articlesCount": 1332
}

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:

ReportsCustomerOrderArticlesResponseDto

{"articles": [{
    "deliveredDate": 7364,
    "ordered": 9242.370050376916,
    "orderId": 151,
    "articleId": "articleId",
    "externalOrderId": "externalOrderId",
    "deliveryDate": 253,
    "orderDate": 2977
}]}

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:

ReportsBeverageSalesAccountsResponseDto

{"vats": [{
    "isDefault": true,
    "code": "code",
    "vat": 9101.675728659666,
    "description": "description",
    "id": 8470,
    "account": 6403
}]}

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:

ReportsAlcoholicSummaryDto

{
    "totalVolume": 2438.598732067444,
    "taxCostVolume": 663.7450228048947
}

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:

ReportsTobaccoStatisticsResponseDto

{
    "pages": 2034,
    "stats": [{}],
    "pageSize": 2053,
    "page": 5683,
    "articlesCount": 2986
}

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:

ReportsBeverageSalesAccountsResponseDto

{"vats": [{
    "isDefault": true,
    "code": "code",
    "vat": 74.31897574059931,
    "description": "description",
    "id": 3583,
    "account": 5117
}]}

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:

TopArticle

{}

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:

CategoryRateDto

{}

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:

DataChartResponseDto

{}

Get stock count fixed

GETUrl: /stock_count_fixed

Headers:

Accept: application/json or application/xml

Get a list of articles where stock has not changed during a specified period

Valid parameters:

Parameter	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:

ArticlesForStockCountChangeResponseDto

{
    "pages": 1942,
    "pageSize": 5299,
    "page": 7130,
    "articlesCount": 4527,
    "articles": [{}]
}

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:

DataChartResponseDto

{}

Classes:

ArticlesForStockCountChangeResponseDto

Field	Type	Access
page	int	R
pages	int	R
pageSize	int	R
articlesCount	int	R
articles	List	R

ReportsAccountDto

Field	Type	Description	Default	Mandatory	Accepted values	Example values	Access
account	String						R
value	double						R

ReportsAccountsResponseDto

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

ReportsAlcoholicSummaryDto

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

ReportsArticleDto

Field	Type	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	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	Access
page	int	R
pages	int	R
pageSize	int	R
articlesCount	int	R
stats	List	R

ReportsCustomerDto

Field	Type	Access
customerId	Long	R
customerName	String	R
orderValue	Double	R

ReportsCustomerOrderArticleDto

Field	Type	Access
articleId	String	R
ordered	double	R
orderId	long	R
externalOrderId	String	R
orderDate	Long	R
deliveryDate	Long	R
deliveredDate	Long	R

ReportsCustomerOrderArticlesResponseDto

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

ReportsCustomerOrderDto

Field	Type	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	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	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	Access
page	int	R
pages	int	R
pageSize	int	R
articlesCount	int	R
stats	List	R

VATDto

Field	Type	Description	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