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

# POST /V1.0/Opportunities/query

`POST /V1.0/Opportunities/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

- QueryActionResultOpportunityModelOpportunity
  - `items` OpportunityModel[]
    - `id` integer
    - `advancedField1` number, double
    - `advancedField2` number, double
    - `advancedField3` number, double
    - `advancedField4` number, double
    - `advancedField5` number, double
    - `amount` number, double
    - `assessmentScore` number, double
    - `barriers` string
    - `closedDate` string, date-time
    - `companyID` integer
    - `contactID` integer
    - `cost` number, double
    - `createDate` string, date-time
    - `creatorResourceID` integer
    - `description` string
    - `helpNeeded` string
    - `impersonatorCreatorResourceID` integer
    - `lastActivity` string, date-time
    - `leadSource` integer
    - `lossReason` integer
    - `lossReasonDetail` string
    - `lostDate` string, date-time
    - `market` string
    - `monthlyCost` number, double
    - `monthlyRevenue` number, double
    - `nextStep` string
    - `onetimeCost` number, double
    - `onetimeRevenue` number, double
    - `opportunityCategoryID` integer
    - `organizationalLevelAssociationID` integer
    - `ownerResourceID` integer
    - `primaryCompetitor` integer
    - `probability` integer
    - `productID` integer
    - `projectedCloseDate` string, date-time
    - `promisedFulfillmentDate` string, date-time
    - `promotionName` string
    - `quarterlyCost` number, double
    - `quarterlyRevenue` number, double
    - `rating` integer
    - `relationshipAssessmentScore` number, double
    - `revenueSpread` integer
    - `revenueSpreadUnit` string
    - `salesOrderID` integer
    - `salesProcessPercentComplete` number, double
    - `semiannualCost` number, double
    - `semiannualRevenue` number, double
    - `stage` integer
    - `startDate` string, date-time
    - `status` integer
    - `technicalAssessmentScore` number, double
    - `throughDate` string, date-time
    - `title` string
    - `totalAmountMonths` integer
    - `useQuoteTotals` boolean
    - `winReason` integer
    - `winReasonDetail` string
    - `yearlyCost` number, double
    - `yearlyRevenue` number, double
    - `userDefinedFields` UserDefinedField[]
      - `name` string
      - `value` string
  - `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/revisions/b5e89df4589e/schema)