---
title: "POST /V1.0/ExpenseReports/query"
method: POST
path: "/V1.0/ExpenseReports/query"
tags: ["ExpenseReports"]
---

# POST /V1.0/ExpenseReports/query

`POST /V1.0/ExpenseReports/query`

## Headers

- `ApiIntegrationCode` string, required
- `UserName` string, required
- `Secret` string, required
- `ImpersonationResourceId` string

## Request body

- QueryModel
  - `maxRecords` integer
  - `includeFields` string[]
  - `filter` Filter[]
    - `op` string
    - `field` string
    - `udf` boolean
    - `value` object — Can be either an Integer, String, Boolean, an Array of Integers, or an Array of Strings.
    - `items` Filter[] — An Array of Filter objects

## Response `200`

OK

- QueryActionResultExpenseReportModelExpenseReport
  - `items` ExpenseReportModel[]
    - `id` integer
    - `amountDue` number, double
    - `approvedDate` string, date-time
    - `approverID` integer
    - `departmentNumber` string
    - `internalCurrencyCashAdvanceAmount` number, double
    - `internalCurrencyExpenseTotal` number, double
    - `name` string
    - `organizationalLevelAssociationID` integer
    - `quickBooksReferenceNumber` string
    - `reimbursementCurrencyAmountDue` number, double
    - `reimbursementCurrencyCashAdvanceAmount` number, double
    - `reimbursementCurrencyID` integer
    - `rejectionReason` string
    - `status` integer
    - `submit` boolean
    - `submitDate` string, date-time
    - `submitterID` integer
    - `weekEnding` string, date-time
  - `pageDetails` PagingModel
    - `count` integer
    - `requestCount` integer
    - `prevPageUrl` string
    - `nextPageUrl` string

## Other responses

- `401` — Unauthorized
- `403` — Forbidden

---

[API](https://skmtc.net/autotask/apis/datto-autotask-psa-rest-api.md) · [All operations](https://skmtc.net/autotask/apis/datto-autotask-psa-rest-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/autotask/datto-autotask-psa-rest-api/versions/b5e89df4589e/schema)