Opportunities

Retrieves a list of all opportunities.

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True
AffiliateId	Integer	False	Affiliates.Id
ContactCompanyName	String	True
ContactEmail	String	True
ContactFirstName	String	True
ContactId	Integer	False	Contacts.Id
ContactJobTitle	String	True
ContactLastName	String	True
ContactPhoneNumber	String	True
CustomFields	String	True
DateCreated	Datetime	True
EstimatedCloseDate	Datetime	False
IncludeInForecast	Integer	False
LastUpdated	Datetime	True
NextActionDate	Datetime	False
NextActionNotes	String	False
OpportunityNotes	String	False
OpportunityTitle	String	False
ProjectedRevenueHigh	Double	False
ProjectedRevenueLow	Double	False
StageDetailsCheckListItems	String	True
StageDetailsProbability	Integer	True
StageDetailsStageOrder	Integer	True
StageDetailsTargetNumDays	Integer	True
StageId	Integer	False
StageName	String	True
StageReasons	String	True
UserFirstName	String	True
UserId	Integer	False	Users.Id
UserLastName	String	True

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name	Type	Description
SearchTerm	String	Returns opportunities that match any of the contact's given_name, family_name, company_name, and email_addresses (searches EMAIL1 only) fields as well as opportunity_title