Connecting to Simplesat

Using API Key Authentication

Simplesat uses API Key authentication. To obtain your API key, log in to your Simplesat account and navigate to Workspace Settings > API. Copy the API key value for use in the connection string.

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

AuthScheme: Set this to APIKey.
APIKey: Set this to your Simplesat API key obtained from workspace settings.

Available Tables

The Simplesat API Profile provides access to the following tables:

Surveys: Retrieve surveys with metric type and brand information
Questions: Retrieve survey questions with metric and choice details
Responses: Retrieve survey responses with customer and ticket information
Answers: Retrieve answers to survey questions with sentiment and comment details
Customers: Retrieve customer records with contact and subscription information
TeamMembers: Retrieve team member details by ID

Usage Examples

Surveys:

SELECT * FROM Surveys

Questions (filtered by survey):

SELECT * FROM Questions WHERE SurveyId = 123

Responses:

SELECT * FROM Responses

Answers:

SELECT * FROM Answers

Customers:

SELECT * FROM Customers

Required Input Parameters

Some tables require input parameters in the WHERE clause:

TeamMembers: Requires Id parameter

API Documentation

For more information about the Simplesat API, visit: https://docs.simplesat.io

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.

Property	Description
APIKey	The API key used for authentication with the Simplesat API.
AuthScheme	The scheme used for authentication. Accepted entries are APIKey or None. Allowed values are: BASIC, NONE, NTLM, OAUTH, APIKEY, OAUTH_CLIENT