JDBC Driver for Marketo

Build 22.0.8462

Activities

Returns a list of activities from after a datetime given by the nextPageToken parameter.

Table Specific Information

SELECT

The driver uses the Marketo API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the driver.

  • ActivityDate supports the '<,>,>=,<='
  • ActivityTypeId supports the '=,IN'.
  • LeadId supports the '=,IN'.
  • ListId supports the '='
For example, the following query is processed server-side:
Select * from Activities where activitydate > '2022-09-3' and activitydate < '2022-09-5'

Select * from Activities where activitytypeid = 11

Select * from Activities where activitytypeid IN (11,12) and leadid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15)

Select * from Activities where ActivityTypeId='1' and  LeadId='123'

Columns

Name Type Filterable Description
Id [KEY] String True Unique id of the activity.
ActivityDate Datetime True Datetime of the activity.
ActivityTypeId Integer True Id of the activity type.
LeadId Integer True Id of the lead associated to the activity.
MarketoGUID String Unique id of the activity (128 character string).
PrimaryAttributeValue String Value of the primary attribute.
PrimaryAttributeValueId Integer Id of the primary attribute field.

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 String Id of a static list. If set, will only return activities of members of this static list.

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