LandingPageContentSection
Create, update, delete and query Content Sections of Landing Pages for a Marketo organization.
Note: This table uses the draft/approved versioning API. By default both versions are retrieved/modified. To interact with a specific version use the filter Status='draft' or Status='approved'.
Select
Note: Filters provided with one of the supported operators listed in the "Operators" column are processed server-side, all the other filters are processed client-side.
For example, the following queries are processed server-side:
SELECT * FROM LandingPageContentSection WHERE LandingPageId='2'
SELECT * FROM LandingPageContentSection WHERE LandingPageId='2' AND status='draft'
Insert
INSERT INTO LandingPageContentSection (LandingPageId, Content, Type, Height, Width, FormattingOptionsTop, FormattingOptionsLeft, Opacity, BorderColor, BackgroundColor, HideDesktop, HideMobile, ImageOpenNewWindow, FormattingOptionsZIndex)
VALUES (1009, '<html><body>Hello World!</body></html>', 'HTML', '100', '101', '1', '2', '0.8', '#ff00ff', '#00ffff', false, true, true, 1)
Update
UPDATE LandingPageContentSection BorderColor='#ff0000', BackgroundColor='#0000ff', HideMobile='true', ImageOpenNewWindow='true', Type='HTML', FormattingOptionsTop='1', FormattingOptionsLeft='2', Width='101', HideDesktop='false', Opacity='0.8', Content='<html><body>Hello World!</body></html>', Height='100', FormattingOptionsZIndex='1'
WHERE LandingPageId=1009 AND Id=1049
Delete
DELETE FROM LandingPageContentSection WHERE LandingPageId=1009
Columns
| Name | Type | ReadOnly | Operators | Description |
| Id [KEY] | String | True |
Id of the content section. | |
| LandingPageId [KEY] | String | False | = |
Id of the landing page to which the content section belongs to. |
| Status [KEY] | String | True | = |
Status filter for draft or approved versions. |
| Index | Int | True |
Index of the content section. Index orients the elements from lowest to highest. | |
| Type | String | False |
Type of content section. | |
| Content | String | False |
Content of the section. Expected values vary based on type. Image: An image URL. RichText: HTML Content. | |
| RawContent | String | True |
Raw content of the section. Expected values vary based on type. Image: An image URL. RichText: HTML Content. | |
| ContentType | String | True |
Content of the section. Expected values vary based on type. Image: An image URL. RichText: HTML Content. | |
| ContentURL | String | True |
Content of the section. Expected values vary based on type. Image: An image URL. RichText: HTML Content. | |
| LinkURL | String | False |
RL parameter of a link type section. | |
| FollowupType | String | False |
Follow-up behavior of a form. Only available for form-type content sections. Defaults to form defined behavior. | |
| FollowupValue | String | False |
Where to follow-up on form submission. When followupType is lp, accepts the integer id of a landing page. For url, it accepts a url string. | |
| Height | String | False |
The height of the content. | |
| MinHeight | String | True |
The min height of the content. | |
| Width | String | False |
The width of the content. | |
| MinWidth | String | True |
The min width of the content. | |
| FormattingOptionsTop | String | False |
The top margin of the content. | |
| FormattingOptionsLeft | String | False |
The left margin of the content. | |
| Opacity | String | False |
The opacity of the content. | |
| BorderWidth | String | False |
The border width of the content. | |
| BorderStyle | String | False |
The border style of the content. | |
| BorderColor | String | False |
The border color of the content. | |
| BackgroundColor | String | False |
The background color of the content. | |
| HideDesktop | Bool | False |
Hide the section when displayed on a desktop browser. Default false. | |
| HideMobile | Bool | False |
Hide the section when displayed on a desktop browser. Default false. | |
| ImageOpenNewWindow | String | False |
ImageOpenNewWindow | |
| FormattingOptionsZIndex | String | False |
The z-index of the content. |