---
title: "OpportunitiesById (Autotask)"
description: "itgen_autotask_opportunitiesbyid_plural"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/autotask/Autotask.Opportunities.OpportunitiesById
original: https://documentation.invantive.eu/en/datamodels/autotask/Autotask.Opportunities.OpportunitiesById
updated: 2024-06-10T18:39:25Z
license: https://documentation.invantive.eu/en/
---

# OpportunitiesById: Autotask itgen_autotask_opportunitiesbyid_plural

`read only` `REST`

- Catalog: `Autotask`
- Schema: `Opportunities`
- Label: itgen_autotask_opportunitiesbyid_plural

Can only retrieve data.

## API Source

- Endpoint: `/V1.0/Opportunities/{id}`
- Operation: `get /V1.0/Opportunities/{id}`

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `id` | `` | [x] |  |  |

## Table Columns

The columns of the table `OpportunitiesById` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `advancedField1` | `double` | Advanced Field 1 | [ ] |  |  |
| `advancedField2` | `double` | Advanced Field 2 | [ ] |  |  |
| `advancedField3` | `double` | Advanced Field 3 | [ ] |  |  |
| `advancedField4` | `double` | Advanced Field 4 | [ ] |  |  |
| `advancedField5` | `double` | Advanced Field 5 | [ ] |  |  |
| `amount` | `double` | Amount | [ ] |  |  |
| `assessmentScore` | `double` | Assessment Score | [ ] |  |  |
| `barriers` | `varchar2` | Barriers | [ ] |  |  |
| `closedDate` | `datetime` | Closed Date | [ ] |  |  |
| `companyID` | `int32` | Company ID | [ ] |  |  |
| `contactID` | `int32` | Contact ID | [ ] |  |  |
| `cost` | `double` | Cost | [ ] |  |  |
| `createDate` | `datetime` | Created | [ ] |  |  |
| `creatorResourceID` | `int32` | Creator Resource ID | [ ] |  |  |
| `description` | `varchar2` | Description | [ ] |  |  |
| `helpNeeded` | `varchar2` | Help Needed | [ ] |  |  |
| `id` | `int64` | ID | [ ] |  |  |
| `impersonatorCreatorResourceID` | `int32` | Imperonsator Creator Resource ID | [ ] |  |  |
| `lastActivity` | `datetime` | Last Activity | [ ] |  |  |
| `leadSource` | `int32` | Lead Source | [ ] |  |  |
| `lossReason` | `int32` | Loss Reason | [ ] |  |  |
| `lossReasonDetail` | `varchar2` | Loss Reason Detail | [ ] |  |  |
| `lostDate` | `datetime` | Lost Date | [ ] |  |  |
| `market` | `varchar2` | Market | [ ] |  |  |
| `monthlyCost` | `double` | Monthly Cost | [ ] |  |  |
| `monthlyRevenue` | `double` | Monthly Revenue | [ ] |  |  |
| `nextStep` | `varchar2` | Next Step | [ ] |  |  |
| `onetimeCost` | `double` | One-time Cost | [ ] |  |  |
| `onetimeRevenue` | `double` | One-time Revenue | [ ] |  |  |
| `opportunityCategoryID` | `int32` | Opportunity Category ID | [ ] |  |  |
| `organizationalLevelAssociationID` | `int32` | Organisational Level Association ID | [ ] |  |  |
| `ownerResourceID` | `int32` | Owner Resource ID | [ ] |  |  |
| `primaryCompetitor` | `int32` | Primary Competitor | [ ] |  |  |
| `probability` | `int32` | Probability | [ ] |  |  |
| `productID` | `int32` | Product ID | [ ] |  |  |
| `projectedCloseDate` | `datetime` | Projected Close Date | [ ] |  |  |
| `promisedFulfillmentDate` | `datetime` | Promised Fulfillment Date | [ ] |  |  |
| `promotionName` | `varchar2` | Promotion Name | [ ] |  |  |
| `quarterlyCost` | `double` | Quarterly Cost | [ ] |  |  |
| `quarterlyRevenue` | `double` | Quarterly Revenue | [ ] |  |  |
| `rating` | `int32` | Rating | [ ] |  |  |
| `relationshipAssessmentScore` | `double` | Relationship Assessment Score | [ ] |  |  |
| `revenueSpread` | `int32` | Revenue Spread | [ ] |  |  |
| `revenueSpreadUnit` | `varchar2` | Revenue Spread Unit | [ ] |  |  |
| `salesOrderID` | `int32` | Sales Order ID | [ ] |  |  |
| `salesProcessPercentComplete` | `double` | Sales Process Percent Complete | [ ] |  |  |
| `semiannualCost` | `double` | Semi-annual Cost | [ ] |  |  |
| `semiannualRevenue` | `double` | Semi-annual Revenue | [ ] |  |  |
| `stage` | `int32` | Stage | [ ] |  |  |
| `startDate` | `datetime` | Start Date | [ ] |  |  |
| `status` | `int32` | Status | [ ] |  |  |
| `technicalAssessmentScore` | `double` | Technical Assessment Score | [ ] |  |  |
| `throughDate` | `datetime` | Through Date | [ ] |  |  |
| `title` | `varchar2` | Title | [ ] |  |  |
| `totalAmountMonths` | `int32` | Total Amount Months | [ ] |  |  |
| `useQuoteTotals` | `char` | Use Quote Totals | [ ] |  |  |
| `winReason` | `int32` | Win Reason | [ ] |  |  |
| `winReasonDetail` | `varchar2` | Win Reason Detail | [ ] |  |  |
| `yearlyCost` | `double` | Yearly Cost | [ ] |  |  |
| `yearlyRevenue` | `double` | Yearly Revenue | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Autotask](/en/release-notes/drivers?driver=autotask)

