Export Smart List Via API | Community
Skip to main content
A
Anonymous
March 4, 2016
Solved

Export Smart List Via API

  • March 4, 2016
  • 3 replies
  • 7709 views

We are attempting to export data from specific fields in a smart list to an external database via Marketo API.

I am having trouble finding documentation or other questions that cover this, can it be done?

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 SanfordWhiteman

Stephen, like Kenny said, Smart Lists are not accessible via API (when you think about the complexity and computation time that could potentially go into a SL, and the expectation that an API call will get the freshest data, it's understandable that this hasn't/yet been enabled).

A common workaround is adding to a static list via a batch campaign and then using the Get Leads by List ID method.

But if you are desperate to get Smart Lists as-is, you could think about using SL subscriptions and then processing the report with an email-to-database app.  Something to think about.  For a current client, I'm wondering if their client (the owners of the Mkto instance) might find setting up an SL subscription easier than giving us API access, since they seem very touchy and the whole SL-to-static might be a no-go.

3 replies

A
Anonymous
March 4, 2016

A couple of years back when 'smart list subscription' was not yet there, I used a combination of smart campaign and a web hook to pull the leads out in external table. Since web hooks are not allowed in a batch campaign, I had to do some smart campaign to make that happen.

I second Sanford's suggestions now those mechanisms (smart list subscription and API calls) are available. If adding smart lists contents to a static lead is acceptable for your business case, that might work better.

Email to database app is a good idea too but a bit more moving pieces and can be difficult to manage / debug.

Rajesh

    G
    GayathriPandian
    New Participant
    January 8, 2021

    See that this thread is from 2016 and we are faced with the same challenge. Has there been any functional changes that will help us pull the Smart Lists via API as of date? Or exporting the Segments via API

     

    Please let know if there are other work arounds too. 

     

    Thank you!

    SanfordWhiteman
    SanfordWhiteman
    New Participant
    January 8, 2021

    Yes! https://developers.marketo.com/rest-api/bulk-extract/bulk-lead-extract/ and the smartListId or smartListName options.

    SanfordWhiteman
    SanfordWhitemanAccepted solution
    New Participant
    March 4, 2016

    Stephen, like Kenny said, Smart Lists are not accessible via API (when you think about the complexity and computation time that could potentially go into a SL, and the expectation that an API call will get the freshest data, it's understandable that this hasn't/yet been enabled).

    A common workaround is adding to a static list via a batch campaign and then using the Get Leads by List ID method.

    But if you are desperate to get Smart Lists as-is, you could think about using SL subscriptions and then processing the report with an email-to-database app.  Something to think about.  For a current client, I'm wondering if their client (the owners of the Mkto instance) might find setting up an SL subscription easier than giving us API access, since they seem very touchy and the whole SL-to-static might be a no-go.

    Kenny_Elkington
    Kenny_Elkington
    New Participant
    March 4, 2016

    Smart lists currently can't be extracted via the API.  You can use either Get Leads by Filter Type or Get Leads by List ID to extract them from a static list.

    Terms & ConditionsAccessibility statement

    Loading footer...