TDV Adapter for Marketo

Build 23.0.8839

OpportunityPersonRoles

Query Opportunity Person Roles for a Marketo organization.

Table Specific Information

Select

Marketo allows the following columns to be used in the WHERE clause of a SELECT query: Id, CreatedAt, UpdatedAt, OpportunityId, and Role. The CreatedAt and UpdatedAt filters can be specified twice to create a date range.

SELECT * FROM OpportunityPersonRoles WHERE Role = 'Business User'

Columns

Name Type Description
Id [KEY] Integer The unique, Marketo-assigned identifier of the opportunity person role.
OpportunityId Integer The Id of the opportunity associated with the person specified via PersonId.
PersonId String The Id of the person associated with the opportunity specified via OpportunityId.
Role String The role of the contact person in regards to the opportunity.
IsPrimary Boolean Determines whether the person, specified via PersonId, is the primary contact for this opportunity.
ExternalCreatedDate Datetime The local created data of the OpportunityPersonRole association.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
CreatedAt Datetime Used when performing a GET. Filters opportunities by the date they were created.
UpdatedAt Datetime Used when performing a GET. Filters opportunities by the date they were updated.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839