reporting

Get Open Items Xlsx

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.

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

Path parameters

company_idstring required

Query parameters

directionstring required
as_ofstring date nullable
statusstring nullable

Headers

authorizationstring nullable

Cookies

access_tokenstring nullable

Response

Successful Response

unknown required

Changes

No recorded changes to this operation across all 1 revision of this API.