Export Smart List Via API

Question

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?

SanfordWhiteman · Accepted Answer

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.

Anonymous · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO