---
title: "Get Open Items Xlsx"
method: GET
path: "/companies/{company_id}/open-items.xlsx"
tags: ["reporting"]
---

# Get Open Items Xlsx

`GET /companies/{company_id}/open-items.xlsx`

## Request

- Base URL: `https://app.zeno-works.ch` (the document declares no server; this is the origin it was published from)
- URL: `https://app.zeno-works.ch/companies/{company_id}/open-items.xlsx`
- Auth: none declared

The Offene-Posten-Liste for one direction as an ``.xlsx`` (CompanyMember).

One file per direction: AR and AP are different lists with different readers, and a
workbook holding both would open on one of them.

``as_of`` omitted → today's cached open amounts; set → a historical reconstruction from
posted journal lines dated ``<= as_of``, which considers items **regardless of their
current status** (an item settled since that date was open then, and shows).

Every item of the direction is included — the list is not paged — up to
:data:`MAX_EXPORT_ROWS`, beyond which the request is refused rather than truncated.

``status`` (ZEN-4) narrows to the screen's status filter and the sheet says so; it is
refused alongside ``as_of`` exactly as the list route refuses it.

## Path parameters

- `company_id` string, required

## Query parameters

- `direction` string, required
- `as_of` string, date, nullable
- `status` string, nullable

## Headers

- `authorization` string, nullable

## Cookies

- `access_token` string, nullable

## Response `200`

Successful Response

- unknown

## Other responses

- `422`: Validation Error

---

[API](https://skmtc.dev/zeno-works/apis/zeno-api.md) · [All operations](https://skmtc.dev/zeno-works/apis/zeno-api/llms.txt) · [OpenAPI document](https://skmtc.dev/zeno-works/apis/zeno-api/revisions/1eb93dde146c?raw)