Complete the following steps to set up a connection to SurveyMonkey® using a RestAPI connection. For more information on the RestAPI connector, go to Rest API. You can also view the SurveyMonkey API documentation here.
- From the Home screen, select the Add button under Tables.
- In Datasets, enter RestAPI and select the connector from the results. Then in Name, enter a name for the connection.
- From Authentication, select OAuth
2.0. Then use the following table to set up the remaining
options.
Option Value Desired Authentication Parameter Type Header Parameter Grant Type Authorization Code Callback URL https://connect.minitab.com/api/restApi/auth.php Auth URL https://api.surveymonkey.com/oauth/authorize Access Token URL https://api.surveymonkey.com/oauth/token Refresh Token URL Leave this empty Client ID Enter your ID Client Secret Enter your secret Scope Enter a list of comma separated items from this table of SurveyMonkey scopes. - Select Click to authorize, then select Save
. After you save
the connection, Connect displays options to import data into a new table. - On the left panel, enter a Name that identifies the table and select a Folder to save the table.
- From Request Type, select a HTTP GET request.
- Under URL, enter the base request URL. For example, you could use one of the following
URLs.
- List all surveys - https://api.surveymonkey.net/v3/surveys
- Questions for SURVEY_ID - https://api.surveymonkey.net/v3/surveys/{survey_id}/details
- Responses for SURVEY_ID - https://api.surveymonkey.net/v3/surveys/{survey_id}/responses
- In Maximum Array Depth, enter 2. Then select Next.
- In Array Key for Records (Root Path), enter Data.
- Select Save
. If you go to the Prep Tool and select Run
, Minitab Connect displays
the imported data. Note
If no data appears after you select Run, select Reset Config
.
