Forms
Create, update, delete and query Forms 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 FORMS WHERE status='draft'
SELECT * FROM FORMS WHERE Id=1001
SELECT * FROM FORMS WHERE Name='Form1'
SELECT * FROM FORMS WHERE Id=1001 AND Status='draft'
SELECT * FROM FORMS WHERE FolderId=1089 AND FolderType='Program'
SELECT * FROM FORMS WHERE FolderId=1002
Insert
INSERT INTO Forms (Name, Description, FolderId, FolderType, FontFamily, FontSize, LabelPosition, Language, Locale, ProgressiveProfiling)
VALUES ('test insert form', 'test form description', 1089, 'Program', 'Arial', '12px', 'left', 'English', 'en_US', true)
Update
UPDATE Forms SET Name='test update form', Description='Testing Update', FontSize='13px' WHERE Id=1016
Delete
DELETE FROM Forms WHERE Id=1004
DELETE FROM Forms WHERE Id=1004 AND Status='draft'
DELETE FROM Forms WHERE Name IN ('test', 'My Snippet')
Columns
| Name | Type | ReadOnly | Operators | Description |
| Id [KEY] | Int | True | = |
The unique, Marketo-assigned identifier of the form. |
| Status [KEY] | String | True | = |
Status of the form, draft or approved versions. |
| Name | String | False | = |
The name of the form. |
| Description | String | False |
The description of the form. | |
| URL | String | True |
The URL of the form in the Marketo UI. | |
| KnownVisitorTemplate | String | False |
Template of the known visitor behavior for the form. | |
| KnownVisitorType | String | False |
Type of the known visitor behavior for the form. | |
| Theme | String | False |
CSS theme for the form to use. | |
| Language | String | False |
Language of the form. | |
| Locale | String | False |
Locale of the form. | |
| ProgressiveProfiling | Bool | False |
Whether progressive profiling is enabled for the form. | |
| LabelPosition | String | False |
Default positioning of labels. | |
| ButtonLabel | String | False |
Label text of the button. | |
| ButtonWaitingLabel | String | False |
Waiting text of the button. | |
| ButtonLocation | Int | False |
Location in pixels of the button relative to the left of the form. | |
| FontFamily | String | False |
font-family property for the form. | |
| FontSize | String | False |
font-size property of the form. | |
| FolderId | Int | False | = |
The unique, Marketo-assigned identifier of the parent folder/program. |
| FolderName | String | True |
The name of the folder | |
| FolderType | String | False | = |
The type of folder (Folder,Program) |
| WorkspaceId | Int | True |
Workspace Id of the asset. | |
| CreatedAt | Datetime | True |
Datetime the form was created. | |
| UpdatedAt | Datetime | True |
Datetime the form was most recently updated. | |
| ThankYouList | String | True |
JSON array of ThankYouPage JSON objects. |