Microsite
Create, update, delete, and query Microsites.
Table Specific Information
Select
The following limitation exists for filtering on datetime columns: The "=" operator cannot be used with datetime columns in the WHERE clause. However, the "<", ">", ">=", and "<=" operators can be used to filter on datetime columns.
Additionally, the UpdatedAt column only supports filtering with the '>' operator.
Oracle Eloqua also has limited support on multiple conditions. In many tables the AND condition between filters is not supported. If AND is included the server might not return any results, nor will it return an error.
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | Long | True |
The unique identifier of the microsite. |
| Name | String | False |
The name of the microsite. |
| Domains | String | False |
A list of domains for this micosite. |
| ScheduledFor | Datetime | False |
The date and time scheduled for the microsite. |
| SourceTemplatedId | Long | False |
The Id of the source template for the microsite. |
| DefaultLandingPageId | Long | False |
The Id of the default landing page for the microsite. |
| Description | String | False |
The description of the microsite. |
| FolderId | Long | False |
The Id of the folder for the microsite |
| Permissions | String | False |
The permissions of the microsite. |
| CreatedAt | Datetime | True |
Date the microsite was created. |
| CreatedBy | String | True |
The Id of the user who created the microsite. |
| AccessedAt | Datetime | False |
Date the microsite was accessed. |
| CurrentStatus | String | False |
The current status of the microsite. |
| Depth | String | False |
The depth of the microsite. |
| UpdatedAt | Datetime | True |
Date the microsite was updated. |
| UpdatedBy | String | True |
The Id of the user who last updated the microsite. |