Excel Add-In for Marketo

Build 23.0.8839

ProgramMembers

Create, update, delete, and query members for program in Marketo.

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 Int True

This is a generated column, no description is available.

AttendanceLikelihood Int True

This is a generated column, no description is available.

CreatedAt Datetime True

This is a generated column, no description is available.

IsExhausted Bool True

This is a generated column, no description is available.

LeadId [KEY] Int False True

This is a generated column, no description is available.

MembershipDate Datetime True

This is a generated column, no description is available.

NurtureCadence String True

This is a generated column, no description is available.

Program String True

This is a generated column, no description is available.

ProgramId [KEY] Int False True

This is a generated column, no description is available.

ReachedSuccess Bool True True

This is a generated column, no description is available.

ReachedSuccessDate Datetime True

This is a generated column, no description is available.

RegistrationLikelihood Int True

This is a generated column, no description is available.

StatusName String True True

This is a generated column, no description is available.

TrackName String True

This is a generated column, no description is available.

UpdatedAt Datetime True True

This is a generated column, no description is available.

WaitlistPriority Int True

This is a generated column, no description is available.

AcquiredBy Bool False

This is a generated column, no description is available.

FlowStep Int False True

This is a generated column, no description is available.

RegistrationCode String False

This is a generated column, no description is available.

ReiNewCustomField String False True

This is a generated column, no description is available.

StatusReason String False

This is a generated column, no description is available.

TestCustomObjFd String False True

This is a generated column, no description is available.

UTMSource String False True

This is a generated column, no description is available.

WebinarUrl String False

This is a generated column, no description is available.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839