Best way to bulk export activity log data? | Community
Skip to main content
A
Anonymous
August 26, 2014
Solved

Best way to bulk export activity log data?

  • August 26, 2014
  • 6 replies
  • 3906 views
Hi,

I want to programatically (e.g., API) bulk export activity data in a give time window -- for example, download all 'Web Visit' events created in July 2014. Unfortunately, in the getting started documentation the only relevant API I see is getLeadActivity, which
  1. Only seems to be available via SOAP (I would prefer REST)
  2. Requires a key to identify a lead -- so if I have N leads this API requires N calls. I only want to make one call.
Any suggestions? If this isn't possible today, is there anything planned/on a roadmap to address this use case?

Thanks!
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by
1 - Unfortunately, this is not possible via the REST API.
2 - You could use getLeadChanges to query multiples leads at the same time:
http://developers.marketo.com/documentation/soap/getleadchanges/

There are client libraries available on GitHub that might allow you to developer this faster:
https://github.com/Marketo/Community-Supported-Client-Libraries

6 replies

A
Anonymous
Accepted solution
August 26, 2014
1 - Unfortunately, this is not possible via the REST API.
2 - You could use getLeadChanges to query multiples leads at the same time:
http://developers.marketo.com/documentation/soap/getleadchanges/

There are client libraries available on GitHub that might allow you to developer this faster:
https://github.com/Marketo/Community-Supported-Client-Libraries
A
Anonymous
August 26, 2014
Thanks for your prompt response!

I have a follow up question about getLeadChanges. The Request section reports that "LeadKeySelector: leadSelector->keyType" is required. However the request in the ruby sample code does not seem to include one? Is LeadKeySelector not required when exporting activity data?

Thanks!
A
Anonymous
August 27, 2014
I created the Ruby code samples, so it might be an error in my code. I am not sure, so I would recommend testing something like this to confirm. 



request = {
    :start_position => {
        :oldest_created_at => "2013-08-01T00:13:13+00:00" },
   #Added line below for leadSelector
    :leadSelector => { :email => 'example@example.com' },
    :activity_name_filter => {
    :stringItem => ["Visit Webpage", "Click Link"] },
    :batch_size => "10"
}
A
Anonymous
August 27, 2014
Also, quick FYI- we'll have the REST versions of these calls in a few months, so keep an eye out for the release notes!
A
Anonymous
August 27, 2014
Thanks Murtza and Erik, I'll experiment some and also keep an eyey out for the new REST API.
A
Anonymous
December 16, 2016

Hi,

You can try Data Loader for Marketo (DLM) which allows you to sync Marketo data to the database without any coding. You can also get activity data for a given time range and activity types including standard and custom types via friendly UI.

Here is the link to the article which you can know how to achieve it. Get Marketo Lead Activities via DLM now!

Feel free to contact us for further information. Thanks!

Vivian

Terms & ConditionsAccessibility statement

Loading footer...