Connectors / Service / Qualtrics

Qualtrics makes sophisticated research simple and empowers users to capture customer, product, brand & employee experience insights in one place. (updated: 1657717350334)

Qualtrics

The experience management system that turns customers into fans.

Overview

Qualtrics is a simple to use web-based survey tool. It conducts survey research, evaluations and other data collection activities. Anyone can use this suite to build surveys, send surveys or even analyse responses.

Authentication

When using the Qualtrics connector, the first thing you will need to do is go to your Tray.io account page. Select the workflow you wish to work on. Once within the workflow builder itself, search and drag the Qualtrics connector from the connectors panel, into your workflow. The connectors panel is on the left hand side.

With the new Qualtrics connector step highlighted, in the properties panel on the right, select the ‘Authenticate’ panel. Click the button named ‘Add new Authentication’ (located under the Authentication input field).

qualtrics-auth

This will result in a Tray.io authentication pop-up window. The first page will ask you to name your authentication, and state which type of authentication you wish to create ('Personal' or 'Organisational').

As you can see, the next page asks you for your 'API Token' and 'Datacenter ID' credentials.

qualtrics-auth-popups

In order to get these fields, head to your Qualtrics dashboard. You can find or create your 'API token' and 'Datacenter ID' by logging into Qualtrics (using your Brand ID's login page). Visit your account settings page. Navigate as shown below:

qualtrics-auth-step-1

Once you are in the main account dashboard, select 'Qualtrics IDs' from the above menu options. Here you will be led a page hosting all your current ID's including your API token and Datacenter ID:

qualtrics-auth-step-2

Once you have added these fields to your Tray.io authentication popup window, click on the 'Create authentication' button. Go back to your settings authentication field (within the workflow builder properties panel), and select the recently added authentication from the dropdown options now available.

Your connector authentication setup should now be complete.

Available Operations

The examples below show one or two of the available connector operations in use.

Please see the Full Operations Reference at the end of this page for details on all available operations for this connector.

Note on Operations Usage

Create Response Export

Note that this operation lasts a few seconds (or more), in order to take effect. This is why as a user you MUST use a 'delay' method before expecting the next workflow step to begin. Else the workflow will fail should the next step be dependant on the prior one for completion.

More details on how to mitigate this is shown in the workflow below.

Using the Raw HTTP Request ('Universal Operation')

As of version 3.0, you can effectively create your own operations.

This is a very powerful feature which you can put to use when there is an endpoint in Qualtrics which is not used by any of our operations.

To use this you will first of all need to research the endpoint in the Qualtrics API documentation v3.0, to find the exact format that Qualtrics will be expecting the endpoint to be passed in.

Note that you will only need to add the suffix to the endpoint, as the base URL will be automatically set (the base URL is picked up from the value you entered when you created your authentication).

The base URL for Qualtrics is: https://{DATACENTER_ID}.qualtrics.com/API/v3

For example, say that the 'List surveys' operation did not exist in our Qualtrics connector, and you wanted to use this endpoint, you would use the Qualtrics API docs to find the relevant endpoint - which in this case is a GET request called: /surveys.

More details can be found here.

qualtrics-get-url

As you can see there is also the option to include a query parameter, should you wish to do so. So if you know what your method, endpoint and details of your query parameters are, you can get the surveys information with the following settings:

Method: GET

Endpoint: /surveys

Query Parameter: Key: offset Value: 1

Final Example outcome being: https://ca1.qualtrics.com/API/v3/surveys

qualtrics-raw-http

Example Usage

TRAY POTENTIAL: Tray.io is extremely flexible. By design there is no fixed way of working with it - you can pull whatever data you need from other services and work with it using our core and helper connectors. This demo which follows shows only one possible way of working with Tray.io and the Qualtrics connector. Once you've finished working through this example please see our Introduction to working with data and jsonpaths page and Data Guide for more details.

Below is an example of a way in which you could potentially use the Qualtrics connector. This example highlights how to get your survey details and download said information.

The steps will be as follows:

  1. Setup using a manual trigger and get the survey of your choice. Create an export request for a particular survey.

  2. Use a delay method to check the status of the export before continuing.

  3. Export and zip download said file.

The final outcome should look like this:

qualtrics-complete-workflow

1 - Setup Trigger & Get Survey

Once you have clicked 'Create new workflow' from your main Tray.io dashboard and named it, select the Manual trigger from the trigger options available:

qualtrics-manual-trigger

After you have been redirected to the Tray.io workflow dashboard - from the connectors panel on the left - add a Qualtrics connector to your second step. Set the operation to 'Get Survey'. select the survey you wish to work with from the dropdown options provided in the 'Survey ID' field.

qualtrics-step-1-create

USER TIP: Feel free to re-name your steps as you go along, to make things clearer foryourself and other potential users of this workflow. Usually the operation name itself is enoughhowever please note that there is also a 'Description' field available under the Describe tab.

Add a secondary Qualtrics connector and set the operation to 'Create Response Export'. Select the same survey to work with. 'Format' should be set to 'CSV'.

There are various other settings to build with, but for the sake of simplicity, this demo includes only adds 'Included Question IDs':

qualtrics-step-1-create-ids

These two steps will now get your survey information and creates an export request for your specific Qualtrics survey.

2 - Export Complete?

Next, search for the Loop collection connector within your connector panel, and drag it into your workflow as your next step. Set your operations to 'Loop Forever'.

Add another Qualtrics connector inside of the Loop Collection step itself. Set the operation to 'Get Response Export Progress'.

The Loop Collection connector allows you to iterate through your results from previous steps. In this example, we will use it to iterate through the data found within the previous 'Create Response Export' connector step.

To specify the data you want to loop through, start by using the 'List' mapping icon. This is next to the list input field, within the properties panel) to generate the connector-snake.

While hovering over the 'Create Response Export' step (with the tail end of the connector-snake) select id (ID) from the list of output properties displayed. This will auto-populate a jsonpath within your 'Request ID' input field, and update the type selector to jsonpath.

For more clarification on the pathways you have available, open the Debug panel to view your step's Input and Output.

JSONPATHS: For more information on what jsonpaths are and how to use jsonpaths with Tray.io, please see our Intro page and Data Guide for more details.

CONNECTOR-SNAKE: The simplest and easiest way to generate your jsonpaths is to use our feature called the Connector-snake. Please see the main page for more details.

qualtrics-step-2-loop

As the point of this operation is to check the completion of the export process, the next stage is to add a Boolean Condition connector step. Make sure that this is placed inside the loop step again, under the 'Get Response Export Progress' step.

Having this connector in place will mean that the workflow will only continue to take action; should the status report from the previous Qualtrics step come back completed. Set the operation to 'Boolean condition'.

Use the connector-snake like last time to generate the 'Condition' -> 'Conditions' -> '1st Value' field: $.steps.qualtrics-3.status. Set the comparision type to 'Equal to'. The '2st Value' field needs to have its operation type set to 'string' and the text itself as complete.

On the true branch, add a Break Loop connector step. Now the condition to break out of the forever loop should the export process be finished is set.

qualtrics-step-2-boolean

3 - Export File

Add another Qualtrics connector outside of the 'Loop Forever' connector step. Set the operation to 'Get Response Export File'. Your 'File' field name should be set to $.steps.qualtrics-3.file.

Finally, add a Zip Helpers connector step below. Set the operation to 'Unzip' and the 'URL' path to $.steps.qualtrics-4.file.url as the URL was generated from the previous step.

qualtrics-step-3-zip

For further clarification on where the URLs are coming from, open the Debug panel to check:

qualtrics-step-3-debug

Now your workflow is complete, with a downloaded CSV file which you can use to import into other services should you so wish.

qualtrics-step-3-csv

BEST PRACTICES: Whenever you do decide to create your own workflow, please make sure you take a look at our managing data best practices guide.

All Operations

Latest version:

3.2

Create contact

Create a contact.

Create contact import

Import contacts into a mailing list.

Create directory contact

Create a single contact in a specified directory.

Create distribution

Create a distribution.

Create mailing list

Create a new mailing list.

Create mailing list for target audience directory

Create a single mailing list in a specified Target Audience directory.

Create reminder distribution

Create a new reminder distribution.

Create response export

Create an export request for a specific Qualtrics survey.

Create user

Create a new user account.

Delete directory contact

Delete a single contact from a directory.

Delete user

Delete a user.

Get authenticated user

Retrieve the user ID and other user information associated with an Qualtrics API token or a Qualtrics OAuth access token.

Get organization

Retrieve the general information about an organization.

Get response export file

Retrieve a response export file in a format that can be used in other workflow steps.

Get response export progress

Retrieve the progress of a specific survey response export request.

Get survey

Retrieve a specific Qualtrics survey by its ID.

List activity logs

Retrieve the activity logs.

List activity types

Retrieve a list of all activity type logging events.

List activity types DDL

List directories

Retrieve a list of directories with summary information for each directory.

List directories DDL

List directory contacts

Retrieve the contacts in a directory.

List directory contacts DDL

List distributions

Retrieve all distributions.

List groups

Retrieve a list of all groups known to the user account.

List groups DDL

List library messages

Retrieve information on all messages in a library.

List library messages DDL

List mailing lists

Retrieve all mailing lists.

List mailing lists DDL

List mailing lists in directory

Retrieve the mailing lists in a Target Audience directory, default pagination size is 100.

List opted out directory contacts

Retrieve the contacts in a directory who have opted out.

List surveys

Retrieve a list of the Qualtrics surveys.

List surveys DDL

List users

Retrieve a list of all users in the collection.

List users DDL

List users in group

Retrieve a list of users in a specific group.

Raw HTTP request (advanced)

Perform a raw HTTP request with some pre-configuration and processing by the connector, such as authentication.

Search directory contacts

Retrieve contacts that satisfy conditions you have specified.