Forms

Create, update, delete and query Forms for a Marketo organization.

Table Specific Information

Note: All filterable columns must be specified using the '=' operator.

Retrieve a list of accessible forms from the target instance.

SELECT * FROM Forms

Retrieve the form for the given Id.

SELECT * FROM Forms WHERE Id = '1214'

To create a new form, specify at least the Name, FolderId and FolderType column.

INSERT INTO Forms (Name, Description, FolderId, FolderType) VALUES ('My Snippet', 'Test Snippet insert', 1089, 'Program')

Any field that is not read-only can be updated.

UPDATE Forms SET Description = 'Testing Update', Name = 'Test Update' WHERE Id = '1214'

To delete a Snippet you can specify the ID or Name field.

DELETE FROM Forms WHERE Id = '1214'
DELETE FROM Forms WHERE Name in ('Test1', 'Test2')


Name	Type	ReadOnly	Filterable	Description
Id [KEY]	Integer	True	True	Id of the asset.
Name	String	False	True	Name of the asset.
ButtonLabel	String	False		Label text of the button.
ButtonLocation	Integer	False		Location in pixels of the button relative to the left of the form.
CreatedAt	Datetime	True		Datetime the asset was created.
Description	String	False		Description of the asset.
FolderId	Integer	False	True	Id of the folder.
FolderType	String	False	True	Type of folder.
FontFamily	String	False		font-family property for the form.
FontSize	String	False		font-size property of the form.
KnownVisitorTemplate	String	False		Template of the known visitor behavior for the form.
KnownVisitorType	String	False		Type of the known visitor behavior for the form.
LabelPosition	String	False		Default positioning of labels.
Language	String	False		Language of the form.
Locale	String	False		Locale of the form.
ProgressiveProfiling	Boolean	False		Whether progressive profiling is enabled for the form.
Status	String	False	True	Status filter for draft or approved versions. 使用できる値は次のとおりです。approved, draft
Theme	String	False		CSS theme for the form to use.
UpdatedAt	Datetime	True		Datetime the asset was most recently updated.
Url	String	False		Url of the asset in the Marketo UI.
WaitingLabel	String	False		Waiting text of the button.