Setting Up a Culture Amp Data Source

Create the Data Source

1. Navigate to the Data Sources page.
2. Click on the Universal Connector Data Source.

Configure the Base URI and Header Token

Find the Base URI and information on obtaining the Header Token by reviewing the official Culture Amp documentation:https://support.cultureamp.com/en/articles/9232738-reporting-api#h_cd9c25581a 
 

Add an end point by clicking on the plus + icon 

Create 2 API end points to retrieve surveys from Culture Amp.

The first one is an API end point for retrieving a list of surveys with the following configuration. 

The second API end point is for retrieving individual survey data with the following configuration:

The relative URI that you need to set will be in the form of /survey/####/responses?limit=1000

You need to find the ### component by looking at the response_url in the surveys table. To do that, open SQL explorer, and find the responses_url by running this SQL query shown in this screen. In this example the survey id is 65949755b62477002bf50d36
 

Run a destructive once you are ready to start to extract survey data from culture amp.