JDBC Driver for Marketo

Build 22.0.8462

Opportunities

Query Opportunities 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, Name, CreatedAt, UpdatedAt, Type, and Stage. The CreatedAt and UpdatedAt filters can be specified twice to create a date range.

SELECT * FROM Opportunities WHERE Stage='Commercial'

Columns

Name Type Description
Id [KEY] Integer The unique, Marketo-assigned identifier of the opportunity.
Name String The name of the opportunity.
Description String The description of the opportunity.
CompanyId String The Id of the company assigned to the opportunity.
Quantity Double Number of items included in this opportunity. Used in quantity-based forecasting.
Amount Decimal The estimated total sale amount from the opportunity.
ExpectedRevenue Decimal The expected revenue to result from the opportunity.
Stage String The stage that the opportunity process is currently in.
LeadSource String The source of the opportunity, such as Advertisement or Trade Show.
ExternalCreatedDate Datetime The local created date of the opportunity.
LastActivityDate Date The date of the last activity performed with this opportunity.
IsWon Boolean Determines whether the opportunity was won.
NextStep String A description of the next task in closing the opportunity.
IsClosed Boolean Determines whether the opportunity is closed.
CloseDate Date The date when the opportunity is expected to close.
Fiscal String If fiscal years are not enabled, the name of the fiscal quarter or period in which the opportunity CloseDate falls. Value should be in YYYY Q format, for example, '2006 1' for first quarter of 2006.
FiscalQuarter Integer The fiscal quarter the opportunity took place. Valid values are 1, 2, 3, or 4.
FiscalYear Integer The fiscal year the opportunity took place.
ForecastCategoryName String The name of the forecast category.
Probability Integer The percentage of estimated confidence in closing the opportunity.

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.
Type String Used when performing a GET. Filters opportunities by the opportunity type.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462