Skip to main content
Loading...
  • Customer Experience
    Customer Experience
  • Employee Experience
    Employee Experience
  • Brand Experience
    Brand Experience
  • Product Experience
    Product Experience
  • Core XM
    Core XM
  • Design XM
    Design XM

File Import Sources for Contact Automations

What's on This Page:


Was this helpful?


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The feedback you submit here is used only to help improve this page.

That’s great! Thank you for your feedback!

Thank you for your feedback!


About File Import Sources for Contact Automations

With Contact Import Automations, you can streamline your contact management. When the automation is scheduled to run, it’ll process any designated files that have not been processed by the automation yet, including newly uploaded files. However, before you can do that, the automation needs to know where to pull your files from.

The file source for contact import automations can be:

  1. Qualtrics File Service
  2. Your SFTP Server
  3. OAuth File Storage (Google Drive or Dropbox)
Qtip: Before you worry about a file import source, make sure you’ve completed Step 1 of the automation.

Qualtrics File Service

First option Qualtrics file service is selected in the configure import source step

The Qualtrics File Service is a secure and isolated file store API that allows you to upload files for this automation to import. You may upload a file to an HTTPS endpoint, which will be provided in a grey box (shown below), as multipart form-data.

When the automation is scheduled to run, it’ll process any files that have not been processed by the automation yet, including newly uploaded ones.

To use the Qualtrics File Service, you’ll need to call the HTTPS endpoint provided. If the file is generated from the system, you’ll want to provide the API documentation and the following example implementation to your IT or Software Engineering team to integrate with our service.

Example: This example is in cURL format. See the API Overview support page on how to generate an API token.
For Mac and Unix users:

curl -X POST -H "X-API-TOKEN: [YOUR API TOKEN]" \
-F 'file=@/path/to/import/file/sample-file.txt' \
https://datacenterid.qualtrics.com/automations-file-service/automations/AU_XXXXXXXXX/files

For Windows users:

curl -X POST -H "X-API-TOKEN: [YOUR API TOKEN]" ^
-F "file=@/path/to/import/file/sample-file.txt" ^
https://datacenterid.qualtrics.com/automations-file-service/automations/AU_XXXXXXXXX/files

Example: This is a Request Example. See the API Overview support page on how to generate an API token.

POST https://datacenterid.qualtrics.com/automations-file-service/automations/AU_XXXXXXXXX/files HTTP/1.1  
Content-Type: multipart/form-data
X-API-TOKEN: [YOUR API TOKEN]
 
-----------------------------
Content-Disposition: form-data; name="upfile"; filename="sample-file.txt"
Content-Type: text/plain
 
[FILE DATA]
-----------------------------

Manually Manage Uploaded Files with API

You can also manually manage uploaded files using the Qualtrics API. The following links explain how to interact with the Qualtrics File Service API:

At times, these API calls will ask for an automationId. Qualtrics will provide you with this information, formatted as AU_XXXXX.

AU ID inside gray box

Next Steps

Now that you’re done setting the Qualtrics file Service as your import source, it’s time to finish creating your contact import automation.

SFTP Server

Users often wish to integrate their contact records with Qualtrics using Secure File Transfer Protocol (SFTP). For example, you may wish to import content from a hosted daily file drop, and then import and schedule survey distributions for those contacts, all under the most safe and secure transfer methods. This section goes over how to connect a contact import automation to your own SFTP server.

When the automation is scheduled to run, it’ll process any files that have not been processed by the automation yet, including newly uploaded ones. When a file is processed, it is removed from the SFTP server.

Qtip: Qualtrics automations need to “touch” (i.e. access) the file multiple times on your server before it is successfully transferred to Qualtrics. Please ensure your SFTP server is configured to allow multiple touches to files. If your server is set up to delete the file after one touch, then the automation will fail.
  1. In the Configure Import Source step, select SFTP Server.
    SFTP is selected in the configure import source step
  2. Click Continue.
  3. Enter the Host URL.
    Continue button made the next few steps of fields appear on the screen

    Qtip: The URL usually resembles sftp.example.com.
  4. Enter the Username. This is case-sensitive.
  5. Enter the Port. This is optional. 22 is entered as the default.
  6. Click Continue.
  7. Enter your Password.
    Password is starred out

    Qtip: If the exact host, username, and port have already been provided, you will not be asked for a password.
  8. Click Continue.
Qtip: If you run into issues establishing an SFTP connection, see SFTP Troubleshooting for additional guidance.

Supported Ciphers

Connecting to an SFTP server requires a series of SSH handshakes to coordinate the encryption used between the server and the automation. In order to establish a connection, the SFTP server will need to have at least one cipher for each cipher type that matches a cipher supported by automations. Below is the list of ciphers supported by automations grouped by the cipher type.

Supported Key Exchange Ciphers:

  • diffie-hellman-group1-sha1
  • diffie-hellman-group14-sha1
  • ecdh-sha2-nistp256
  • ecdh-sha2-nistp384
  • ecdh-sha2-nistp521
  • curve25519-sha256@libssh.org

Supported Mac Ciphers:

  • hmac-sha1
  • hmac-sha2-256
  • hmac-sha2-256-etm@openssh.com
  • hmac-sha1-96

Supported Encryption Ciphers:

  • aes128-ctr
  • aes192-ctr
  • aes256-ctr
  • aes128-gcm@openssh.com
  • chacha20-poly1305@openssh.com

We also support the following Encryption Ciphers, but do not recommend them, as they have known security vulnerabilities:

  • arcfour256
  • arcfour128
  • arcfour
  • aes128-cbc
  • 3des-cbc

If the SFTP server does not support the appropriate ciphers, we recommend using one of the other import sources presented on this page.

Next Steps

Now that you’re done setting up an SFTP server as your import source, it’s time to finish creating your contact import automation.

Google Drive & Dropbox

You can use your Google Drive or Dropbox account as file storage for your contact import automations. Your login information for these services will remain private; OAuth File Storage allows an end user’s account information to be used by Qualtrics, without exposing the user’s password. This account information is used to connect to file storage from Automations in XM Directory, behaving similar to an SFTP setup.

When the automation is scheduled to run, it’ll process any files that have not been processed by the automation yet, including newly uploaded ones. When a file is processed, it is removed from the OAuth file storage.

  1. In the Configure Import Source step, select Google Drive or Dropbox.
    The Configure Import Source Screen, we can see the Google Drive and Dropbox options.
  2. Click Continue.
  3. You’ll need to sign into your Google or Dropbox account by clicking Sign In.  This will redirect you to a new window in which you can sign in via OAuth.
    Here we see the Sign In button for the File Storage.
  4. Once sign-in is successful, you’ll be redirected to finish the configuration or, if desired, Switch Accounts to another OAuth user. You can also remove the OAuth account by clicking Change on the data source and selecting an alternative data source.
    Here we see options for Switching Accounts and Changing Data Sources.
  5. Head over to the Select Import File source section after you’ve configured your Import Source. You’ll be able to declare your Folder Path here (e.g., “FolderName/Folder2”).
    Select Import File editing page, which includes a space to specify the import source as a Folder Path

Next Steps

Now that you’re done setting up an SFTP server as your import source, it’s time to finish creating your contact import automation.