Tokens

Create, delete, and query Tokens for a Marketo organization.

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.

	SELECT * FROM Tokens WHERE folderId=70
	SELECT * FROM Tokens WHERE folderId=70 and FolderType='Folder'

Insert

	INSERT INTO Tokens (Name, Type, Value, FolderId, FolderType) VALUES ('test insert token', 'text', 'test token value', 5365, 'Folder')

Delete

	DELETE FROM Tokens WHERE FolderId=1111 AND FolderType='Program' AND Name='testname2' AND Type='text'
	DELETE FROM Tokens WHERE FolderId=1112 AND FolderType='Program' AND Name='test'
	DELETE FROM Tokens WHERE FolderId=1112

Columns


Name	Type	ReadOnly	Operators	Description
Name [KEY]	String	False		The name of the Token.
Type [KEY]	String	False		The data type of the Token. The supported values are date, number, rich text, score, sfdc campaign and text
Value	String	False		The value of the Token.
ComputedURL	String	False		The Computed URL of the Token.
FolderId [KEY]	Int	False	=	The unique, Marketo-assigned identifier of the parent folder/program.
FolderType [KEY]	String	False	=	The type of folder (Folder,Program)

Excel Add-In for Marketo

Tokens

Select

Insert

Delete

Columns