This content has been marked as final. Show 5 replies
I would recommend try a shorter timerange first (a day or week).
Thanks for quick reply Murtza,
I am wondering if "LastModifiedDateTime" the only way to limit these rows? When I try to look for all columns on "Lead" object, this modified-date-time is not one of the columns. Do you what other columns that are better for limiting row sets and also increase performance?
On a good news front, when I pulled in limited set of columns for just 1 day range, I got about 220K+ leads; however within the data flow I am not able to enable that data source nor am I able to set primary key etc.
Can you please tell me how Lead object is linked to various Activity_ objects? Is the activity_id and lead_id same across all tables? I dont know if I am asking details that are not usually disclosed, but I am essentially looking for Marketo datamodel.
Please dont apologize and you were definitely helping. That link provided gives valuable information for developers who are using SOAP API and writing custom code. We are using a DW SAAS solution called Birst and they got a connector built to access Marketo via SOAP.
When I try to pull leads using "LastModifiedDateTime" for a single day span, its pulling so many leads, that its puzzling me. So I am trying to research how the leads-> activity objects are linked.