Activities_CreateTask
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. |
| 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. |