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.
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.
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 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": 8561.409796318787, "date": 6403, "incoming": 4220.056636764284, "outgoing": 4627.72596035857, "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": 4880, "orderValue": 7992.491456044581, "customerName": "customerName" }]}
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": 5486, "orderAmount": 5171.232040950426, "orderProducts": 6636.868797163238, "orderValue": 4693.27905844836 }]}
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": 2294.2231354832234, "taxCostVolume": 9202.273600114842 }
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 |
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": 7727.517732263044, "articleName": "articleName", "articleId": "articleId", "value": 5237.282492677614 }]}
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 |
Get ordered articles
GETUrl: /ordered_articles
Headers:
Accept: application/json or application/xml
Get last ordered articles data for article for report
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": 8183, "stats": [{}], "pageSize": 2412, "page": 9232, "articlesCount": 4011 }
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": 5146, "stats": [{}], "pageSize": 5098, "page": 2578, "articlesCount": 4844 }
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 |
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 |
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 |
Get articles to chart
GETUrl: /category/{id}/articles_chart
Headers:
Accept: application/json or application/xml
Get a list of articles 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 |
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 |
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 |
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": 7700, "orderValue": 7046.163839164143, "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": 2835.5161577099543, "articleName": "articleName", "articleId": "articleId", "value": 637.4137959541005 }]}
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": 1938.9170576112947, "articleName": "articleName", "articleId": "articleId", "value": 7412.724916501305 }]}
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": 7545.092822138897, "date": 6444, "stockValueFIFO": 5910.591358990053 }]}
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 |
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": 2996, "articleName": "articleName", "articleValue": 6594.982510676175, "orderId": 14, "orderDisplayId": "orderDisplayId", "articleAmount": 6881.903216759354, "articleDiscount": 2325.874253862069, "articleId": "articleId", "orderValue": 2040.9176323714362, "articleDiscountType": "articleDiscountType", "customerName": "customerName", "orderState": "orderState", "customerId": 9374, "customerDisplayId": "customerDisplayId" }]}
Classes:
ReportsAlcoholicSummary
Field | Type | Description | Default | Mandatory | Accepted values | Example values | Access |
---|---|---|---|---|---|---|---|
totalVolume | double | R | |||||
taxCostVolume | double | R |
ReportsArticle
Field | Type | Description | Default | Mandatory | Accepted values | Example values | Access |
---|---|---|---|---|---|---|---|
articleId | String | R | |||||
articleName | String | R | |||||
amount | double | R | |||||
value | double | R |
ReportsArticlesResponse
Field | Type | Description | Default | Mandatory | Accepted values | Example values | Access |
---|---|---|---|---|---|---|---|
stats | List | R |
ReportsArticleStockState
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 |
ReportsArticleStockStatesResponse
Field | Type | Description | Default | Mandatory | Accepted values | Example values | Access |
---|---|---|---|---|---|---|---|
states | List | R |
ReportsBeverageSalesAccountsResponse
Field | Type | Description | Default | Mandatory | Accepted values | Example values | Access |
---|---|---|---|---|---|---|---|
vats | List | R |
ReportsBeverageStatisticsResponse
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 |
ReportsCustomer
Field | Type | Description | Default | Mandatory | Accepted values | Example values | Access |
---|---|---|---|---|---|---|---|
customerId | Long | R | |||||
customerName | String | R | |||||
orderValue | Double | R |
ReportsCustomerOrder
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 |
ReportsCustomerOrdersResponse
Field | Type | Description | Default | Mandatory | Accepted values | Example values | Access |
---|---|---|---|---|---|---|---|
stats | List | R |
ReportsCustomerOrderSummariesResponse
Field | Type | Description | Default | Mandatory | Accepted values | Example values | Access |
---|---|---|---|---|---|---|---|
stats | List | R |
ReportsCustomerOrderSummary
Field | Type | Description | Default | Mandatory | Accepted values | Example values | Access |
---|---|---|---|---|---|---|---|
orderValue | Double | R | |||||
orderAmount | Double | R | |||||
orderProducts | Double | R | |||||
date | Long | R |
ReportsCustomersResponse
Field | Type | Description | Default | Mandatory | Accepted values | Example values | Access |
---|---|---|---|---|---|---|---|
stats | List | R |
ReportsOrdersResponse
Field | Type | Description | Default | Mandatory | Accepted values | Example values | Access |
---|---|---|---|---|---|---|---|
customerOrders | List | R | |||||
purchaseOrders | List | R |
ReportsStockWorth
Field | Type | Description | Default | Mandatory | Accepted values | Example values | Access |
---|---|---|---|---|---|---|---|
stockValue | Double | R | |||||
stockValueFIFO | Double | R | |||||
date | Long | R |
ReportsStockWorthResponse
Field | Type | Description | Default | Mandatory | Accepted values | Example values | Access |
---|---|---|---|---|---|---|---|
stats | List | R |
ReportsTobaccoStatisticsResponse
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 |