Connecting to Qualaroo

Qualaroo uses HTTP Basic Authentication to control access to the API. You will need your API Key and API Secret, which can be found under Account Details > Reporting API in the Qualaroo dashboard.

Using Basic Authentication

After setting the following connection properties, you are ready to connect:

• AuthScheme: Set this to Basic.
• User: Set this to your Qualaroo API Key.
• Password: Set this to your Qualaroo API Secret.

Example connection string:

Profile=C:\profiles\Qualaroo.apip;AuthScheme=Basic;User=your_api_key;Password=your_api_secret;

Usage Examples

SurveyResponses:

SELECT * FROM SurveyResponses WHERE SurveyId = '12345'

Surveys:

SELECT * FROM Surveys

Connection Properties

The connection string properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection string for this provider.