SOLVED

Best way to bulk export activity log data?

Go to solution
Anonymous
Not applicable

Best way to bulk export activity log data?

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!
Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: Best way to bulk export activity log data?

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

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

Re: Best way to bulk export activity log data?

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
Not applicable

Re: Best way to bulk export activity log data?

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
Not applicable

Re: Best way to bulk export activity log data?

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
Not applicable

Re: Best way to bulk export activity log data?

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
Not applicable

Re: Best way to bulk export activity log data?

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

Re: Best way to bulk export activity log data?

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