EmailAsset
Provides metadata for email assets, including subject lines, design, and configuration settings.
Select
The driver uses the Oracle Eloqua Reporting API to access entities. To query a view, a fully qualified query consisting of both the schema name and table name is required to avoid any ambiguity.
For example, the following query specifies the schema name followed by the table name to access this view:
SELECT * FROM ActivityDetails.EmailAsset;
Columns
| Name | Type | References | SupportedOperators | Description |
| emailID [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the email asset within Eloqua. | |
| emailCreatedByUserID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Identifier of the user who created the email asset. | |
| emailGroup | String | =,<>,>,<,>=,<=,IN,NOT IN | Name of the email group that the asset belongs to, used for categorization. | |
| emailGroupDescription | String | Text description of the email group, providing context for its purpose or use. | ||
| emailGroupID | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the email group associated with the asset. | |
| emailGroupIsDeleted | Bool | =,<>,>,<,>=,<=,IN,NOT IN | Flag indicating whether the email group has been marked as deleted. | |
| emailName | String | =,<>,>,<,>=,<=,IN,NOT IN | The display name assigned to the email asset. | |
| isArchived | Bool | =,<>,>,<,>=,<=,IN,NOT IN | Flag showing whether the email asset has been archived and is no longer active. | |
| isDeleted | Bool | =,<>,>,<,>=,<=,IN,NOT IN | Flag indicating whether the email asset has been deleted from Eloqua. | |
| lastModifiedDate | Datetime | Timestamp of the most recent update to the email asset record. | ||
| subjectLine | String | Subject line text of the email, as it appears in recipient inboxes. |