Opportunities
Retrieves a list of all opportunities.
Columns
Name | Type | References | |
Id [KEY] | Integer | ||
AffiliateId | Integer |
Affiliates.Id | |
ContactCompanyName | String | ||
ContactEmail | String | ||
ContactFirstName | String | ||
ContactId | Integer |
Contacts.Id | |
ContactJobTitle | String | ||
ContactLastName | String | ||
ContactPhoneNumber | String | ||
CustomFields | String | ||
DateCreated | Datetime | ||
EstimatedCloseDate | Datetime | ||
IncludeInForecast | Integer | ||
LastUpdated | Datetime | ||
NextActionDate | Datetime | ||
NextActionNotes | String | ||
OpportunityNotes | String | ||
OpportunityTitle | String | ||
ProjectedRevenueHigh | Double | ||
ProjectedRevenueLow | Double | ||
StageDetailsCheckListItems | String | ||
StageDetailsProbability | Integer | ||
StageDetailsStageOrder | Integer | ||
StageDetailsTargetNumDays | Integer | ||
StageId | Integer | ||
StageName | String | ||
StageReasons | String | ||
UserFirstName | String | ||
UserId | Integer |
Users.Id | |
UserLastName | String |