As part of May's Enterprise Connector Spotlight, I wanted to outline some of what you can do with the SurveyMonkey Enterprise Connector. We use SurveyMonkey here at Embarcadero for internal and external surveys. They have an option to get started for free, and a number of paid options. It is one of the more popular survey platforms. Even if you don't currently use it, you've most likely taken a survey on their platform. You can find out more on SurveyMonkey's website.
So what can you do with the SurveyMonkey Enterprise Connector? Glad you asked. The Enterprise Connector gives you SQL-based access to SurveyMonkey data through easy-to-use standards-based drivers. This means you can easily access live SurveyMonkey data from your own custom apps using all the power of FireDAC.
To get started with SurveyMonkey you can download the trial or the full version from CData's website and follow the guide to connect. You will need a client ID and Secret API key from the SurveyMonkey developer portal. Be sure to set your callback URL, and scopes too. Then populate the values in the TFDConnection.
Setup your App on the SurveyMonkey developer portal
Be sure to specify the OAuth Redirect URL
Setup the Scopes you need. By default you need: View Users, View Surveys, View Responses, View Response Details, View Contacts, and View Collectors.
If you take a look at the documentation on CData's website. If you go down to the data model you can see a list of views provided by the Enterprise Connector. There are also some Stored Procedures used for authentication.
If you from there you can find out more about what data is available through each view. Note that SurveyQuestions and SurveyResponses don't exist as views directly. Instead you look in those tables by using the name of the survey. So for example:
SELECT * FROM [My Survey for Fun_Questions]
SELECT * FROM [Surbey about programming_Responses]
To get a list of all the surveys and their individual tables you can do something like:
And that's all there is to accessing SurveyMonkey data in your C++Builder or Delphi application. Make sure you sign up for our free webinar to get the free license key for update subscription customers.