ProgramMembers

Query Program Members in Marketo.

UpdateLeadProgramStatus can be used to update the membership status of a lead.

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.

Tip: This table uses server-side projection. Performance can be improved by minimizing the number of columns in projection.

Note: The REST API throws an error if you query program members for a program with more than 100'000 members. You can set UseBulkAPI to 'true' or 'auto' to automatically use the BULK API to retrieve the records.

	SELECT * FROM ProgramMembers WHERE ProgramId=1001

Insert

This table supports BATCH INSERT when UseBulkAPI is set to false.

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

Update

This table supports BATCH UPDATE when UseBulkAPI is set to false.

	UPDATE ProgramMembers SET WebinarURL='wsfldknfs1.com', RegistrationCode='adcff5f12-a7c7-11eb-bcbc-0242ac130001' WHERE LeadId='13' AND ProgramId='1001'
	UPDATE ProgramMembers SET WebinarURL='[email protected]/sync' WHERE ProgramId=1001 AND LeadId IN (28, 29, -2)
	UPDATE ProgramMembers SET WebinarURL='[email protected]/sync' WHERE ProgramId IN (1001, 1018) AND LeadId IN (12, 14)

Upsert

This table supports only BULK UPSERT when UseBulkAPI is set to true.

	UPSERT INTO OpportunityRoles (ExternalOpportunityId, LeadId, IsPrimary, Role) VALUES ('testOpportunitiesInsert001', '4', false, 'Test')

Delete

This table supports BATCH DELETE when UseBulkAPI is set to false.

	DELETE FROM ProgramMembers WHERE ProgramId=1001 AND LeadId=21
	DELETE FROM ProgramMembers WHERE ProgramId=1001 AND LeadId IN (28, 29, -2)
	DELETE FROM ProgramMembers WHERE ProgramId IN (1001, 1018) AND LeadId IN (12, 14, -2)
	DELETE FROM ProgramMembers WHERE ProgramId=1001 AND registrationCode='494164'

Columns


Name	Type	ReadOnly	Operators	Description
ProgramId [KEY]	Int	False	=	Id of the program.
LeadId [KEY]	Int	False		Id of the lead.
UpdatedAt	Datetime	True		Datetime the records was most recently updated.
IsExhausted	Bool	True
NurtureCadence	String	True
StatusName	String	False	=,IN
AttendanceLikelihood	Int	True
CreatedAt	Datetime	True
MembershipDate	Datetime	True
Program	String	True
ReachedSuccess	Bool	True	=,IN
ReachedSuccessDate	Datetime	True
RegistrationLikelihood	Int	True
TrackName	String	True
WaitlistPriority	Int	True
AcquiredBy	Bool	False
FlowStep	Int	False	=,IN
RegistrationCode	String	False
ReiNewCustomField	String	False	=,IN
StatusReason	String	False
Test99	Int	False	=,IN
TestCustomObjFd	String	False	=,IN
UTMSource	String	False	=,IN
WebinarUrl	String	False