Forum Post: Re: Marketo / Progress Ddc - The "where" Clause And The Soap Api

  • Thread starter Thread starter misingh
  • Start date Start date
Status
Not open for further replies.
M

misingh

Guest
Just to elaborate, ActivitytyRecords are retrieved based either on LeadID or by passing the activity change time (OLDESTUPDATEDAT and LATESTUPDATEDAT). So any filters on these fields are passed to the Marketo API. All other filters are evaluated in the driver after pulling data from Marketo API. Sample Queries: SELECT * FROM ACTIVITYRECORD WHERE (OLDESTUPDATEDAT = '2015-02-01 23:00:00') AND (LATESTUPDATEDAT = '2015-02-27 23:00:00') SELECT * FROM ActivityRecord WHERE LEADID=7

Continue reading...
 
Status
Not open for further replies.
Back
Top