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