JDBC Driver for Marketo

Build 22.0.8462

Forms

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

Table Specific Information

Select

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'

Insert

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')

Update

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

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

Delete

To delete a Snippet you must specify the ID field.

DELETE FROM Forms WHERE Id = '1214'

Columns

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.

The allowed values are 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462