Excel Add-In for Marketo

Build 23.0.8839

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 can specify the ID or Name field.

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

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.

使用できる値は次のとおりです。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) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839