---
title: "Create xlsx file including journal lines"
method: GET
path: "/v1/Journals/{journalId}/lines/xlsx"
tags: ["Journals"]
---

# Create xlsx file including journal lines

`GET /v1/Journals/{journalId}/lines/xlsx`

## Path parameters

- `journalId` integer, required

## Query parameters

- `Account` unknown

## Response `200`

Success

- JournalLineResponsePagedResult
  - `pageSize` integer
  - `page` integer
  - `totalCount` integer
  - `filteredCount` integer
  - `data` JournalLineResponse[], nullable
    - `id` integer
    - `journalId` integer
    - `operationId` integer, nullable
    - `journalType` 0 | 1
    - `itemId` integer
    - `itemCode` string, nullable
    - `itemName` string, nullable
    - `transDate` string, date-time
    - `quantity` number, double
    - `qtyOnHand` number, double
    - `qtyConfirmed` number, double
    - `inventDim` InventDimResponse
      - `id` integer
      - `locationId` integer, nullable
      - `locationName` string, nullable
      - `wmsLocationId` string, nullable
      - `batchId` string, nullable

## Other responses

- `204` — No Content
- `400` — Bad Request
- `401` — Unauthorized
- `403` — Forbidden

---

[API](https://skmtc.net/invendor/apis/io-commonapi.md) · [All operations](https://skmtc.net/invendor/apis/io-commonapi/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/invendor/io-commonapi/revisions/0e4626e69155/schema)