Tableau Rest API and Marketo

[Sarah_Greig2]

Hi

We  have just linked up Marketo and Tableau via the REST API.

How are the calls made is it per record every time a query is refreshed?

Sarah

[Anonymous]

The connector will run in batch - it will be VERY Easy for you to go over the limit - especially if you want to bring back activities - which I am not sure it can do?

[Drew_Loika]

For anyone interested in Tableau and Marketo, I'd like to share that our new version of the connector is available for feedback. We'd love to hear if it works for you and how we can improve it. The new version supports all data it is possible to retrieve from Marketo that customers have told us they'd like to visualize in Tableau.

As Neil Robertson-Ravo​ notes it is very easy to exceed your API limit unless you have increased it, so please be aware of this if you decide to try the new connector. Marketo has been improving this situation by releasing a bulk API that reduces the number of API calls but we've not yet had the change to adopt it.

Best,

Drew Loika
Senior Product Manager
Tableau

[Anonymous]

If I understand your question.  The calls are typically made in batch.  and each call can access up to 300 Marketo records per send.

Does that make sense to you, or are you asking something else?

[Sarah_Greig2]

I am asking this because I think that the Rest API calls are metered by Marketo and trying to figure if this method of connection will easily take us over the metered amount or wether we should use an ODBC connection. Our database is around 100k.

[Dory_Viscoglio]

Hey Sarah, did you ever get any answers from Tableau? It would be great to know how the API calls are utilized since we're already over our limit.

[Sarah_Greig2]

Our Tableau developer decided to opt for calling the data once a day. So tableau can pull in individual tables in 1 API call and then join them together in Tableau for interrogation.  A live API connection to Marketo where each interaction in tableau would be 1 API call. Or so I'm told

[Anonymous]

Hey, Sarah. Any chance you'd share more about what you've managed to do with Marketo-Tableau?

[Dory_Viscoglio]

Hmm, thanks for our feedback. I connected Tableau yesterday, and granted we tried to do quite a few things, but we ended up with 102 API calls after a 1 hour meeting. We have a 660k record db which might change things a little bit, but I can see how it might creep upwards quickly.

[Sarah_Greig2]

But aren’t there 2 connection methods? One live and one which will pull down a copy of the file and then you can refresh it when you want? The live connection will rack up the API calls but pulling down the static file should be one call?

[Dory_Viscoglio]

I'll have to connect with our Tableau guy and find out. I guess we were pulling live.

[Anonymous]

From http://developers.marketo.com/rest-api/

• Daily Quota: Most subscriptions are allocated 10,000 API calls per day (which resets daily at 12:00AM CST).  You can increase your daily quota through your account manager.
• Rate Limit: API access per instance limited to 100 calls per 20 seconds.
• Concurrency Limit:  Maximum of 10 concurrent API calls.

[Kenny_Elkington]

This question is probably better posed to tableau, since they control the connector and know how it uses API calls.