JDBC Driver for Marketo

Build 22.0.8462

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.

Name Type Description
CreatedAt Datetime

Used when performing a GET. Filters programs by the date they were created.

UpdatedAt Datetime

Used when performing a GET. Filters programs by the date they were updated.

CRMId String

Used when performing a GET. The CRM Id associated with the program. (This value could refer to the Id of the Salesforce campaign connected to the program.)

IncludeArchive Boolean

Used when performing a GET. When set to 'True', will return archived programs.

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