GET /reports/stock/download
You can download the stock report as an excel file.
Parameters
All query parameters are optional.
division
: id of division (location) to filter forarea
: id of area to filter forstatus
: item status to filter forsearch_term
: search term to match items againstsupplier
: id of supplier to filter forcategory
: id of product group to filter foroffset
: starting offset for pagination - default value is0
limit
: maximum number of items on one page - default value is25
group_by
: Defines how the items in the report should be grouped. One of"category"
or"account_code"
lang
: The language of the report excel. One of"en"
or"de"
timezone_offset
: the local time zone offset for the client. In order to have the dates and times shown in the downloaded report correctly, this should be sent. Otherwise it defaults to 0 and represents all dates and times in UTC.
Status codes
200
on success
Response properties
The response is a download url for the generated xlsx report.
url
: The URL where the report can be accessed.
Example response:
{
"url": "https://s3.eu-central-1.amazonaws.com/exports.yourbarmate.com/c6a61b00-178f-4604-a51b-927cb9b4e302/stock-report-1730205514020.xlsx"
}
The report is generated fresh every time you request it.