JDBC Driver for Marketo

Build 22.0.8462

ProgramMembers

Query Program members for a program.

Table Specific Information

Select

Retrieve all Program Members for the specific ProgramId.

Note:

  • When UseBulkAPI=true and ProgramId is not specified, it will fetch the first ProgramId. We can only use =, IN operator with ProgramID.
  • When UseBulkAPI=false and ProgramId is not specified, it will fetch records for all the ProgramId. We can specify the =, IN, >, <, <=, >= operator with ProgramID.

SELECT * FROM ProgramMembers WHERE ProgramId = 1102
SELECT * FROM ProgramMembers WHERE ProgramId = '1044' AND LeadId IN ('1789','1789','1790','1791','1792')
SELECT * FROM ProgramMembers WHERE ProgramId = '1001' AND LeadId = '4'
SELECT * FROM ProgramMembers WHERE ProgramId IN (1102, 1103, 1104)
SELECT * FROM ProgramMembers WHERE LeadId IN ('1789','1790','1791','1792') AND reachedSuccess IN (false,true)
SELECT * FROM ProgramMembers WHERE reachedSuccess IN (false,true) AND LeadId = '1789'

Insert

To create a new Program Member, specify at least the LeadId, StatusName and ProgramId column.This operation is only supported when UseBulkApi=false.

INSERT INTO ProgramMembers (LeadId,StatusName,ProgramId) VALUES (4,'member','1001')

Update

Fields WebinarURL and RegistrationCode can be updated. To update any Program Member, specify at least the LeadId, ProgramId column.This operation is only supported when UseBulkApi=false.

UPDATE ProgramMembers SET WebinarURL = 'www.testURL.com',RegistrationCode = 'dcff5f12-a7c7-11eb-bcbc-0242ac130001' WHERE LeadId = '4' AND ProgramId = '1001'

Delete

To delete a Program member you must specify the LeadId and ProgramId field.This operation is only supported when UseBulkApi=false.

DELETE FROM ProgramMembers WHERE LeadId = '4' AND ProgramId = '1001'

Columns

Name Type ReadOnly Filterable Description
Id Integer True

The Id of the Program Member

AcquiredBy Boolean False

Indicates this program was responsible for creating the lead record

AttendanceLikelihood Integer False

The likelihood of the attendance at the individual level

LeadId [KEY] Integer False True

The Id of the Lead

MemberDate Datetime False

The date of the membership

NurtureProgramId String True

The Id of the Nurture Program

Program String False

The Program with which the member is associated

ProgramId [KEY] Integer False True

The Id of the Program

ProgramTypeId String True

The Id of the Program Type

RegistrationCode String False

The registration code

RegistrationLikelihood String False

The registration likelihood

Status String False

The Status of the Program Member

StatusId String True

The Id of the Status of the Program Member

StatusReason String False

The Reason of the Status of the Program Member

StatusName String False True

The name of the Status of the Program Member

ReachedSuccess Boolean False True

Indicates when a person reaches the status that achieves that goal

CreatedAt Datetime False

The created date of the membership

IsExhausted Boolean False

Indicates whether the membership is exhausted or not

MemberShipDate Datetime False

The date of the membership

NurtureCadence String False

The Nurture Program

ReachedSuccessDate Datetime False

The date when a person reaches the status that achieves that goal

UpdatedAt Datetime False

The updated date of the membership

Success Boolean False

Indicates when a person reaches the status that achieves that goal

Track String False

The track of the Program Member Activity

TrackName String False

The name of the track

WaitlistPriority Integer False

Indicates the program member waitlist priority

WebinarURL String False

The Webinar URL

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