JDBC Driver for Marketo

Build 22.0.8462

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, the program Id field is required.

DELETE FROM Programs WHERE Id='1'

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462