Programs

Query and update Programs for a Marketo organization.

Table Specific Information

Select

Marketo allows the following columns to be used in the WHERE clause of a SELECT query: Id, Name, CreatedAt, UpdatedAt, CRMId, TagType, TagValue, WorkspaceName, WorkspaceId, and IncludeArchive. The Id, Name, and CRMId columns allow multiple values to be specified by using the OR logical operator. The CreatedAt and UpdateAt filters can be specified twice to create a date range.

SELECT * FROM Programs WHERE CreatedAt > '08/01/2014' AND CreatedAt <= '08/31/2014'

Update

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

Note that the Tag*** and Cost*** columns only take a single value. Therefore, they do not take a comma-separated list when performing an update.

UPDATE Programs SET TagType='Program Owner', TagValue='Admin', CostMonth='11/2014', CostAmount='30' WHERE Id='1002'

Columns


Name	Type	ReadOnly	Description
Id [KEY]	Integer	True	The unique, Marketo-assigned identifier of the program.
Name	String	True	The name of the program.
Description	String	True	The description of the program.
WorkspaceId	String	True	The Id of the workspace where the program is located.
WorkspaceName	String	True	The name of the workspace where the program is located.
TreePath	String	True	The folder structure tree path describing the location of the program.
IsArchived	String	True	Specifies whether the program is archived.
TagType#	String	False	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.
TagValue#	String	False	A comma-separated list of tag values. Each value corresponds to the type listed within the TagTypes column.
CostMonth#	String	False	A comma-separated list of period cost months for the program.
CostAmount#	String	False	A comma-separated list of period cost amounts for the program.
CostId#	String	False	A comma-separated list of period cost Ids for the program.
CostNote#	String	False	A comma-separated list of period cost notes for the program.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.