Opportunities

Get details of opportunities for sales or pending deals.

Select

The adapter will use the API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the adapter.

Id supports the '=,IN,>=,<=,>,<' operators.
CreatedAt supports the '=,>=,<=,>,<' operators.
MapLink supports the '=,IN' operators.
MapStatus supports the '=,IN' operators.
Name supports the '=,IN' operators.
SharingTeamId supports the '=,IN' operators.
TouchedAt supports the '=,>=,<=,>,<' operators.
UpdatedAt supports the '=,>=,<=,>,<' operators.
AccountId supports the '=' operator.
StageId supports the '=' operator.
OpportunityStageId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM Opportunities WHERE Id = 1

SELECT * FROM Opportunities WHERE Id IN (1,2)

SELECT * FROM Opportunities WHERE Id >= 1

SELECT * FROM Opportunities WHERE Id <= 1

SELECT * FROM Opportunities WHERE Id >1

SELECT * FROM Opportunities WHERE Id < 2

SELECT * FROM Opportunities WHERE CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Opportunities WHERE CreatedAt >= '2022-01-25 01:02:02.0 ' AND CreatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Opportunities WHERE CreatedAt >= '2022-02-25 01:02:02.0'

SELECT * FROM Opportunities WHERE CreatedAt = '2022-02-25 01:02:02.0'

SELECT * FROM Opportunities WHERE CreatedAt < '2022-02-25 01:02:02.0'

SELECT * FROM Opportunities WHERE CreatedAt > '2022-02-25 01:02:02.0'

SELECT * FROM Opportunities WHERE UpdatedAt <= '2022-02-25 01:02:02.0'

SELECT * FROM Opportunities WHERE AccountId = 1

SELECT * FROM Opportunities WHERE StageId = 1

Columns

Name	Type	Description
Id [KEY]	Integer	Id of opportunity.
Amount	Integer	The amount the opportunity is worth.
CloseDate	Datetime	The date the opportunity is expected to close.
CreatedAt	Datetime	The date and time the mailing was created.
CurrencyType	String	The ISO code of the currency this opportunity is in.
Description	String	A description of the opportunity.
ExternalCreatedAt	Datetime	The date the opportunity was created in the external system.
MapLink	String	A link to the SamePlan MAP (Mutual Action Plan) associated with this opportunity.
MapNextSteps	String	The next event in the timeline that has yet to be completed for the SamePlan MAP.
MapStatus	String	The status of the SamePlan MAP (Mutual Action Plan) based on how well both parties are trending towards the plan.
Name	String	The name of the opportunity.
NextStep	String	The next step to take for the opportunity.
OpportunityType	String	The type of opportunity.
Probability	Integer	The chances of the opportunity succeeding represented as a percentage.
ProspectingRepId	String	The ID of the sales rep that prospects the opportunity.
SharingTeamId	String	The ID of the sharing team associated with this object. Access is currently in beta.
Tags	String	Tags associated with the opportunity.
TouchedAt	Datetime	The last time an event happened for an opportunity.
UpdatedAt	Datetime	The date the opportunity was last updated.
LinksSelf	String	Links self.
AccountId	Integer	Account Id.
AccountType	String	Account type.
CreatorId	Integer	Creator Id.
CreatorDataType	String	Creator type.
OpportunityStageId	Integer	Opportunity stage Id.
OpportunityStageType	String	Opportunity stage type.
OwnerId	Integer	Owner Id.
OwnerType	String	Owner type.
StageId	Integer	Stage's Id.
StageType	String	Stage's type.
UpdaterId	Integer	Updater Id.
UpdaterType	String	Updater type.
Type	String	Opportunity's type.

TDV Adapter for Outreach

Opportunities

Select

Columns