What's the exact range when using LastUpdateAtSelector for getMultipleLeads | Community
Skip to main content
January 24, 2014
Question

What's the exact range when using LastUpdateAtSelector for getMultipleLeads

  • January 24, 2014
  • 2 replies
  • 619 views
Hi all,

When getting Leads from Marketo, I make a 'LastUpdateAtSelector' instance to limit the data range.
But I'm not sure whether a record would be returned when it is updated exactly at the specified 'oldestUpdatedAt' time or 'latestUpdatedAt' time.
In the help http://developers.marketo.com/documentation/soap/getmultipleleads/ , I'm puzzled by the words 'since' and 'until'. Which one would be contained in the range? Or both?

Best Regards,
Biao
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

January 24, 2014
Here's a sample request XML, where oldestUpdated value is the 19th of Jan and latest is 22nd Jan.  All leads updated in this window of time (ie, between 2014-01-19T07:18:11.575-08:00 and  2014-01-22T07:18:11.557-08:00)will be returned in the response.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ns2:paramsGetMultipleLeads xmlns:ns2="http://www.marketo.com/mktows/">
    <leadSelector xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="ns2:LastUpdateAtSelector">
        <latestUpdatedAt>2014-01-22T07:18:11.557-08:00</latestUpdatedAt>
        <oldestUpdatedAt>2014-01-19T07:18:11.575-08:00</oldestUpdatedAt>
    </leadSelector>
    <batchSize>150</batchSize>
    <includeAttributes>
        <stringItem>FirstName</stringItem>
        <stringItem>AnonymousIP</stringItem>
        <stringItem>Company</stringItem>
    </includeAttributes>
</ns2:paramsGetMultipleLeads>
January 26, 2014
Hi Raj,

Thank you very much for the usage information of LastUpdatedAtSelector.
Now I have a further question:
    Using your example, if I have a record updated at '2014-01-22T07:18:11.557-08:00' (just at the until-timestamp) and another record updated at '2014-01-19T07:18:11.575-08:00' (at the since-timestamp), would both of them returned for your example request? Or would one of them be excluded in the result?

Thanks,
Biao