Ability to grab data from SurveyMonkey

[mike_snow1]

It would be really great to be able to have native support to pull data from SurveyMonkey surveys. There is an API for it after all.

[DavesBI]

My work-around for the interim is to use EXCEL (2016) to get my survey results. (Insert > Store "Scroll down or search for the add-In" follow instructions). Then run a macro to convert to a table and refresh. This file then feeds to Power BI where a cross analysis with other data sets. A direct feed into "Powbi" would be a more efficient solution.

[gregrpenner]

what's the hold up on this? Seems like a popular connection. I also need it.

[bthomas5]

Definitely still needed

[amanda_caunt]

Its a great idea, and I would use it a lot.

[lsoohoo2]

This feature is really needed. We do a lot of surveys and transforming them manually to analyze is not a good nor efficient option.

[nancy1989]

get data from SurveyMonkey in SSIS using their REST API. Interacting with REST API requires programming skill and if you are not Programmer you may face dead end. SSIS PowerPack JSON REST API Connector (for XML REST API check XML Source Connector) makes it super easy to consume any REST API data source. https://zappysys.com/blog/get-data-from-surveymonkey-in-ssis-using-rest-api/

[michael_shull]

A MUST

[greg54]

Why are we still asking for a simply feature? MS time to deliver.

[pbiideas1]

I see why MS didn't get to this yet the data is a mess from the api, requires multiple calls, just to get one survey, with a limit per day, also has horribly nested elements. One question could have a single text element as the result or a table in the same element. We created our own internal web service that grabs the data through here to send to our PowerBi gateway. Using: https://github.com/bcemmett/SurveyMonkeyApi-v3

[acharlier]

this would be a massive benefit!