API Data Provider - Online Help

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060.0