Power BI Connector for Marketo

Build 23.0.8839

OpportunityRoles

Query Opportunity Roles for a Marketo organization.

Table Specific Information

Note: This table is only available for Marketo subscriptions which do not have a native CRM sync enabled. If sync is enabled, an error will be returned when attempting to query the table stating that the API is disabled.

Select

A filter must be specified when retrieving opportunities. Valid filters are any searchable columns which include MarketoGUID and a combination of ExternalOpportunityId and LeadId.

SELECT * FROM OpportunityRoles WHERE ExternalOpportunityId = 'Opportunity1' AND LeadId = '1'

Insert

To create a new Opportunity Role record, specify the information about the Opportunity Role to be entered into the database.

The following example demonstrates how to insert a new Opportunity Role:

INSERT INTO OpportunityRoles (ExternalOpportunityId, LeadId, IsPrimary, Role) VALUES ('CDATA1', '1', false, 'MyRole')

Update

Any field that is not read-only can be updated.

UPDATE OpportunityRoles SET IsPrimary = true WHERE MarketoGUID = 'c674bda8-6e94-40cf-a853-98833b85b7cb'

Delete

Delete is used to remove Opportunity Roles from Marketo. To perform a delete, the MarketoGUID field is required.

DELETE FROM OpportunityRoles WHERE MarketoGUID = 'c674bda8-6e94-40cf-a853-98833b85b7cb'

Columns

Name Type ReadOnly Filterable Description
MarketoGUID [KEY] String True True

The unique, Marketo-assigned identifier of the opportunity role.

ExternalOpportunityId String False True

The external Id of the opportunity.

ExternalCreatedDate Datetime False

The external date and time the opportunity role was created.

IsPrimary Boolean False

Specifies whether the opportunity role is the primary role on the opportunity.

LeadId Integer False True

The lead Id associated with the opportunity role.

Role String False

The role associated with the opportunity.

CreatedAt Datetime True

The date and time the opportunity role was created.

UpdatedAt Datetime True

The date and time the opportunity role was last updated.

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