Programs

Query Programs for a Marketo organization.

Table Specific Information

Select

Note: Tag and Cost columns are not returned when browsing all Programs (such as performing a SELECT * query). These columns are only returned when filtering by a specific Program Id or Name.

Tag and Cost Columns are not returned in this case.

SELECT * FROM Programs

Tag and Cost Columns are returned in this case.

SELECT * FROM Programs WHERE Id = '1001'

INSERT

To create a new Program record, specify the information about the Program to be entered into the database.

The following example demonstrates how to insert a new Program:

INSERT INTO Programs (Name, FolderId, FolderType, Type, Description, Channel, TagTypes, TagValues, CostStartDates, Costs, CostNotes) VALUES ('InsertEvent', '35', 'Folder', 'Default', 'Test Insert Description', 'Email Blast', 'Program Owner', 'Admin', '01/01/2015,02/02/2015', '100,200', 'January,February')

Update

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

UPDATE Programs SET Name = 'UpdatedProgram', Description = 'Updated Description' WHERE Id = '1'

Delete

Delete is used to remove programs from Marketo. To perform a delete, you can specify Id or Name field.

DELETE FROM Programs WHERE Id = '1'
DELETE FROM Programs WHERE Name in ('Test1', 'Test2')

Note: FolderId and FolderName can be included when inserting a new record, but they cannot be updated in existing records (read-only once a record exists).

Columns


Name	Type	ReadOnly	Filterable	Description
Id [KEY]	Integer	True	True	The unique, Marketo-assigned identifier of the program.
Name	String	False	True	The name of the program.
Description	String	False		The description of the program.
Type	String	False		The program type.
Channel	String	False		The channel the program is associated with.
Workspace	String	False		The name of the workspace where the program is located.
Url	String	True		The URL reference to the program.
Status	String	False		The status of the program.
FolderType	String	False		The folder type that the program is contained in.
FolderId	Integer	False		The folder id that the program is contained in.
FolderName	String	False		The name of the folder the program is contained in.
TagTypes#	String	False	True	A comma-separated list of tag types associated with the program. Each TagType has a value associated with it which is returned via the TagValue column.
TagValues#	String	False	True	A comma-separated list of tag values. Each value corresponds to the type listed within the TagTypes column.
CostStartDates#	String	False		A comma-separated list of cost start dates. Each value corresponds to the costs and notes listed within the Costs and CostNotes columns.
Costs#	String	False		A comma-separated list of costs (integer values). Each value corresponds to the start dates and notes listed within the CostStartDates and CostNotes columns.
CostNotes#	String	False		A comma-separated list of cost notes. Each value corresponds to the costs and start dates listed within the Costs and CostStartDates columns.
CreatedAt	Datetime	True		The date and time the program was created.
UpdatedAt	Datetime	True		The date and time the program was last updated.