Best way to bulk export activity log data?

[Anonymous]

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!

[Anonymous · Accepted solution]

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

[Anonymous]

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!

[Anonymous]

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"

}

[Anonymous]

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!

[Anonymous]

Thanks Murtza and Erik, I'll experiment some and also keep an eyey out for the new REST API.

[Anonymous]

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