Lists multiple Opportunity records. Returns Opportunity records synced from the CRM and created via API. The records can be filtered, paged, and sorted using the parameters below and external ID parameters.

View-Specific Information

Select

The driver uses the Salesloft API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the driver.

Column	Supported Operators
Id	=, IN
Name	=, IN
StageName	=
CrmId	=, IN
AccountCrmId	=
OwnerCrmId	=
OpportunityType	=
CloseDate	>, >=, <, <=
IsClosed	=
IsWon	=
CreatedAt	>, >=, <, <=
UpdatedAt	>, >=, <, <=
CreatedDate	>, >=, <, <=
MostRecentCadenceId	=
OwnerId	=
AccountId	=

For example, the following queries are processed server-side:

    SELECT * FROM Opportunities WHERE Id = '123'
    SELECT * FROM Opportunities WHERE Name IN ('Enterprise - 22', 'Enterprise - 23')
    SELECT * FROM Opportunities WHERE CrmId IN ('123', '1234')
    SELECT * FROM Opportunities WHERE CreatedAt >= '2022-12-01'
    SELECT * FROM Opportunities WHERE UpdatedAt >= '2022-12-01'

Note: When filtering on datetime columns (such as CreatedAt or UpdatedAt) using time values, timestamps must include microsecond precision (for example, '2022-12-01T18:00:28.907000'). Providing only millisecond precision may return incorrect results.

Columns

Name	Type	Description
Id [KEY]	Integer	ID of the Opportunity.
Name	String	The Opportunity Name.
Amount	String	The Estimated total sale amount.
StageName	String	The Stage name.
Probability	String	The Probability.
CrmId	String	The identifier for this record in the CRM.
CrmType	String	The CRM type.
AccountCrmId	String	The Account CRM id.
OwnerCrmId	String	The Owner CRM id.
AccountName	String	The Account Full Name.
CreatedByCrmId	String	The Created By CRM id.
OpportunityType	String	The OpportunityType.
OwnerCrmName	String	The Owner Crm Name.
CrmLastUpdatedDate	Datetime	The Datetime of when the Opportunity was most recently updated in CRM.
CloseDate	Datetime	The Date when the opportunity is expected to close.
IsClosed	Boolean	Whether the opportunity is closed.
IsWon	Boolean	Whether the opportunity is closed won.
CrmUrl	String	CRM url, currently Salesforce.com only.
CreatedAt	Datetime	The Datetime of when the Opportunity was created.
UpdatedAt	Datetime	The Datetime of when the Opportunity was last updated.
CreatedDate	Datetime	The Datetime of when the Opportunity was created in CRM.
OpportunityWindowPersonId	Integer	ID of when the attributed person was created in Salesloft.
OpportunityWindowStartedAt	Datetime	Datetime of when the attributed person was created in Salesloft.
CustomFields	String	Custom fields are defined by the user's team. Only fields with values are presented in the API.
CurrencyIsoCode	String	Currency ISO Code.
Tags	String	All tags applied to this Opportunities.
MostRecentCadenceId	Integer	The most recent cadence associated with the Opportunity.
MostRecentStepId	Integer	The most recent step associated with the Opportunity.
MostRecentStepNumber	Integer	The most recent step number associated with the Opportunity.
MostRecentStepAccountId	Integer	The most recent step account id associated with the Opportunity.
OwnerId	Integer	The owner associated with the Opportunity.
CreatorId	Integer	The creator associated with the Opportunity.
AccountId	Integer	The account that this opportunity is associated to.