topic Connecting QlikView with Qualtrics Surveys in Connectivity & Data Prep

Connecting QlikView with Qualtrics Surveys

sique132 — Fri, 02 Apr 2021 08:05:59 GMT

Has anyone successfully connected QlikView to Qualtrics using a REST connector? If so, can you provide some details on getting the connection to work? I haven't been able to find anything online for this. My test works but then it doesn't return data. I believe I need to use a Qualtrics API token somewhere but not sure where.

If you've connected another way though I'd appreciate that information as well.

Re: Connecting QlikView with Qualtrics Surveys

Clever_Anjos — Wed, 30 Aug 2017 14:25:09 GMT

Reading the documentation (I dont have access to the platform)

Generate the token Insight Platform - API | Qualtrics
Use the REST URL (Insight Platform - API | Qualtrics) passing parameters (you can use the Headers parametes from your REST connector to pass that the token X-API-TOKEN: yourapitokenhere )

Re: Connecting QlikView with Qualtrics Surveys

sique132 — Wed, 30 Aug 2017 14:33:05 GMT

Yep, i've gotten that far but when i do the get call for the file it returns a CSV format that has a bunch of symbols so if that is supposed to be the zip file i'm not sure how to unzip it in the scripting. I've attached the file with the API hidden if you want to take a look.

Re: Connecting QlikView with Qualtrics Surveys

Clever_Anjos — Wed, 30 Aug 2017 15:00:36 GMT

I´m at a network that I don´t have access to that URL, later I´ll check this

Re: Connecting QlikView with Qualtrics Surveys

Clever_Anjos — Wed, 30 Aug 2017 16:58:22 GMT

could you send me your token in private message?

Re: Connecting QlikView with Qualtrics Surveys

sique132 — Wed, 30 Aug 2017 17:36:46 GMT

Can't secure info

Re: Connecting QlikView with Qualtrics Surveys

sique132 — Wed, 30 Aug 2017 17:38:02 GMT

I've got it working another way now, but i would liked to figure this other way out.

Re: Connecting QlikView with Qualtrics Surveys

Wed, 06 Sep 2017 15:35:32 GMT

Hi Sean,

I have this same requirement. I have successfully used Qualrics older APIs (V2) but am struggling with their new V3 APIs.

The old V2 API would import data direct into a Qlik application, but there seems to be a bug related to one of our surveys that means some changes in the survey haven't been picked up. We can rectify these on a manual export from Qualtrics by delecting "Use legacy results view format" but cannot figure out how to mirror this in the API.

The newer V3 API appears to fix this problem, however, I have yet to successfully set up the new API (I keep getting and HTTP Protocol error 400 (Bad Request) and even if I do succeed it looks like the only output will be to a zipped file! Really dissapointing reduction in functionality! 😞

If you have managed a work around can you please share how you managed this?

Many thanks!

Emma

Re: Connecting QlikView with Qualtrics Surveys

sique132 — Mon, 12 Feb 2018 16:53:24 GMT

Hi Emma, sorry for the delay, my work around was to use their legacy V2 with an API Token that we had to purchase from them and the qlikview rest connector. It is working great right now

Re: Connecting QlikView with Qualtrics Surveys

twanqlik — Tue, 20 Feb 2018 10:29:01 GMT

May I ask if you could share the script that you are using?

Of course, without any sensitive data.

*Ps. in order to use the API client from Qualtrics, first an API token has to be purchased from Qualtrics?

Re: Connecting QlikView with Qualtrics Surveys

sique132 — Tue, 20 Feb 2018 13:44:07 GMT

That's how we're currently doing it using their legacy pull method. I'm finding we're not getting all the available fields though when we do it this way. The current script is just from the rest connector build with our api token in there, the previous one i tried to use with the new pulling methods is further back in this chain.