Download Stock Report

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 for
  • area: id of area to filter for
  • status: item status to filter for
  • search_term: search term to match items against
  • supplier: id of supplier to filter for
  • category: id of product group to filter for
  • offset: starting offset for pagination - default value is 0
  • limit: maximum number of items on one page - default value is 25
  • 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.