Adding a Connection to Marketo

To add a connection to Marketo:

1. In the application console, navigate to the Connections page.
2. At the Add Connections panel, select the icon for the connection you want to add.
3. If the Marketo icon is not available, click the Add More icon to download and install the Marketo connector from the CData site.

For required properties, see the Settings tab.

For connection properties that are not typically required, see the Advanced tab.

Connecting to Marketo

Marketo supports two APIs: REST and SOAP. To specify the API to be used, configure the Schema property to either REST or SOAP.

REST API

The REST API uses OAuth to authentication to validate the user's access. To set up access to Marketo via the REST API:

1. Create a custom service.
2. Obtain the appropriate OAuth credentials.
3. Configure the connection variables.

Creating a Custom Service

This procedure creates a new role with REST API privileges, assigns that role to an existing or new user, and creates a new service. It must be executed by a user with Admin privileges.

1. Navigate to the Marketo application's Admin area.
2. Navigate to the Security section.
3. Click Users & Roles.
4. Create a new role for API Access:
   1. Select the Roles tab.
   2. Click New Role.
   3. Specify a Role Name and select Role permissions. Specify Access API permissions that are specific to the REST API.
5. Assign or create a new User to execute API Access:
   1. Select the Users tab.
   2. To assign a new user the role you just created, click Invite New User.
   3. Enter the new user information, and assign them the role you just created with REST API access. To denote the user as an API Only user, select the API Only option.
6. Create the new service:
   1. Navigate to Admin > Integration and click the LaunchPoint option.
   2. Click New Service.
   3. Specify the Service Type of Custom.
   4. Enter a display name and description for the service.
   5. Assign the user you just created, to the service.

Marketo creates a new REST API service designed for connecting and authenticating to Marketo. It also generates the OAuth-based authentication credentials required for validating user access to the REST API.

Obtaining OAuth Credentials

To obtain and record the new service's OAuth credentials, return to the Marketo Admin area and navigate to the LaunchPoint option.

Click the View Details link for the service you just created. Marketo displays a window that shows the authentication credentials. These credentials provide the values for OAuthClientId and OAuthClientSecret.

Setting Connection Variables

After you have set the following connection variables, you are ready to connect via the REST API:

• Schema: REST.
• OAuthClientId: The OAuth Client ID associated with your custom service.
• OAuthClientSecret: The OAuth Client Secret associated with your custom service.
• RESTEndpoint: The URL of the REST Web service endpoint, as found in the Admin area. Navigate to the REST API Integration > Web Services section to find this URL. Leave Identity Endpoint blank.

SOAP API

After you have set the following connection variables, you are ready to connect via the SOAP API:

• Schema: SOAP.
• UserId: The client access ID, found in the Integration section of the Marketo Admin SOAP API panel.
• EncryptionKey: The Marketo SOAP API Encryption Key, generated on the Admin page of the Marketo website.
• SOAPEndpoint: The URL of the SOAP Web service endpoint, provided on the Admin page of the Marketo website.

This section details a selection of advanced features of the Marketo Sync App.

User Defined Views

The Sync App allows you to define virtual tables, called user defined views, whose contents are decided by a pre-configured query. These views are useful when you cannot directly control queries being issued to the drivers. See User Defined Views for an overview of creating and configuring custom views.

SSL Configuration

Use SSL Configuration to adjust how Sync App handles TLS/SSL certificate negotiations. You can choose from various certificate formats; see the SSLServerCert property under "Connection String Options" for more information.

Firewall and Proxy

Configure the Sync App for compliance with Firewall and Proxy, including Windows proxies and HTTP proxies. You can also set up tunnel connections.

Query Processing

The Sync App offloads as much of the SELECT statement processing as possible to Marketo and then processes the rest of the query in memory (client-side).

See Query Processing for more information.

Logging

See Logging for an overview of configuration settings that can be used to refine CData logging. For basic logging, you only need to set two connection properties, but there are numerous features that support more refined logging, where you can select subsets of information to be logged using the LogModules connection property.

Customizing the SSL Configuration

By default, the Sync App attempts to negotiate SSL/TLS by checking the server's certificate against the system's trusted certificate store.

To specify another certificate, see the SSLServerCert property for the available formats to do so.

Connecting Through a Firewall or Proxy

HTTP Proxies

To connect through the Windows system proxy, you do not need to set any additional connection properties. To connect to other proxies, set ProxyAutoDetect to false.

In addition, to authenticate to an HTTP proxy, set ProxyAuthScheme, ProxyUser, and ProxyPassword, in addition to ProxyServer and ProxyPort.

Other Proxies

Set the following properties:

• To use a proxy-based firewall, set FirewallType, FirewallServer, and FirewallPort.
• To tunnel the connection, set FirewallType to TUNNEL.
• To authenticate, specify FirewallUser and FirewallPassword.
• To authenticate to a SOCKS proxy, additionally set FirewallType to SOCKS5.

The CData Sync App models Marketo entities in relational Tables, Views, and Stored Procedures. API limitations and requirements are documented in the following sections; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.

Note: Bulk operations are not supported for the SOAP data model.

Tables

Tables describes the available tables.

Views

Views are tables that cannot be modified. Typically, read-only data are shown as views.

The Sync App models the data in Marketo as a list of tables in a relational database that can be queried using standard SQL statements.

Marketo Connector for CData Sync Tables

Name	Description
Leads	Create, update, delete, and query Leads for a Marketo organization.
Programs	Query and update Programs for a Marketo organization.

Create, update, delete, and query Leads for a Marketo organization.

Table Specific Information

Select

All columns must be specified using the '=' operator. The Id and Email columns allow multiple values to be specified by using the OR logical operator. The OldestUpdatedAt column acts as a "since" criteria, and a range can be specified by adding the LatestUpdatedAt column, which specifies the "until" criteria.

Response time from the server can be improved by identifying only the rows and columns you want to retrieve.

SELECT Id, FirstName, LastName FROM Leads WHERE Email = '[email protected]' OR Email = '[email protected]'

Insert

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

The following example demonstrates how to insert a new Lead:

INSERT INTO Leads (Email, FirstName, LastName) VALUES ('[email protected]', 'John', 'Mark')

Update

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

UPDATE Leads SET MobilePhone = '111-222-3333' WHERE Id = '1'

Delete

Deleting a Lead is not directly supported by the Marketo API. However, a Lead can be deleted by creating a campaign, to be run via an API call, that triggers the deletion of a Lead as part of the campaign's flow. Details for how to create a campaign like this can be found here: http://developers.marketo.com/blog/delete-a-lead-with-the-marketo-api/

Once the campaign is created within Marketo, a delete request can be made by specifying the campaign with either the CampaignId or CampaignName column, along with the Id or Email column of the Leads to be deleted.

DELETE FROM Leads WHERE Id = '1000195' AND CampaignId = '1027'

Columns

Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	The unique, Marketo-assigned identifier of the account.
Email	String	False	The lead's email address.
Salutation	String	False	The lead's salutation.
FirstName	String	False	The lead's first name.
MiddleName	String	False	The lead's middle name.
LastName	String	False	The lead's last name.
DateofBirth	Date	False	The lead's date of birth.
Title	String	False	The lead's job title.
Address	String	False	The lead's street address.
City	String	False	The lead's city.
State	String	False	The lead's state.
PostalCode	String	False	The lead's ZIP/postal code.
Country	String	False	The lead's country.
Website	String	False	The lead's website.
Phone	String	False	The lead's phone number.
MobilePhone	String	False	The lead's mobile phone number.
Fax	String	False	The lead's fax number.
Company	String	False	The name of the lead's company.
MainPhone	String	False	The phone number of the lead's company.
SICCode	String	False	The SIC (Standard Industrial Classification) code of the lead's company.
Site	String	False	The site of the lead's company.
BillingStreet	String	False	The billing street address of the lead's company.
BillingCity	String	False	The billing city of the lead's company.
BillingState	String	False	The billing state of the lead's company.
BillingPostalCode	String	False	The billing ZIP/postal code of the lead's company.
BillingCountry	String	False	The billing country of the lead's company.
NumberOfEmployees	Integer	False	The number of employees at the lead's company.
Industry	String	False	The industry of the lead's company.
AnnualRevenue	Decimal	False	The annual revenue generated at the lead's company.
LeadScore	Integer	False	The lead's score.
Rating	String	False	The lead's rating.
Unsubscribed	Boolean	False	Determines whether the lead is unsubscribed.
UnsubscribedReason	String	False	The reason why the lead has unsubscribed.
AnonymousIP	String	False	The IP address of the lead if it is anonymous.
Department	String	False	The lead's deparment.
DoNotCall	Boolean	False	Identifies whether the lead is on the 'Do Not Call' list.
DoNotCallReason	String	False	The reason why the lead is on the 'Do Not Call' list.
InferredCompany	String	False	The lead's inferred company.
InferredCountry	String	False	The lead's inferred country.
LeadRole	String	False	The lead's role.
LeadSource	String	False	The lead's source.
LeadStatus	String	False	The lead's current status.
ForeignSysPersonId	String	False	The lead's Id from a foreign system.
ForeignSysType	String	False	The foreign system type that the ForeignSysPersonId value came from.
MarketoSocialFacebookDisplayName	String	False	The lead's Facebook display name.
MarketoSocialFacebookId	String	False	The lead's Facebook Id.
MarketoSocialFacebookPhotoURL	String	False	The lead's Facebook photo URL.
MarketoSocialFacebookProfileURL	String	False	The lead's Facebook profile URL.
MarketoSocialFacebookReach	Integer	False	The lead's Facebook reach.
MarketoSocialFacebookReferredEnrollments	Integer	False	The lead's Facebook referred enrollments.
MarketoSocialFacebookReferredVisits	Integer	False	The lead's Facebook referred visits.
MarketoSocialGender	String	False	The lead's social gender.
MarketoSocialLastReferredEnrollment	Datetime	False	The lead's last social referred enrollment.
MarketoSocialLastReferredVisit	Datetime	False	The lead's last social referred visit.
MarketoSocialLinkedInDisplayName	String	False	The lead's LinkedIn display name.
MarketoSocialLinkedInId	String	False	The lead's LinkedIn Id.
MarketoSocialLinkedInPhotoURL	String	False	The lead's LinkedIn photo URL.
MarketoSocialLinkedInProfileURL	String	False	The lead's LinkedIn profile URL.
MarketoSocialLinkedInReach	Integer	False	The lead's LinkedIn reach.
MarketoSocialLinkedInReferredEnrollments	Integer	False	The lead's LinkedIn referred enrollments.
MarketoSocialLinkedInReferredVisits	Integer	False	The lead's LinkedIn referred visits.
MarketoSocialSyndicationId	String	False	The lead's social syndication Id.
MarketoSocialTotalReferredEnrollments	Integer	True	The lead's total social referred enrollments.
MarketoSocialTotalReferredVisits	Integer	True	The lead's total social referred visits.
MarketoSocialTwitterDisplayName	String	False	The lead's Twitter display name.
MarketoSocialTwitterId	String	False	The lead's Twitter Id.
MarketoSocialTwitterPhotoURL	String	False	The lead's Twitter photo URL.
MarketoSocialTwitterProfileURL	String	False	The lead's Twitter profile URL.
MarketoSocialTwitterReach	Integer	False	The lead's Twitter reach.
MarketoSocialTwitterReferredEnrollments	Integer	False	The lead's Twitter referred enrollments.
MarketoSocialTwitterReferredVisits	Integer	False	The lead's Twitter referred visits.
MarketoSocialYahooDisplayName	String	False	The lead's Yahoo display name.
MarketoSocialYahooPhotoURL	String	False	The lead's Yahoo photo URL.
MarketoSocialYahooProfileURL	String	False	The lead's Yahoo profile URL.
MarketoSocialYahooReach	Integer	False	The lead's Yahoo reach.
MarketoSocialYahooReferredEnrollments	Integer	False	The lead's Yahoo referred enrollments.
MarketoSocialYahooReferredVisits	Integer	False	The lead's Yahoo referred visits.
MicrosoftAddress2	String	False	The lead's Microsoft street line 2 address.
MicrosoftAddress3	String	False	The lead's Microsoft street line 3 address.
MicrosoftBillingAddress2	String	False	The lead's Microsoft billing street line 2 address.
MicrosoftBillingAddress3	String	False	The lead's Microsoft billing street line 3 address.
MicrosoftDoNotEmail	Boolean	False	Identifies whether the lead is on the Microsoft 'Do Not Email' list.
MicrosoftDoNotFax	Boolean	False	Identifies whether the lead is on the Microsoft 'Do Not Fax' list.
MicrosoftDoNotSendMarketingMaterial	Boolean	False	Identifies whether the lead is on the Microsoft 'Do Not Send Marketing Material' list.
MicrosoftHomePhone	String	False	The lead's Microsoft home phone.
MicrosoftPreferredMethodofContact	String	False	The lead's Microsoft preferred method of contact.
MicrosoftTopic	String	False	The lead's Microsoft topic.
SAP_CRM_ABCClassification	String	False	The lead's SAP ABC classification.
SAP_CRM_AccountID	String	False	The lead's SAP account Id.
SAP_CRM_Account_CreatedOn	Datetime	False	The lead's SAP account creation date.
SAP_CRM_Account_ExternalID	String	False	The lead's SAP account external Id.
SAP_CRM_Account_Fax	String	False	The lead's SAP account fax number.
SAP_CRM_Account_HouseNumber	String	False	The lead's SAP account house number.
SAP_CRM_Account_IsDeleted	Boolean	False	Identifies if the lead's SAP account is deleted.
SAP_CRM_Account_Status	String	False	The lead's SAP account status.
SAP_CRM_BestReachedBy	String	False	The lead's SAP best method to be reached.
SAP_CRM_ContactID	String	False	The lead's SAP contact Id.
SAP_CRM_Contact_Name	String	False	The lead's SAP contact name.
SAP_CRM_DepartmentFromBusinessCard	String	False	The lead's SAP department retrieved from business card.
SAP_CRM_EmployeeID	String	False	The lead's SAP employee Id.
SAP_CRM_ExternalSystem	String	False	The lead's SAP external system.
SAP_CRM_Function	String	False	The lead's SAP function.
SAP_CRM_Lead_HouseNumber	String	False	The lead's SAP lead house number.
SAP_CRM_Name	String	False	The lead's SAP name.
SAP_CRM_Person_Type	String	False	The lead's SAP person type.
SAP_CRM_PrimaryContact	String	False	The lead's SAP primary contact.
SAP_CRM_Qualification	String	False	The lead's SAP qualification.

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
OldestUpdatedAt	Datetime	Used when performing a GET. Returns all leads updated since the specified time.
LatestUpdatedAt	Datetime	Used when performing a GET. Returns all leads updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.
CampaignSource	String	Used when performing a DELETE and is used to specify the source of the campaign. Valid values are MKTOWS or SALES. If not specified, MKTOWS will be used by default.
CampaignId	Integer	Used when performing a DELETE and is used to specify the Id of the campaign that contains the 'Delete Lead' trigger. Note CampaignId and Campaign name cannot both be specified.
CampaignName	String	Used when performing a DELETE and is used to specify the name of the campaign that contains the 'Delete Lead' trigger. Note CampaignId and Campaign name cannot both be specified.

Query and update Programs 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, CRMId, TagType, TagValue, WorkspaceName, WorkspaceId, and IncludeArchive. The Id, Name, and CRMId columns allow multiple values to be specified by using the OR logical operator. The CreatedAt and UpdateAt filters can be specified twice to create a date range.

SELECT * FROM Programs WHERE CreatedAt > '08/01/2014' AND CreatedAt <= '08/31/2014'

Update

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

Note that the Tag*** and Cost*** columns only take a single value. Therefore, they do not take a comma-separated list when performing an update.

UPDATE Programs SET TagType = 'Program Owner', TagValue = 'Admin', CostMonth = '11/2014', CostAmount = '30' WHERE Id = '1002'

Columns

Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	The unique, Marketo-assigned identifier of the program.
Name	String	True	The name of the program.
Description	String	True	The description of the program.
WorkspaceId	String	True	The Id of the workspace where the program is located.
WorkspaceName	String	True	The name of the workspace where the program is located.
TreePath	String	True	The folder structure tree path describing the location of the program.
IsArchived	String	True	Specifies whether the program is archived.
TagType#	String	False	A comma-separated list of tag types associated with the program. Each TagType has a value associated with it which is returned via the TagValue column.
TagValue#	String	False	A comma-separated list of tag values. Each value corresponds to the type listed within the TagTypes column.
CostMonth#	String	False	A comma-separated list of period cost months for the program.
CostAmount#	String	False	A comma-separated list of period cost amounts for the program.
CostId#	String	False	A comma-separated list of period cost Ids for the program.
CostNote#	String	False	A comma-separated list of period cost notes for the program.

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 programs by the date they were created.
UpdatedAt	Datetime	Used when performing a GET. Filters programs by the date they were updated.
CRMId	String	Used when performing a GET. The CRM Id associated with the program. (This value could refer to the Id of the Salesforce campaign connected to the program.)
IncludeArchive	Boolean	Used when performing a GET. When set to 'True', will return archived programs.

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

Marketo Connector for CData Sync Views

Name	Description
Activities	Query Activities for a Marketo organization.
Activities_AddToList	Query Add To List Activities for a Marketo organization.
Activities_AddToSFDCCampaign	Query Add To SFDC Campaign Activities for a Marketo organization.
Activities_ChangeDataValue	Query Change Data Value Activities for a Marketo organization.
Activities_ChangeOwner	Query Change Owner Activities for a Marketo organization.
Activities_ChangeRevenueStage	Query Change Revenue Stage Activities for a Marketo organization.
Activities_ChangeScore	Query Change Score Activities for a Marketo organization.
Activities_ChangeStatusInProgression	Query Change Status In Progression Activities for a Marketo organization.
Activities_ChangeStatusInSFDCCampaign	Query Change Status In SFDC Campaign Activities for a Marketo organization.
Activities_ClickEmail	Query Click Email Activities for a Marketo organization.
Activities_ClickLink	Query Click Link Activities for a Marketo organization.
Activities_ConvertLead	Query Convert Lead Activities for a Marketo organization.
Activities_CreateTask	Query Create Task Activities for a Marketo organization.
Activities_EmailBouncedSoft	Query Email Bounced Soft Activities for a Marketo organization.
Activities_EmailDelivered	Query Email Delivered Activities for a Marketo organization.
Activities_InterestingMoments	Query Interesting Moments Activities for a Marketo organization.
Activities_MergeLeads	Query Merge Leads Activities for a Marketo organization.
Activities_NewLeads	Query New Lead Activities for a Marketo organization.
Activities_OpenEmail	Query Open Email Activities for a Marketo organization.
Activities_RemoveFromFlow	Query Remove from Flow Activities for a Marketo organization.
Activities_RemoveFromList	Query Remove from List Activities for a Marketo organization.
Activities_RemoveFromSFDCCampaign	Query Remove from SFDC Campaign Activities for a Marketo organization.
Activities_SendAlert	Query Send Alert Activities for a Marketo organization.
Activities_SendEmail	Query Send Email Activities for a Marketo organization.
Activities_SFDCActivity	Query SFDC Activity Activities for a Marketo organization.
Activities_SFDCMergeLeads	Query SFDC Merge Leads Activities for a Marketo organization.
Activities_VisitWebpage	Query Visit Webpage Activities for a Marketo organization.
Campaigns	Query Campaigns for a Marketo organization.
Channels	Query Channels for a Marketo organization.
Opportunities	Query Opportunities for a Marketo organization.
OpportunityPersonRoles	Query Opportunity Person Roles for a Marketo organization.
Tags	Query Tags for a Marketo organization.

Query Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, ActivityCreatedAt. ActivityNameFilter or ExcludeActivities can be specified as an additional column in the WHERE clause. A list of available Activity Types can be found here: http://developers.marketo.com/activity-types/. The LeadId, Email, ActivityNameFilter, and ExcludeActivities columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator. Otherwise, an exception will be thrown.

SELECT * FROM Activities WHERE LeadId = '1' OR LeadId = '2'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
ActivityDateTime	Datetime	The date and time the activity was performed.
ActivityType	String	The type of activity.
MktgAssetName	String	The name of the marketing asset tied to the activity.
Campaign	String	The campaign the activity is associated with.
ActivityAttributes#	String	A comma-separated list of name-value pairs (name=value).
Email	String	Used when performing a GET. Filters activities using the email address of the lead associated with the activity.
ActivityNameFilter	String	Used when performing a GET. The name of the specific activities to retrieve.
ExcludeActivities	String	Used when performing a GET. The name of the specific activities to exclude.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query Add To List Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, or ActivityCreatedAt. The LeadId and Email columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator; otherwise, an exception will be thrown.

SELECT * FROM Activities_AddToList WHERE Email = '[email protected]' OR Email = '[email protected]'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
ListId	Integer	The Id of the list that the lead was added to.
ListName	String	The name of the list that the lead was added to.
Source	String	The source by which the lead was added to the list.
StepId	String	The Id of the current step in the flow.
ChoiceNumber	String	The choice number of the current step that triggered the activity.
ActivityDateTime	Datetime	The date and time the activity was performed.
Email	String	Used when performing a GET. Filters activities using the email address of the lead associated with the activity.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query Add To SFDC Campaign Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, or ActivityCreatedAt. The LeadId and Email columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator; otherwise, an exception will be thrown.

SELECT * FROM Activities_AddToSFDCCampaign WHERE Email = '[email protected]' OR Email = '[email protected]'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
CampaignId	Integer	The Id of the SFDC campaign that the lead was added to.
Campaign	String	The campaign the activity is associated with.
Status	String	The status of the activity.
ActivityDateTime	Datetime	The date and time the activity was performed.
AssetName	String	The marketing asset name associated with the activity.
Email	String	Used when performing a GET. Filters activities using the email address of the lead associated with the activity.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query Change Data Value Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, or ActivityCreatedAt. The LeadId and Email columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator; otherwise, an exception will be thrown.

SELECT * FROM Activities_ChangeDataValue WHERE Email = '[email protected]' OR Email = '[email protected]'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
Source	String	The source by which the data value was changed (i.e., Web service API, SFDC, etc).
StepId	String	The Id of the current step in the flow.
ChoiceNumber	String	The choice number of the current step that triggered the activity.
AttributeName	String	The name of the attribute whose data value was changed.
NewValue	String	The new and current data value.
OldValue	String	The old and previous data value.
Reason	String	The reason why the data value was changed.
ActivityDateTime	Datetime	The date and time the activity was performed.
AssetName	String	The marketing asset name associated with the activity.
Email	String	Used when performing a GET. Filters activities using the email address of the lead associated with the activity.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query Change Owner Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, or ActivityCreatedAt. The LeadId and Email columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator; otherwise, an exception will be thrown.

SELECT * FROM Activities_ChangeOwner WHERE Email = '[email protected]' OR Email = '[email protected]'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
Owner	String	The name of the new and current owner of the lead.
OwnerId	String	The Id of the new and current owner of the lead.
OldOwner	String	The name of the previous owner of the lead.
OldOwnerId	String	The Id of the previous owner of the lead.
ActivityDateTime	Datetime	The date and time the activity was performed.
AssetName	String	The marketing asset name associated with the activity.
Email	String	Used when performing a GET. Filters activities using the email address of the lead associated with the activity.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query Change Revenue Stage Activities for a Marketo organization.

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
ModelId	String	The id of the revenue model.
ModelVersion	String	The version of the revenue model.
NewStageId	String	The new Id of the stage that the lead is currently in.
NewStage	String	The new name of the stage that the lead is currently in.
OldStageId	String	The Id of the stage that the lead was previously in.
OldStage	String	The name of the stage that the lead was previously in.
Reason	String	The reason why the data value was changed.
StepId	String	The Id of the current step in the flow.
ChoiceNumber	String	The choice number of the current step that triggered the activity.
ActivityDateTime	Datetime	The date and time the activity was performed.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query Change Score Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, or ActivityCreatedAt. The LeadId and Email columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator; otherwise, an exception will be thrown.

SELECT * FROM Activities_ChangeScore WHERE Email = '[email protected]' OR Email = '[email protected]'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
ScoreName	String	The name of the score whose data value was changed.
ChangeValue	String	The net change in the score value. For example, +5 or -5.
NewValue	String	The new and current score value.
OldValue	String	The old and previous score value.
Urgency	String	How much the score has changed recently. A higher urgency represents a score that has increased a lot lately, showing customer interest. This value is derived from score value (NewValue).
Reason	String	The reason why the data value was changed.
Priority	String	The priority rank used to decide which lead should be contacted first. Priority has two components: Urgency and Relative Score. The higher the priority, the higher likelihood that the lead will respond positively to a contact.
RelativeScore	String	Contains a measure of how a lead's score compares to other lead scores. This value is derived from score value (NewValue).
RelativeUrgency	String	Contains a measure of how a lead's urgency compares to other lead urgencies.
ActivityDateTime	Datetime	The date and time the activity was performed.
AssetName	String	The marketing asset name associated with the activity.
Email	String	Used when performing a GET. Filters activities using the email address of the lead associated with the activity.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query Change Status In Progression Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, or ActivityCreatedAt. The LeadId and Email columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator; otherwise, an exception will be thrown.

SELECT * FROM Activities_ChangeStatusInProgression WHERE Email = '[email protected]' OR Email = '[email protected]'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
NewStatus	String	The new and current status.
NewStatusId	String	The Id of the NewStatus value.
OldStatus	String	The old and previous status.
OldStatusId	String	The Id of the OldStatus value.
Program	String	The name of the program where the status change occurred.
ProgramId	Integer	The Id of the Program.
Success	Boolean	Identifies whether the status represents a success.
AcquiredBy	String	Identifies whether the lead was acquired by this activity.
Reason	String	The reason why the status was changed.
StepId	String	The Id of the current step in the flow.
ChoiceNumber	String	The choice number of the current step that triggered the activity.
ActivityDateTime	Datetime	The date and time the activity was performed.
AssetName	String	The marketing asset name associated with the activity.
Email	String	Used when performing a GET. Filters activities using the email address of the lead associated with the activity.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query Change Status In SFDC Campaign Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, or ActivityCreatedAt. The LeadId and Email columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator; otherwise, an exception will be thrown.

SELECT * FROM Activities_ChangeStatusInSFDCCampaign WHERE Email = '[email protected]' OR Email = '[email protected]'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
CampaignId	Integer	The Id of the SFDC campaign that the lead's status was changed.
Campaign	String	The campaign the activity is associated with.
NewStatus	String	The new and current status.
OldStatus	String	The old and previous status.
ActivityDateTime	Datetime	The date and time the activity was performed.
AssetName	String	The marketing asset name associated with the activity.
Email	String	Used when performing a GET. Filters activities using the email address of the lead associated with the activity.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query Click Email Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, or ActivityCreatedAt. The LeadId and Email columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator; otherwise, an exception will be thrown.

SELECT * FROM Activities_ClickEmail WHERE Email = '[email protected]' OR Email = '[email protected]'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
Campaign	String	The campaign the activity is associated with.
Link	String	The URL of the link that was clicked.
MailingId	String	The Id of the email that the link was contained in.
VariationId	String	The Id of the email variation.
UserAgent	String	The Web browser user agent information obtained when the lead clicked the email link.
IsMobileDevice	String	Identifies whether the device used to click the link was a mobile device.
Platform	String	The operating system platform used when the link was opened.
Device	String	The type of device used when the link was opened.
StepId	String	The Id of the current step in the flow.
ChoiceNumber	String	The choice number of the current step that triggered the activity.
ActivityDateTime	Datetime	The date and time the activity was performed.
AssetName	String	The marketing asset name associated with the activity.
Email	String	Used when performing a GET. Filters activities using the email address of the lead associated with the activity.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query Click Link Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, or ActivityCreatedAt. The LeadId and Email columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator; otherwise, an exception will be thrown.

SELECT * FROM Activities_ClickLink WHERE Email = '[email protected]' OR Email = '[email protected]'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
Campaign	String	The campaign the activity is associated with.
WebpageId	String	The Id of the Web page that contained the link that was clicked.
LinkId	String	The Id of the link that was clicked.
QueryParameters	String	The query parameters contained within the link.
ClientIPAddress	String	The IP address of the client that clicked the link.
MessageId	String	The Id of the message where the link was clicked.
UserAgent	String	The Web browser user agent information obtained when the lead clicked the link.
ReferrerURL	String	The URL of the referrer used to identify where the link click originated from.
CreatedAt	String	The date and time the link click activity was created.
ActivityDateTime	Datetime	The date and time the activity was performed.
AssetName	String	The marketing asset name associated with the activity.
Email	String	Used when performing a GET. Filters activities using the email address of the lead associated with the activity.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query Convert Lead Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, or ActivityCreatedAt. The LeadId and Email columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator; otherwise, an exception will be thrown.

SELECT * FROM Activities_ConvertLead WHERE Email = '[email protected]' OR Email = '[email protected]'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
Campaign	String	The campaign the activity is associated with.
AssignTo	String	The owner that the lead was assigned to.
SFDCAccountId	String	The Id of the lead's SFDC account.
SFDCType	String	The lead's SFDC type.
SFDCOpportunityId	String	The Id of the lead's SFDC opportunity.
SFDCLeadId	String	The lead's SFDC lead Id.
SFDCContactId	String	The lead's SFDC contact Id.
ActivityDateTime	Datetime	The date and time the activity was performed.
AssetName	String	The marketing asset name associated with the activity.
Email	String	Used when performing a GET. Filters activities using the email address of the lead associated with the activity.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query Create Task Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, or ActivityCreatedAt. The LeadId and Email columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator; otherwise, an exception will be thrown.

SELECT * FROM Activities_CreateTask WHERE Email = '[email protected]' OR Email = '[email protected]'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
Campaign	String	The campaign the activity is associated with.
Subject	String	The subject of the task.
Operator	String	The task operator.
DataType	String	The task data type.
DueIn	String	The number of days until the task is due.
Owner	String	The owner that the task was assigned to.
Comments	String	The comments for the task.
Priority	String	The priority of the task.
Status	String	The current status of the task.
Notify	String	Identifies whether a notification should be sent.
RemindIn	String	The number of days that a reminder should be sent.
SFDCTaskId	String	The SFDC Id of the task.
OwnerPersonId	String	The Id of the Owner of the task.
DueDate	String	The date the task is due.
ReminderTimestamp	String	The timestamp identifying when the reminder will be sent.
StepId	String	The Id of the current step in the flow.
ChoiceNumber	String	The choice number of the current step that triggered the activity.
ActivityDateTime	Datetime	The date and time the activity was performed.
AssetName	String	The marketing asset name associated with the activity.
Email	String	Used when performing a GET. Filters activities using the email address of the lead associated with the activity.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query Email Bounced Soft Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, or ActivityCreatedAt. The LeadId and Email columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator; otherwise, an exception will be thrown.

SELECT * FROM Activities_EmailBouncedSoft WHERE Email = '[email protected]' OR Email = '[email protected]'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
MailingId	String	The Id of the email message that was sent.
Campaign	String	The campaign the activity is associated with.
Email	String	The email address of the intended recipient.
Details	String	The details about why the email bounced.
VariantId	String	The Id of the email variant.
StepId	String	The Id of the current step in the flow.
ChoiceNumber	String	The choice number of the current step that triggered the activity.
AssetName	String	The marketing asset name associated with the activity.
ActivityDateTime	Datetime	The date and time the activity was performed.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query Email Delivered Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, or ActivityCreatedAt. The LeadId and Email columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator; otherwise, an exception will be thrown.

SELECT * FROM Activities_EmailDelivered WHERE Email = '[email protected]' OR Email = '[email protected]'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
Campaign	String	The campaign the activity is associated with.
MailingId	String	The Id of the email message that was sent.
StepId	String	The Id of the current step in the flow.
ChoiceNumber	String	The choice number of the current step that triggered the activity.
ActivityDateTime	Datetime	The date and time the activity was performed.
AssetName	String	The marketing asset name associated with the activity.
Email	String	Used when performing a GET. Filters activities using the email address of the lead associated with the activity.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query Interesting Moments Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, or ActivityCreatedAt. The LeadId and Email columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator; otherwise, an exception will be thrown.

SELECT * FROM Activities_InterestingMoments WHERE Email = '[email protected]' OR Email = '[email protected]'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
Campaign	String	The campaign the activity is associated with.
Type	String	The type of moment that occurred such as Web, Email, Milestone, etc.
Description	String	The description about the moment.
Operator	String	The interesting moment operator.
DataType	String	The interesting moment datatype.
Source	String	The source by which the interesting moment occurred.
StepId	String	The Id of the current step in the flow.
ChoiceNumber	String	The choice number of the current step that triggered the activity.
Date	String	The date the interesting moment occurred.
TriggeringActivityLogID	String	The Id of the activity that triggered the interesting moment.
ActivityDateTime	Datetime	The date and time the activity was performed.
AssetName	String	The marketing asset name associated with the activity.
Email	String	Used when performing a GET. Filters activities using the email address of the lead associated with the activity.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query Merge Leads Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, or ActivityCreatedAt. The LeadId and Email columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator; otherwise, an exception will be thrown.

SELECT * FROM Activities_MergeLeads WHERE Email = '[email protected]' OR Email = '[email protected]'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
LeadName	String	The name of the lead that was merged.
MasterUpdated	Boolean	Identifies whether the master lead was updated.
MergeIds	String	The lead Ids that were merged.
MergeFields	String	The fields that were merged.
MergedInSales	String	Identifies whether the lead was merged in sales.
MergeSource	String	The source by which the merge was performed.
ActivityDateTime	Datetime	The date and time the activity was performed.
Email	String	Used when performing a GET. Filters activities using the email address of the lead associated with the activity.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query New Lead Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, or ActivityCreatedAt. The LeadId and Email columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator; otherwise, an exception will be thrown.

SELECT * FROM Activities_NewLeads WHERE Email = '[email protected]' OR Email = '[email protected]'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
MktgAssetName	String	The name of the lead.
SourceType	String	The source type that created the new lead, such as Salesforce.com.
LeadSource	String	The source where the new lead was created.
SourceInfo	String	Information about the source of the new lead creation.
SFDCType	String	The SFDC type for this lead.
CreatedDate	String	The date the new lead was created.
ActivityDateTime	Datetime	The date and time the activity was performed.
Email	String	Used when performing a GET. Filters activities using the email address of the lead associated with the activity.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query Open Email Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, or ActivityCreatedAt. The LeadId and Email columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator; otherwise, an exception will be thrown.

SELECT * FROM Activities_OpenEmail WHERE Email = '[email protected]' OR Email = '[email protected]'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
Campaign	String	The campaign the email open activity is associated with.
MailingId	String	The Id of the email that was opened.
VariationId	String	The Id of the email variation.
UserAgent	String	The Web browser user agent information obtained when the lead clicked the email link.
IsMobileDevice	String	Identifies whether the device used to click the link was a mobile device.
Platform	String	The operating system platform used when the link was opened.
Device	String	The type of device used when the link was opened.
StepId	String	The Id of the current step in the flow.
ChoiceNumber	String	The choice number of the current step that triggered the activity.
ActivityDateTime	Datetime	The date and time the activity was performed.
AssetName	String	The marketing asset name associated with the activity.
Email	String	Used when performing a GET. Filters activities using the email address of the lead associated with the activity.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query Remove from Flow Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, or ActivityCreatedAt. The LeadId and Email columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator; otherwise, an exception will be thrown.

SELECT * FROM Activities_RemoveFromFlow WHERE Email = '[email protected]' OR Email = '[email protected]'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
Campaign	String	The campaign the activity is associated with.
RemoveFromCampaigns	String	The campaign Id that the lead was removed from.
DataType	String	The campaign flow datatype.
StepId	String	The Id of the current step in the flow.
ChoiceNumber	String	The choice number of the current step that triggered the activity.
ActivityDateTime	Datetime	The date and time the activity was performed.
AssetName	String	The marketing asset name associated with the activity.
Email	String	Used when performing a GET. Filters activities using the email address of the lead associated with the activity.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query Remove from List Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, or ActivityCreatedAt. The LeadId and Email columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator; otherwise, an exception will be thrown.

SELECT * FROM Activities_RemoveFromList WHERE Email = '[email protected]' OR Email = '[email protected]'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
Campaign	String	The campaign the activity is associated with.
ListId	Integer	The Id of the list the lead was removed from.
StepId	String	The Id of the current step in the flow.
ChoiceNumber	String	The choice number of the current step that triggered the activity.
ActivityDateTime	Datetime	The date and time the activity was performed.
AssetName	String	The marketing asset name associated with the activity.
Email	String	Used when performing a GET. Filters activities using the email address of the lead associated with the activity.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query Remove from SFDC Campaign Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, or ActivityCreatedAt. The LeadId and Email columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator; otherwise, an exception will be thrown.

SELECT * FROM Activities_RemoveFromSFDCCampaign WHERE Email = '[email protected]' OR Email = '[email protected]'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
CampaignId	Integer	The Id of the campaign that the lead was removed from.
Campaign	String	The campaign the activity is associated with.
Status	String	The current status of the SFDC campaign.
ActivityDateTime	Datetime	The date and time the activity was performed.
AssetName	String	The marketing asset name associated with the activity.
Email	String	Used when performing a GET. Filters activities using the email address of the lead associated with the activity.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query Send Alert Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, or ActivityCreatedAt. The LeadId and Email columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator; otherwise, an exception will be thrown.

SELECT * FROM Activities_SendAlert WHERE Email = '[email protected]' OR Email = '[email protected]'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
CampaignRunId	String	The Id of the campaign that the alert was run for.
Campaign	String	The campaign the email send activity is associated with.
MailingId	String	The Id of the email alert sent.
SendToOwner	String	Identifies which owner received the alert. For example Lead, Account, or None.
SendToList	String	Additional recipients of the alert.
StepId	String	The Id of the current step in the flow.
ChoiceNumber	String	The choice number of the current step that triggered the activity.
ActivityDateTime	Datetime	The date and time the activity was performed.
AssetName	String	The marketing asset name associated with the activity.
Email	String	Used when performing a GET. Filters activities using the email address of the lead associated with the activity.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query Send Email Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, or ActivityCreatedAt. The LeadId and Email columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator; otherwise, an exception will be thrown.

SELECT * FROM Activities_SendEmail WHERE Email = '[email protected]' OR Email = '[email protected]'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
CampaignRunId	String	The Id of the campaign the email was sent for.
Campaign	String	The campaign the activity is associated with.
MailingId	String	The Id of the email sent.
StepId	String	The Id of the current step in the flow.
ChoiceNumber	String	The choice number of the current step that triggered the activity.
ActivityDateTime	Datetime	The date and time the activity was performed.
AssetName	String	The marketing asset name associated with the activity.
Email	String	Used when performing a GET. Filters activities using the email address of the lead associated with the activity.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query SFDC Activity Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, or ActivityCreatedAt. The LeadId and Email columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator; otherwise, an exception will be thrown.

SELECT * FROM Activities_SFDCActivity WHERE Email = '[email protected]' OR Email = '[email protected]'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
Subject	String	The subject of the SFDC activity.
Description	String	The description of the SFDC activity.
OwnerID	String	The Id of the SFDC activity owner.
ActivityOwner	String	The owner of the SFDC activity.
Status	String	The current status of the SFDC activity.
Priority	String	The priority of the activity.
IsTask	String	Identifies whether the activity is a task.
DueDate	String	The date the SFDC activity is due.
ActivityDateTime	Datetime	The date and time the activity was performed.
AssetName	String	The marketing asset name associated with the activity.
Email	String	Used when performing a GET. Filters activities using the email address of the lead associated with the activity.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query SFDC Merge Leads Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, or ActivityCreatedAt. The LeadId and Email columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator; otherwise, an exception will be thrown.

SELECT * FROM Activities_SFDCMergeLeads WHERE Email = '[email protected]' OR Email = '[email protected]'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
LeadName	String	The name of the SFDC lead that was merged.
Merged	String	The fields that were merged for the SFDC lead.
WinningValues	String	The winning values of the merged SFDC lead.
ActivityDateTime	Datetime	The date and time the activity was performed.
Email	String	Used when performing a GET. Filters activities using the email address of the lead associated with the activity.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer other:filterable=	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query Visit Webpage Activities for a Marketo organization.

Table Specific Information

Select

Marketo allows one (and only one) of the following columns to be used in the WHERE clause of a SELECT query: LeadId, Email, StaticListId, StaticListName, OldestCreatedAt, or ActivityCreatedAt. The LeadId and Email columns allow multiple values to be specified by the OR logical operator. All columns must be specified using the '=' operator; otherwise, an exception will be thrown.

SELECT * FROM Activities_VisitWebpage WHERE Email = '[email protected]' OR Email = '[email protected]'

Columns

Name	Type	Description
ActivityId [KEY]	Integer	The unique Id of the activity.
LeadId	Integer	The unique Id of the lead associated with the activity.
Campaign	String	The campaign the activity is associated with.
WebpageId	String	The Id of the Web page that was visited.
WebpageURL	String	The URL of the Web page that was visited.
LinkId	String	The Id of the link that was clicked.
QueryParameters	String	The query parameters contained within the URL.
ClientIPAddress	String	The IP address of the client that clicked the link.
MessageId	String	The Id of the message where the link was clicked.
UserAgent	String	The Web browser user agent information obtained when the Web page was visited.
ReferrerURL	String	The URL of the referrer used to identify where the link click originated from.
CreatedAt	String	The date and time the Web page activity was created.
ActivityDateTime	Datetime	The date and time the activity was performed.
AssetName	String	The marketing asset name associated with the activity.
Email	String	Used when performing a GET. Filters activities using the email address of the lead associated with the activity.

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
OldestCreatedAt	Datetime	Used when performing a GET. Returns all activities updated since the specified time.
ActivityCreatedAt	Datetime	Used when performing a GET. Returns all activities updated up until the specified time.
StaticListId	Integer	Used when performing a GET. The Id of the static list to retrieve.
StaticListName	String	Used when performing a GET. The name of the static list to retrieve.

Query Campaigns for a Marketo organization.

Table Specific Information

Select

Marketo allows the Source and Name columns to be used in the WHERE clause of a SELECT query. Use the Source column to identify the campaigns that were created within Marketo or by Sales. The Name column allows the use of the '=' or 'LIKE' operator. The '=' operator denotes an exact match; the 'LIKE' operator denotes a partial match of the name.

SELECT * FROM Campaigns WHERE Name LIKE 'test'

Columns

Name	Type	Description
Id [KEY]	Integer	The unique Id of the campaign.
Name	String	The name of the campaign.
Description	String	The description of the campaign.
Source	String	The source of the campaign. Valid values are MKTOWS and SALES.

Query Channels for a Marketo organization.

Table Specific Information

Select

Marketo allows the TagValue column to be used in the WHERE clause of a SELECT query. The TagValue column allows multiple values to be specified by using the OR logical operator. Note that only the '=' operator is supported.

SELECT * FROM Channels WHERE TagValue = 'Email Blast' OR TagValue = 'Blog' OR TagValue = 'Webinar'

Columns

Name	Type	Description
TagValue [KEY]	String	The tag value of the channel. For example, Webinar, Blog, or Tradeshow.
Status [KEY]	String	The progression status of the channel.
Step	Integer	The step number of each progression status used to sequence the order of the channel.
Success	Boolean	Specifies whether the progression status results in a success.
CheckInStatus	String	The check-in status for a roadshow event. Valid values are None, Registered, Attended.
WebinarBehavior	String	The behavior performed during a webinar event.

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.

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.

Query Tags for a Marketo organization.

Table Specific Information

Select

Marketo allows both the Type and Value columns to be used in the WHERE clause of a SELECT query. The Value column allows multiple values to be specified by using the OR logical operator. Note that only the '=' operator is supported.

SELECT * FROM Tags WHERE Type = 'TestTag' AND Value = 'Value1' OR Value = 'Value2'

Columns

Name	Type	Description
Type [KEY]	String	The tag type.
Value [KEY]	String	The tag value.

The CData Sync App models Marketo entities in relational Tables, Views, and Stored Procedures. API limitations and requirements are documented in the following sections; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.

Note: Bulk operations are supported for all tables in the REST data model.

Tables

Tables describes the available tables. The Leads, CustomObjects, and Custom Activity tables are dynamic tables. The data model illustrates a sample of what your Marketo data model might look like. The actual data model will be obtained dynamically based on your user credentials and Marketo account.

Views

Views are tables that cannot be modified. Typically, read-only data are shown as views.

Stored Procedures

Stored Procedures are function-like interfaces to Marketo. They can be used to search, update, and modify information in Marketo.

The Sync App models the data in Marketo as a list of tables in a relational database that can be queried using standard SQL statements.

Marketo Connector for CData Sync Tables

Name	Description
CustomActivities	Query Custom Activities for a Marketo organization.
CustomObjects	Create, update, delete, and query custom objects for a Marketo organization.
Emails	Query Emails for a Marketo organization.
EmailTemplates	Query, update and delete EmailTemplates for a Marketo organization.
Folders	Create, update, delete, and query Folders for a Marketo organization.
Forms	Create, update, delete and query Forms for a Marketo organization.
LandingPages	Create, update, delete and query Landing Pages for a Marketo organization.
LandingPageTemplates	Create, update, delete and query LandingPageTemplates for a Marketo organization.
Leads	Create, update, delete, and query Leads for a Marketo organization.
ListStaticMemberShip	Create, delete and query query static list members for a Marketo organization.
NamedAccounts	Query Named Accounts for a Marketo organization.
Opportunities	Query Opportunities for a Marketo organization.
OpportunityRoles	Query Opportunity Roles for a Marketo organization.
ProgramMembers	Create, update, delete, and query members for program in Marketo.
Programs	Query Programs for a Marketo organization.
SalesPersons	Query Sales Persons for a Marketo organization.
SmartCampaigns	Create, update, delete, and query SmartCampaigns for a Marketo organization.
SmartLists	Query and delete SmartLists for a Marketo organization.
Snippets	Create, update, delete and query Snippets for a Marketo organization.
StaticLists	Create, update, delete and query Static Lists for a Marketo organization.
Tokens	Create, delete, and query Tokens for a Marketo organization.

Query Custom Activities for a Marketo organization.

Table Specific Information

Each custom activity contained within your Marketo organization will be returned as it's own table. Each table name will be prefixed with 'Activity_' followed by the name of your custom activity.

Select

Custom activities can be retrieved by performing a SELECT query on the custom activity table.

SELECT * FROM Activity_MyCustomActivity

INSERT

Custom activities can be added by performing an INSERT. To create a new custom activity record, specify the information about the custom activity to be entered into the database.

The following properties are required when creating a custom activity record: ActivityDate, LeadId, and PrimaryAttributeValue (note this column name changes based on the name you designated for the primary field of the activity).

The following example demonstrates how to insert a new custom activity called MyCustomActivity:

INSERT INTO Activity_MyCustomActivity (ActivityDate, PrimaryFieldValue, LeadId, MyInt, Email) VALUES ('11/08/2016', '123', '1', 12345, '[email protected]')

Update

UPDATEs are not supported on custom activities.

Delete

DELETEs are not supported on custom activities.

Columns

Name	Type	ReadOnly	Filterable	Description
ActivityId [KEY]	Integer	True		The unique Id of the activity.
LeadId	Integer	True	True	The unique Id of the lead associated with the activity.
ActivityDate	Datetime	True	True	The date and time the lead was added to the list. Can be used as a filter to specify the starting date and time to retrieve all activities on or after the specified date.
PrimaryAttribute	String	True	True	The primary field Id
PrimaryAttributeValue	String	True		The primary field value.

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
ListId	Integer	A List Id used to retrieve actvities for all leads contained within the specified list.

Create, update, delete, and query custom objects for a Marketo organization.

Table Specific Information

Each custom object contained within your Marketo organization will be returned as it's own table. Each table name will be prefixed with 'CustomObject_' followed by the name of your custom object.

Select

The Marketo REST API requires that a filter be specified to retrieve custom objects. The filter must contain at least one column that is the Key, a dedupeField, or a column that is searchable. Only the '=' operator is supported on these filter types. Other filters can be specified in addition to this but at least one of the previously mentioned filters must be specified. All filterable columns allow multiple values to be specified by using the IN operator or the OR logical operator.

Response time from the server can be improved by identifying only the rows and columns you want to retrieve.

SELECT Make, Model, Year, Color FROM CustomObject_MyCustomBikeObject WHERE VIN = '12345'

Insert

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

The following example demonstrates how to insert a new custom object called MyCustomBikeObject:

INSERT INTO MyCustomBikeObject (VIN, Make, Model, Color) VALUES ('99999', 'Yamaha', 'FZ-09', 'Blue')

Update

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

UPDATE MyCustomBikeObject SET Year = 2016 WHERE VIN = '99999'

Delete

Delete is used to remove custom objects from Marketo. To perform a delete, the table key or a dedupeField column must be specified.

DELETE FROM MyCustomBikeObject WHERE VIN = '99999'

Columns

Name	Type	ReadOnly	Filterable	Description
MarketoGUID [KEY]	String	True		The unique, Marketo-assigned identifier of the custom object.
CreatedAt	Datetime	False		The datetime the custom object was created.
UpdatedAt	Datetime	False		The datetime the custom object was updated.

Query Emails for a Marketo organization.

Table Specific Information

Select

Note: All filterable columns must be specified using the '=' operator.

Retrieve a list of emails from the target instance, filterable by name.

SELECT * FROM Emails WHERE Name = 'CRUD Test'

Retrieve the email record for the given target Id.

SELECT * FROM Emails WHERE Id = 1192

Insert

To create a new Email, specify at least the Name, Template, FolderId and FolderType column.

INSERT INTO Emails (Name, Template, FolderId, FolderType) VALUES ('My Email', '1078', 2307, 'Folder')

Update

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

UPDATE Emails SET Description = 'Testing Update' WHERE Id = 1192

Delete

To delete a Email you can specify the ID or Name field.

DELETE FROM Emails WHERE Id = 1192
DELETE FROM Emails WHERE Name in ('Test1', 'Test2')

Columns

Name	Type	ReadOnly	Filterable	Description
Id [KEY]	Integer	True	True	The unique, Marketo-assigned identifier of the email.
Name	String	False	True	The name of the email.
Description	String	False		The description of the email.
Subject	String	False		The email subject.
FromName	String	False		The from name.
FromEmail	String	False		The from email address.
ReplyEmail	String	False		The reply email address.
FolderId	Integer	False		The Id of the folder where the email is located
FolderType	String	False		The type of the folder where the email is located.
FolderName	String	False		The name folder where the email is located.
Operational	Boolean	False		Identifies whether the email is operational.
TextOnly	Boolean	False		Identifies whether the email is text only.
PublishToMSI	Boolean	False		Identifies whether the email is published.
WebView	Boolean	False		Identifies whether the email is web view.
Status	String	False		The status of the email.
Version	Integer	False		The version of the email.
AutoCopyToText	Boolean	False		Identifies whether the email is auto copied to text.
Template	Integer	False		The template associated with the email.
Workspace	String	False		The name of the workspace where the email is located.
CreatedAt	Datetime	True		The date and time the email was created.
UpdatedAt	Datetime	True		The date and time the email was last updated.
PreHeader	String	False		The preheader text for the email.

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
EarliestUpdatedAt	Datetime	Exclude emails prior to this date. Must be valid ISO-8601 string.
LatestUpdatedAt	Datetime	Exclude emails after this date. Must be valid ISO-8601 string.

Query, update and delete EmailTemplates for a Marketo organization.

Table Specific Information

Select

Note: All filterable columns must be specified using the '=' operator.

Retrieve a list of email templates from the target instance, filterable by name and status.

SELECT * FROM EmailTemplates WHERE Name = 'CRUD Test'

Retrieve the email record for the given target Id.

SELECT * FROM EmailTemplates WHERE Id = 1192

Update

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

UPDATE EmailTemplates SET Name = 'Update Test' Description = 'Testing Update' WHERE Id = 1192

Delete

To delete a Email you can specify the ID or Name field.

DELETE FROM EmailTemplates WHERE Id = 1192
DELETE FROM EmailTemplates WHERE Name in ('Test1', 'Test2')

Columns

Name	Type	ReadOnly	Filterable	Description
Id [KEY]	Integer	True	True	Id of the asset.
Name	String	False	True	Name of the asset.
CreatedAt	Datetime	True		Datetime the asset was created.
Description	String	False		Description of the asset.
FolderId	Integer	True		The Id of the folder
FolderType	String	True		The Type of folder The allowed values are Folder, Program.
FolderName	String	True		The Name of folder
Status	String	True	True	Status filter for draft or approved versions
UpdatedAt	Datetime	True		Datetime the asset was most recently updated
Url	String	True		Url of the asset in the Marketo UI
Version	Integer	True		The Template version type The allowed values are 1, 2.
Workspace	String	True		Name of the workspace
Content	String	True		HTML content for template. Multipart file.

Create, update, delete, and query Folders for a Marketo organization.

Table Specific Information

Select

Note: All filterable columns must be specified using the '=' operator.

Retrieve all folders within two levels of the folder hierarchy.

SELECT * FROM Folders

Retrieve all folders under a specific root folder.

SELECT * FROM Folders WHERE RootFolderId = 38 AND MaxDepth = 5

Insert

To create a new Folder, specify at least the Name, ParentId and ParentType column.

INSERT INTO Folders (Name, ParentId, ParentType) VALUES ('New_Folder_Marketo_CData_Driver', 38, 'Folder')

Update

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

UPDATE Folders SET Description = 'Updated Folder', IsArchive = true WHERE Id = 1996

Delete

To delete a folder you can specify the ID or Name field. Deletions can be made against single folders if they are empty, meaning that they contain no assets or subfolders. If a folder is of type Program, or has the isSystem field set to true, it cannot be deleted.

DELETE FROM Folders WHERE Id = 1996
DELETE FROM Folders WHERE Name in ('Marketo1','Marketo2')

Columns

Name	Type	ReadOnly	Filterable	Description
Id [KEY]	Integer	True	True	The unique, Marketo-assigned identifier of the folder.
Name	String	False	True	The name of the folder.
Description	String	False		The description of the folder.
Type	String	True		The type of the folder.
CreatedAt	Datetime	True		The date and time the folder was created.
UpdatedAt	Datetime	True		The date and time the folder was last updated.
ParentId	Integer	False		The Id of the parent folder.
ParentType	String	False		The type of the parent folder.
Path	String	True		The path of a folder shows its hierarchy in the folder tree, similar to a Unix-style path.
WorkSpace	String	True	True	The name of the smart campaign workspace.
URL	String	True		The explicit URL of the asset in the designated instance.
IsSystem	Boolean	True		Whether or not the folder is a system folder.
IsArchive	Boolean	False		Whether or not the folder is archived.
AccessZoneId	Integer	True		The access zone id

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
RootFolderId	Integer	The parent folder ID under which the query will be performed.
RootFolderType	String	The parent folder type under which the query will be performed. The allowed values are Folder, Program. The default value is Folder.
MaxDepth	Integer	Maximum folder depth to traverse. The default value is 2.

Create, update, delete and query Forms for a Marketo organization.

Table Specific Information

Select

Note: All filterable columns must be specified using the '=' operator.

Retrieve a list of accessible forms from the target instance.

SELECT * FROM Forms

Retrieve the form for the given Id.

SELECT * FROM Forms WHERE Id = '1214'

INSERT

To create a new form, specify at least the Name, FolderId and FolderType column.

INSERT INTO Forms (Name, Description, FolderId, FolderType) VALUES ('My Snippet', 'Test Snippet insert', 1089, 'Program')

Update

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

UPDATE Forms SET Description = 'Testing Update', Name = 'Test Update' WHERE Id = '1214'

Delete

To delete a Snippet you can specify the ID or Name field.

DELETE FROM Forms WHERE Id = '1214'
DELETE FROM Forms WHERE Name in ('Test1', 'Test2')

Columns

Name	Type	ReadOnly	Filterable	Description
Id [KEY]	Integer	True	True	Id of the asset.
Name	String	False	True	Name of the asset.
ButtonLabel	String	False		Label text of the button.
ButtonLocation	Integer	False		Location in pixels of the button relative to the left of the form.
CreatedAt	Datetime	True		Datetime the asset was created.
Description	String	False		Description of the asset.
FolderId	Integer	False	True	Id of the folder.
FolderType	String	False	True	Type of folder.
FontFamily	String	False		font-family property for the form.
FontSize	String	False		font-size property of the form.
KnownVisitorTemplate	String	False		Template of the known visitor behavior for the form.
KnownVisitorType	String	False		Type of the known visitor behavior for the form.
LabelPosition	String	False		Default positioning of labels.
Language	String	False		Language of the form.
Locale	String	False		Locale of the form.
ProgressiveProfiling	Boolean	False		Whether progressive profiling is enabled for the form.
Status	String	False	True	Status filter for draft or approved versions. The allowed values are approved, draft.
Theme	String	False		CSS theme for the form to use.
UpdatedAt	Datetime	True		Datetime the asset was most recently updated.
Url	String	False		Url of the asset in the Marketo UI.
WaitingLabel	String	False		Waiting text of the button.

Create, update, delete and query Landing Pages for a Marketo organization.

Table Specific Information

Select

Note: All filterable columns must be specified using the '=' operator.

Retrieve a list of accessible landing pages from the target instance, filterable by Status and folder.

SELECT * FROM LandingPages WHERE Status = 'draft'

SELECT * FROM LandingPages WHERE FolderId = 1184 AND FolderType = 'Program'

Retrieve the landing page record for the given name or a target Id.

SELECT * FROM LandingPages WHERE Id = 1234

SELECT * FROM LandingPages WHERE Name = 'Agenda'

INSERT

To create a new LandingPage, specify at least the Name, FolderId, FolderType and Template column.

INSERT INTO LandingPages (CustomHeadHTML, Description, FacebookOgTags, FolderId, FolderType, Keywords, MobileEnabled, Name, FormPrefill, Robots, Template, Title, URL, Workspace) VALUES ('<!DOCTYPE html>\n<html>\n<body>\n<h1>My First Heading</h1>\n<p>My first paragraph.</p>\n</body></html>', 'Testing  Insert operation', '', 1184, 'Program', '', false, 'Test Insert', false, 'index, nofollow', 1, 'Insert Operation', 'http://na-ab23.marketo.com/lp/119-IEY-862/LPtest_08.html', 'CRH')

Update

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

UPDATE LandingPages SET CustomHeadHTML = '<!DOCTYPE html>\n<html>\n<body>\n<h1>My First Heading</h1>\n<p>My first paragraph.</p>\n</body></html>', Description = 'Testing Update', FacebookOgTags = '', Keywords = '', MobileEnabled = false, Name = 'Test Update', Robots = 'index, nofollow', Title = 'Update Operation', URL = 'http://na-ab23.marketo.com/lp/119-IEY-862/LPtest_08.html' WHERE Id = 1103

Delete

To delete a LandingPage you can specify the ID or Name field.

DELETE FROM LandingPages WHERE Id = 1996
DELETE FROM LandingPages WHERE Name in ('Test1', 'Test2')

Columns

Name	Type	ReadOnly	Filterable	Description
Id [KEY]	Integer	True	True	Id of the asset.
Name	String	False	True	Name of the asset.
ComputedUrl	String	True		Computed Url of the asset.
CreatedAt	Datetime	True		Datetime the asset was created.
CustomHeadHTML	String	False		Any custom HTML to embed in the tag of the page.
Description	String	False		Description of the asset.
FacebookOgTags	String	False		Any OpenGraph meta tags to apply to the page.
FolderId	Integer	False	True	Id of the folder.
FolderType	String	False	True	Type of folder. The allowed values are Folder, Program.
FolderName	String	False	False	Name of folder.
FormPrefill	Boolean	False		Boolean to toggle whether forms embedded in the page will prefill. Default false. The default value is false.
Keywords	String	False		Keywords
MobileEnabled	Boolean	False		Whether the page has mobile viewing enabled. Free-form pages only. Default false. The default value is false.
Robots	String	False		Robots directives to apply to the pages meta tags
Status	String	True	True	Status filter for draft or approved versions. The allowed values are approved, draft.
Template	Integer	False		Id of the template used.
Title	String	False		Title element of the landing page.
UpdatedAt	Datetime	True		Datetime the asset was most recently updated.
URL	String	False		Url of the asset in the Marketo UI. You have to send the URL path of the page while creating or updating.
Workspace	String	False		Name of the workspace.

Create, update, delete and query LandingPageTemplates for a Marketo organization.

Table Specific Information

Select

Note: All filterable columns must be specified using the '=' operator.

Retrieve a list of accessible landing page templates from the target instance, filterable by Name, Status and folder.

SELECT * FROM LandingPageTemplates WHERE Status = 'draft'

SELECT * FROM LandingPageTemplates WHERE FolderId = 1184 AND FolderType = 'Program'

Retrieve the landing page template record for the given name or a target Id.

SELECT * FROM LandingPageTemplates WHERE Id = 1234

SELECT * FROM LandingPageTemplates WHERE Name = 'Agenda'

INSERT

To create a new LandingPageTemplate, specify at least the Name, FolderId, FolderType and TemplateType column.

INSERT INTO LandingPageTemplates (Description, EnableMunchkin, FolderId, FolderType, Name, TemplateType) VALUES ('Testing Insert', true, 19, 'Folder', 'Test Insert 1', 'guided')

Update

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

UPDATE LandingPageTemplates SET Description = 'Testing Update', EnableMunchkin = false, Name = 'Test Update' WHERE Id = 1312

Delete

To delete a LandingPageTemplate you can specify the ID or Name field.

DELETE FROM LandingPageTemplates WHERE Id = 1312
DELETE FROM LandingPageTemplates WHERE Name in ('Test1', 'Test2')

Columns

Name	Type	ReadOnly	Filterable	Description
Id [KEY]	Integer	True	True	Id of the asset.
Name	String	False	True	Name of the asset.
CreatedAt	Datetime	True		Datetime the asset was created.
Description	String	False		Description of the asset.
EnableMunchkin	Boolean	False		Whether to enable munchkin on the derived pages. Defaults to true. The default value is true.
FolderId	Integer	False	True	Id of the folder.
FolderType	String	False	True	Type of folder. The allowed values are Folder, Program.
FolderName	String	False		Name of folder.
Status	String	True	True	Status filter for draft or approved versions. The allowed values are draft, approved.
TemplateType	String	False		Type of template to create 'guided' or 'freeForm' The allowed values are guided, freeForm. The default value is freeForm.
UpdatedAt	Datetime	True		Datetime the asset was most recently updated.
Url	String	True		Url of the asset in the Marketo UI.
Workspace	String	True		Name of the workspace.

Create, update, delete, and query Leads for a Marketo organization.

Table Specific Information

Select

All columns must be specified using the '=' operator. If a column is filterable, you specify multiple values by use of the IN operator or the OR logical operator.

To optimize response time from the server, identify only the rows and columns you want to retrieve.

SELECT Id, FirstName, LastName FROM Leads WHERE Id IN (1, 2, 5, 10)

You will get the best performance from this query if you can confine your query to a list of known Leads within Marketo. To do this, create a static list of Leads within Marketo, and then specify the ListId to retrieve them.

If no filter is specified, the Activities_NewLead table is queried to retrieve a list of Lead Ids. After the Lead Ids are compiled, they are used to query the Leads table. Since one Activities_Newlead request must be made for each Leads request made, when no filter is specified it effectively doubles the number of API calls made per lead. This affects query performance.

For example:

• To limit the returned Leads to those created during a specific time period, filter on the 'CreatedAt' column. When you use the '>' or '>=' operator, the datetime value is included in the Activities_NewLead table request. Since the maximum batch size per request for the REST API is 300, you can get a rough estimate of the number of API calls this query will require using the formula:
  

  (Total Number of Leads / 300) * 2

• To limit the returned Leads to those updated at a particular datetime, filter on the 'UpdatedAt' column. When you use the '>' or '>=' operator, the datetime value is included in the Activities_LeadChanges table request. Since the maximum batch size per request for the REST API is 300, you can get a rough estimate of the number of API calls this query will require using the formula:
  

  (Total Number of Leads / 300) * 2

You can also use the SOAP API to retrieve a list of Lead Ids by setting "UseSOAPForLeadIds=True" in the 'Other' property. When UseSOAPForLeadIDs is True and the SOAP connection details are specified, the SOAP API compiles a list of Lead Ids which will then be used as a filter for the REST API.

This hybrid approach is faster than using the SOAP API by itself, because the SOAP API is significantly slower than the REST API. Since the maximum batch size per request for the SOAP API is 1000, you can get a rough estimate of the number of API calls this query will require using the formula:

(Total Number of Leads / 1000) + (Total Number of Leads / 300)

Insert

To create a new Lead record, specify the Lead's first name, last name, email address, and company name for entry into the database.

For example, to insert a new lead for someone named John Mangel with an email address of [email protected], enter:

INSERT INTO Leads (Email, FirstName, LastName) VALUES ('[email protected]', 'John', 'Mangel')

To insert multiple leads at once via a #TEMP table, first create the #TEMP table, and then insert that table into your Leads table.

The following example creates a #TEMP table with three new Leads, and then inserts that #TEMP table into the Leads table:

INSERT INTO Leads#TEMP (FirstName, LastName, Email, Company) VALUES ('John', 'Mangel', '[email protected]', 'ABC')
INSERT INTO Leads#TEMP (FirstName, LastName, Email, Company) VALUES ('Steve', 'Puth', '[email protected]', 'ABC')
INSERT INTO Leads#TEMP (FirstName, LastName, Email, Company) VALUES ('Andrew', 'Stack', 'andy@abc', 'ABC')

INSERT INTO Leads (FirstName, LastName, Email, Company) SELECT FirstName, LastName, Email, Company FROM Leads#TEMP

To import multiple leads from a CSV file, ensure UseBulkAPI is set to True, then enter a command similar to the following:

INSERT INTO Leads (CSVFile) VALUES ('C:\\\\Upload\\\\ImportLeads.csv')

Update

You can update any field in the Leads table that is not read-only. Updates are performed using any 'Filterable' column, such as Email, as a lookup field (external key). (To identify all the ReadOnly and Filterable columns in the Leads table, see "Columns", below.)

For example:

• To update the Leads table to assign 111-222-3333 as the MobilePhone entry to all rows where Id=1 (Id is the lookup field):
  

  UPDATE Leads SET MobilePhone = '111-222-3333' WHERE Id = 1

• To update the Leads table to assign 111-222-3333 as the MobilePhone entry to all rows where [email protected] (Email is the lookup field):
  

  UPDATE Leads SET MobilePhone = '111-222-3333' WHERE Email = '[email protected]'

You can also use a custom field as the lookup field. To do this, you must clearly identify that the custom field is being used in this manner, by first defining the LookupField as the custom field. For example, to assign 111-222-3333 as the MobilePhone entry to all rows where MyCustomField=my value (MyCustomField is the lookup field):

UPDATE Leads SET MobilePhone = '111-222-3333' WHERE LookupField = 'MyCustomField' AND MyCustomField = 'my_value'

Delete

To remove a lead from the Leads table, you must identify the lead by its Marketo Id. For example, to delete the lead whose Marketo Id=1, enter:

DELETE FROM Leads WHERE Id = 1

GetDeleted

To retrieve a list of all leads that have been deleted from the Leads Table in the past 14 days, use the GetDeleted query.

GetDeleted FROM Leads

To retrieve a list of all leads that have been deleted since the table's last update, use the GetDeleted query with the UpdatedAt filter.

GetDeleted FROM Leads UpdatedAt='date'

Columns

Name	Type	ReadOnly	Filterable	Description
Id [KEY]	Int	False	True	This is a generated column, no description is available.
Company	String	False		This is a generated column, no description is available.
Site	String	False		This is a generated column, no description is available.
BillingStreet	String	False		This is a generated column, no description is available.
BillingCity	String	False		This is a generated column, no description is available.
BillingState	String	False		This is a generated column, no description is available.
BillingCountry	String	False		This is a generated column, no description is available.
BillingPostalCode	String	False		This is a generated column, no description is available.
Website	String	False		This is a generated column, no description is available.
MainPhone	String	False		This is a generated column, no description is available.
AnnualRevenue	Decimal	False		This is a generated column, no description is available.
NumberOfEmployees	Int	False		This is a generated column, no description is available.
Industry	String	False		This is a generated column, no description is available.
SicCode	String	False		This is a generated column, no description is available.
MktoCompanyNotes	String	False		This is a generated column, no description is available.
ExternalCompanyId	String	False		This is a generated column, no description is available.
MktoName	String	True		This is a generated column, no description is available.
PersonType	String	False		This is a generated column, no description is available.
MktoIsPartner	Bool	False		This is a generated column, no description is available.
IsLead	Bool	False		This is a generated column, no description is available.
MktoIsCustomer	Bool	False		This is a generated column, no description is available.
IsAnonymous	Bool	False		This is a generated column, no description is available.
Salutation	String	False		This is a generated column, no description is available.
FirstName	String	False		This is a generated column, no description is available.
MiddleName	String	False		This is a generated column, no description is available.
LastName	String	False		This is a generated column, no description is available.
Email	String	False	True	This is a generated column, no description is available.
Phone	String	False		This is a generated column, no description is available.
MobilePhone	String	False		This is a generated column, no description is available.
Fax	String	False		This is a generated column, no description is available.
Title	String	False		This is a generated column, no description is available.
ContactCompany	Int	True		This is a generated column, no description is available.
DateOfBirth	Date	False		This is a generated column, no description is available.
Address	String	False		This is a generated column, no description is available.
City	String	False		This is a generated column, no description is available.
State	String	False		This is a generated column, no description is available.
Country	String	False		This is a generated column, no description is available.
PostalCode	String	False		This is a generated column, no description is available.
PersonTimeZone	String	True		This is a generated column, no description is available.
OriginalSourceType	String	True		This is a generated column, no description is available.
OriginalSourceInfo	String	True		This is a generated column, no description is available.
RegistrationSourceType	String	False		This is a generated column, no description is available.
RegistrationSourceInfo	String	False		This is a generated column, no description is available.
OriginalSearchEngine	String	True		This is a generated column, no description is available.
OriginalSearchPhrase	String	True		This is a generated column, no description is available.
OriginalReferrer	String	True		This is a generated column, no description is available.
EmailInvalid	Bool	False		This is a generated column, no description is available.
EmailInvalidCause	String	False		This is a generated column, no description is available.
Unsubscribed	Bool	False		This is a generated column, no description is available.
UnsubscribedReason	String	False		This is a generated column, no description is available.
DoNotCall	Bool	False		This is a generated column, no description is available.
MktoDoNotCallCause	String	False		This is a generated column, no description is available.
DoNotCallReason	String	False		This is a generated column, no description is available.
MarketingSuspended	Bool	False		This is a generated column, no description is available.
MarketingSuspendedCause	String	False		This is a generated column, no description is available.
BlackListed	Bool	False		This is a generated column, no description is available.
BlackListedCause	String	False		This is a generated column, no description is available.
MktoPersonNotes	String	False		This is a generated column, no description is available.
AnonymousIP	String	False		This is a generated column, no description is available.
InferredCompany	String	True		This is a generated column, no description is available.
InferredCountry	String	True		This is a generated column, no description is available.
InferredCity	String	True		This is a generated column, no description is available.
InferredStateRegion	String	True		This is a generated column, no description is available.
InferredPostalCode	String	True		This is a generated column, no description is available.
InferredMetropolitanArea	String	True		This is a generated column, no description is available.
InferredPhoneAreaCode	String	True		This is a generated column, no description is available.
EmailSuspended	Bool	False		This is a generated column, no description is available.
EmailSuspendedCause	String	False		This is a generated column, no description is available.
EmailSuspendedAt	Datetime	False		This is a generated column, no description is available.
Department	String	False		This is a generated column, no description is available.
CreatedAt	Datetime	True	True	This is a generated column, no description is available.
UpdatedAt	Datetime	True	True	This is a generated column, no description is available.
Cookies	String	False	True	This is a generated column, no description is available.
ExternalSalesPersonId	String	False		This is a generated column, no description is available.
LeadPerson	Int	True		This is a generated column, no description is available.
LeadRole	String	False		This is a generated column, no description is available.
LeadSource	String	False		This is a generated column, no description is available.
LeadStatus	String	False		This is a generated column, no description is available.
LeadScore	Int	False		This is a generated column, no description is available.
Urgency	Double	False		This is a generated column, no description is available.
Priority	Int	False		This is a generated column, no description is available.
RelativeScore	Int	False		This is a generated column, no description is available.
RelativeUrgency	Int	False		This is a generated column, no description is available.
Rating	String	False		This is a generated column, no description is available.
PersonPrimaryLeadInterest	Int	True		This is a generated column, no description is available.
LeadPartitionId	Int	False		This is a generated column, no description is available.
LeadRevenueCycleModelId	Int	False		This is a generated column, no description is available.
LeadRevenueStageId	Int	False		This is a generated column, no description is available.
AcquisitionProgramId	Int	False		This is a generated column, no description is available.
MktoAcquisitionDate	Datetime	False		This is a generated column, no description is available.
TestKpQA	String	False		This is a generated column, no description is available.
TestCustomfieldEmail	String	False		This is a generated column, no description is available.
Ecids	String	True		This is a generated column, no description is available.
TestFieldText1	String	False		This is a generated column, no description is available.
Test1	Bool	False		This is a generated column, no description is available.
Cstmfdtest1	String	False		This is a generated column, no description is available.
Cstmfdtest2	String	False		This is a generated column, no description is available.
Test	String	False		This is a generated column, no description is available.
Test98	String	False		This is a generated column, no description is available.
LookupField	String	False	True	This is filter only column that will not contain data.
ListId	Int	False	True	This is filter only column that will not contain data.
ProgramId	Int	False	True	This is filter only column that will not contain data.
PartitionName	String	False	True	This is filter only column that will not contain data.
MembershipAcquiredBy	String	True	False	This is a generated column, that is only available when filtering by ProgramId.
MembershipIsExhausted	Bool	True	False	This is a generated column, that is only available when filtering by ProgramId.
MembershipMembershipDate	Datetime	True	False	This is a generated column, that is only available when filtering by ProgramId.
MembershipNurtureCadence	String	True	False	This is a generated column, that is only available when filtering by ProgramId.
MembershipProgressionStatus	String	True	False	This is a generated column, that is only available when filtering by ProgramId.
MembershipReachedSuccess	Bool	True	False	This is a generated column, that is only available when filtering by ProgramId.
MembershipReachedSuccessDate	Datetime	True	False	This is a generated column, that is only available when filtering by ProgramId.
MembershipStream	String	True	False	This is a generated column, that is only available when filtering by ProgramId.
MembershipUpdatedAt	Datetime	True	False	This is a generated column, that is only available when filtering by ProgramId.