--- title: "Analytics (Excel) (Deprecated)" method: GET path: "/v1/book/export/xlsx/analytics" tags: ["Legacy Cash Flow Analytics (Deprecated)"] deprecated: true --- # Analytics (Excel) (Deprecated) `GET /v1/book/export/xlsx/analytics` ## Request - Base URL: `https://api.ocrolus.com` - URL: `https://api.ocrolus.com/v1/book/export/xlsx/analytics` - Auth: OAuth 2 - Client credentials - Token URL: `https://auth.ocrolus.com/oauth/token` > **Deprecated.** Retrieves analytics for a <> in Excel-compatible XLSX format (not to be confused with the legacy XLS format). --- > 🚧 We have a better version! > This product was deprecated in December 2023 and has been superseded by our [new Analytics 2.0 offering](ref:book-summary), which we recommend for all new work. The output of this endpoint is intended for manual review, as opposed to automated consumption by your application. Some fields provided in the [JSON output](doc:analytics) are not listed in the XLSX output. This behavior may change in future revisions of this endpoint. > 📘 Multiple endpoints, one object > This endpoint returns the same information as the [JSON versions](ref:analytics), but in a different format. You can find a detailed reference of the JSON analytics object [here](doc:analytics-type), although it doesn't strictly apply to the file returned by this endpoint. > 🚧 > The response will have a MIME type of `application/vnd.openxmlformats-officedocument.spreadsheetml.sheet`, hence there is no JSON response schema. See [here](https://docs.google.com/spreadsheets/d/1tCjC3ZmmGWyZnF18YMfhOVFBnt_MZ_58) for an example output. ## Query parameters - `pk` integer: The <> of the <> that contains the bank statements you'd like to have analyzed. ## Response `200` Success ## Other responses - `400`: Client Errors --- [API](https://skmtc.dev/ocrolus/apis/analyze.md) - [All operations](https://skmtc.dev/ocrolus/apis/analyze/llms.txt) - [OpenAPI document](https://skmtc.dev/ocrolus/apis/analyze/revisions/4ef40f224ab5?raw)