OpportunityProspectRoles

Get details of prospect roles and associated with an opportunity.

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.
ProspectId supports the '=' operator.
UpdatedAt supports the '=,>=,<=,>,<' operators.
OpportunityId supports the '=' operator.

For example, the following query is processed server side:

SELECT * FROM OpportunityProspectRoles WHERE Id = 1

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

SELECT * FROM OpportunityProspectRoles WHERE Id >= 1

SELECT * FROM OpportunityProspectRoles WHERE Id <= 1

SELECT * FROM OpportunityProspectRoles WHERE Id > 1

SELECT * FROM OpportunityProspectRoles WHERE Id < 2

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

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

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

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

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

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

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

SELECT * FROM OpportunityProspectRoles WHERE ProspectId = 1

SELECT * FROM OpportunityProspectRoles WHERE OpportunityId = 1

Columns

Name	Type	Description
Id [KEY]	Integer	Id of opportunity prospect role.
CreatedAt	Datetime	The date and time the role was created.
Primary	Boolean	A boolean value indicating if this prospect is the primary contact within an opportunity.
Role	String	A string value representing the role.
UpdatedAt	Datetime	The date and time the role was last updated.
ProspectId	Integer	Prospect's Id.
OpportunityId	Integer	Opportunity's Id.

TDV Adapter for Outreach

OpportunityProspectRoles

Select

Columns