JDBC Driver for Marketo

Build 22.0.8462

Activities

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.

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