JDBC Driver for Marketo

Build 22.0.8462

LeadPrograms

Query program membership for one lead.

Table Specific Information

Select

Note: All filterable columns must be specified using the '=' operator.

Retrieves a list of programs for the specific lead id.

SELECT * FROM LeadPrograms WHERE LeadId = 1021579

Columns

Name Type Filterable Description
Id Integer Unique integer id of a program record.
ProgressionStatus String Program status of the lead in the parent program.
ProgressionStatusType String Program status Type of the lead in the parent program.
IsExhausted Boolean Whether the lead is currently exhausted in the stream, if applicable.
AcquiredBy Boolean Whether the lead was acquired by the parent program.
ReachedSuccess Boolean Whether the lead is in a success-status in the parent program.
MembershipDate Datetime Date the lead first became a member of the program.
UpdatedAt Datetime Datetime when the program was most recently updated.

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
LeadId Integer The Marketo lead id

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