Opportunities

Query Opportunities 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, ExternalOpportunityId, ExternalCompanyId, or ExternalSalesPersonId.

SELECT * FROM Opportunities WHERE ExternalOpportunityId='CDATA1'

Insert

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

The following example demonstrates how to insert a new Opportunity:

INSERT INTO Opportunities (ExternalOpportunityId, Description, ExternalCompanyId, Name) VALUES ('CDATA1', 'CData Software Inc Opportunity', 'CDATA', 'CData')

Update

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

UPDATE Opportunities SET IsWon=true, FiscalYear=2016, Amount='1000.00' WHERE ExternalOpportunityId='Opportunity1'

Delete

Delete is used to remove opportunities from Marketo. To perform a delete, either the Id field or the ExternalOpportunityId field is required.

DELETE FROM Opportunities WHERE ExternalOpportunityId=='Opportunity1'

Columns


Name	Type	ReadOnly	Filterable	Description
MarketoGUID [KEY]	String	True	True	The unique, Marketo-assigned identifier of the opportunity.
ExternalOpportunityId	String	False	True	The external Id of the opportunity.
Amount	Double	False		The amount of the opportunity.
CloseDate	Datetime	False		The date and time the opportunity was closed.
Description	String	False		The description of the opportunity.
ExpectedRevenue	Double	False		The expected revenue of the opportunity.
ExternalCompanyId	String	False	True	The external company Id of the opportunity.
ExternalCreatedDate	Datetime	False		The external date and time the opportunity was created.
ExternalSalesPersonId	String	False	True	The external sales person Id of the opportunity.
Fiscal	String	False		The fiscal of the opportunity.
FiscalQuarter	String	False		The fiscal quarter of the opportunity.
FiscalYear	String	False		The fiscal year of the opportunity.
ForecastCategoryName	String	False		The forecast category name of the opportunity.
IsClosed	Boolean	False		Specifies whether the opportunity is closed.
IsWon	Boolean	False		Specifies whether the opportunity was won.
LastActivityDate	Datetime	False		The date and time the last activity occurred on the opportunity.
LeadSource	String	False		The lead source of the opportunity.
Name	String	False		The name of the opportunity.
NextStep	String	False		The next step of the opportunity.
Probability	Integer	False		The probability of the opportunity.
Quantity	Double	False		The quantity of the opportunity.
Stage	Double	False		The stage of the opportunity.
Type	Double	False		The type of the opportunity.
CreatedAt	Datetime	True		The date and time the opportunity was created.
UpdatedAt	Datetime	True		The date and time the opportunity was last updated.