Excel Add-In for Marketo

Build 23.0.8839

StaticLists

Create, update, delete and query Static Lists for a Marketo organization.

Table Specific Information

Select

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

Retrieve a list of Static List from the target instance, filterable by name.

SELECT * FROM StaticLists WHERE Name = 'test0319'

Retrieve the Static List record for the given target Id.

SELECT * FROM StaticLists WHERE Id = 1192

Retrieve the Static List record for the given folder.

SELECT * FROM StaticLists WHERE Folder = '{id:12,type:Folder}'

Insert

To create a new Static List, specify at least the FolderId, FolderType, Name and FolderName column.

INSERT INTO StaticLists (FolderId, FolderType, Name, FolderName) VALUES (12, 'folder', 'testvs', 'ManualList')

Update

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

UPDATE StaticLists SET Name = 'testupdate' WHERE Id = 1058

Delete

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

DELETE FROM StaticLists  WHERE Id = 1058
DELETE FROM StaticLists  WHERE Name in ('Test1', 'Test2')

Columns

Name Type ReadOnly Filterable Description
Id [KEY] Integer True True

Id of the static list.

Name String False True

Name of the static list.

CreatedAt Datetime True

Datetime the static list was created.

UpdatedAt Datetime True

Datetime the static list was most recently updated.

FolderId Integer False

Id of the folder.

FolderType String False

Type of folder.

FolderName String False

Type of folder.

ComputedUrl String False

Computed urls of static list.

Workspace String False

Workspace of static list.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
Folder String

The folder parameter can be used to specify the parent folder under which the query will be performed

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839