Query the Act! CRM Opportunities associated with a Company.

View Specific Information

Select

• CompanyId supports the '=' operator.
• Name supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• Competitor supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• Created supports the '<=,<,=,!=,>,>=' operator.
• ActualCloseDate supports the '<=,<,=,!=,>,>=' operator.
• DaysOpen supports the '<=,<,=,!=,>,>=' operator.
• Edited supports the '<=,<,=,!=,>,>=' operator.
• EditedBy supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• EstimatedCloseDate supports the '<=,<,=,!=,>,>=' operator.
• GrossMargin supports the '<=,<,=,!=,>,>=' operator.
• IsPrivate supports the '=' operator.
• OpenDate supports the '<=,<,=,!=,>,>=' operator.
• Probability supports the '<=,<,=,!=,>,>=' operator.
• ProductTotal supports the '<=,<,=,!=,>,>=' operator.
• Reason supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• RecordOwner supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• Source supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• StageProcessName supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• WeightedTotal supports the '<=,<,=,!=,>,>=' operator.
• StageStartDate supports the '<=,<,=,!=,>,>=' operator.
• SourceId supports the '<=,<,=,!=,>,>=,CONTAINS' operator.
• ImportDate supports the '<=,<,=,!=,>,>=' operator.
• RecordManager supports the '<=,<,=,!=,>,>=,CONTAINS' operator.

The driver uses the Act! CRM API to process search criteria that refer to the supported fields. The driver processes other filters client-side within the driver. For example, the following queries are processed server side:

SELECT * FROM CompanyOpportunities WHERE CompanyId = 'a58016a6-780c-48c0-84ff-b6b6b085eb8c'

SELECT * FROM CompanyOpportunities

Columns

Name	Type	Description
Id [KEY]	String	A unique identifier that represents the opportunity.
CompanyId [KEY]	String	The unique identifier (id) for the company to retrieve opportunities from.
Created	Datetime	Created date of the opportunity.
Name	String	The opportunity name.
ActualCloseDate	Datetime	The date that the opportunity was closed.
CompaniesAggregate	String	List of companies that are associated to this opportunity entity.
Competitor	String	Gets the name of the competitor for this opportunity.
ContactNames	String	The names of the contacts associated with this opportunity.
ContactsAggregate	String	The names of the contacts associated with this opportunity.
Creator	String	The username of the user who created this opportunity.
DaysOpen	Integer	The number of days this opportunity has been opened.
Edited	Datetime	The date that this record was edited.
EditedBy	String	The user's name that last edited this record.
EstimatedCloseDate	Datetime	The date the opportunity is expected to be closed.
GrossMargin	Decimal	Represents the net sales less the cost of goods and services sold.
GroupsAggregate	String	List of groups that are associated to this opportunity entity.
IsPrivate	Boolean	Indicates whether this opportunity is private
Manager	String	The name of the record manager of this opportunity.
OpenDate	Datetime	The date the opportunity was opened.
Probability	Integer	The likelihood this opportunity will be won by the close date.
ProductTotal	Decimal	The total cost of the product or services.
Reason	String	Describes why the opportunity status changed.
RecordOwner	String	The user's name that owns this record.
RelatedEntitiesResolver	Boolean	If true prevents related entities from serializing.
Source	String	Describes the source of the opportunity.
StageDescription	String	Gets or sets the description of the stage.
StageId	String	Gets the unique identifier of the stage.
StageName	String	The name of the stage.
StageNumber	Integer	The ordinal number of the stage.
StageProbability	Integer	The probability of the stage.
StageProcessDescription	String	The description of the stage process.
StageProcessId	String	The unique identifier of the stage process.
StageProcessName	String	The name of the stage process.
Status	String	The status of the opportunity.
TotalPerCompany	Decimal	The average total per associated company.
TotalPerContact	Decimal	The average total per associated contact.
TotalPerGroup	Decimal	The average total per associated group.
WeightedTotal	Decimal	The weighted total value of the opportunity.
DaysInStage	Integer	The number of days this opportunity has been in a given stage.
StageStartDate	Datetime	The date the opportunity stage started.
SourceId	String	The external source id for the opportunity.
StageProcessStatus	String	Stage process status.
StageProcessStagesCount	Integer	Stage process stages count
StageProcessStages	String	Stage process stages
ImportDate	Datetime	This readonly property displays the date that the opportunity was imported into the system.
QuickBooksInvoiceId	String	Quickbooks external Id to match record with quickbooks contact.
RecordManagerId	String	The unique identifier (id) of the record manager for this opportunity.
CustomFields	String	Custom fields.
RecordManager	String	Manager of the opportunity record.
Acl	String	The access control level of the record.