Programs

Create, update, delete, and query Programs 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 Programs WHERE Id=6201
	SELECT * FROM Programs WHERE Id IN (6201, 6200, 6152, 6117)
	SELECT * FROM Programs WHERE Name='duplicateProgramName'
	SELECT * FROM Programs WHERE WorkspaceName='test'
	SELECT * FROM Programs WHERE FolderId=48
	SELECT * FROM Programs WHERE FolderId=48 AND folderType='Folder'
	SELECT * FROM Programs WHERE UpdatedAt >' 2023-03-28T00:19:32.000-04:00'
	SELECT * FROM Programs WHERE UpdatedA >=' 2023-03-28T00:19:32.000-04:00'
	SELECT * FROM Programs WHERE UpdatedAt =' 2023-03-28T00:19:32.000-04:00'
	SELECT * FROM Programs WHERE UpdatedAt <=' 2023-03-28T00:19:32.000-04:00' AND UpdatedAt>'2021-08-11T08:10:01.000Z'
	SELECT * FROM Programs WHERE UpdatedAt < '2023-03-28T00:19:32.000-04:00' AND UpdatedAt>'2021-08-11T08:10:01.000Z'

Insert

Inserting a new program:

	INSERT INTO Programs (Name, FolderId, FolderType, Type, Description, Channel)
	VALUES ('test insert program', '6152', 'Program', 'Event', 'Test Insert Description', 'Tradeshow')

Update

Updating a program:

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

Delete

	DELETE FROM Programs WHERE Id=2383
	DELETE FROM Programs WHERE Name='Sample0034'
	DELETE FROM Programs WHERE ID IN (1064, 1065, 1066, 1067)
	DELETE FROM Programs WHERE Name IN ('Sample0035', 'Sample0036', 'Sample0037')

Columns