UseLabels = True but Choice Text is Not Showing | XM Community
Skip to main content
Question

UseLabels = True but Choice Text is Not Showing

  • October 31, 2019
  • 8 replies
  • 125 views
S
I am using the API to export survey results, and I want the choice text. This works for some of the questions, and I see the choice text (and compared to an export where the value is not set/False, it is definitely doing something). However, for many other questions, the numeric value is still showing. I have looked at the question types in case it has something to do with that, and the types range through the expected - Text, Matrix, MCSA, MCMA, etc... Is there a reason why the choice text would not be exported?

8 replies

KeirJ
QPN Level 2 ●●
Forum|alt.badge.img+7
  • KeirJ
  • QPN Level 2 ●●
  • November 5, 2019
Hi @seanna1360! So I can try to replicate the issue, can you provide the code showing the API call you're making? It might look something like what's seen in the screenshot below. !
S
  • seanna1360
  • Author
  • November 5, 2019
Sure thing - here are the salient snips - cut out some of my debugging etc. Leveraged shamelessly from code provided elsewhere on this site. Files download successfully and useLabels is set to True (with some wrangling because Python). ! ! !
KeirJ
QPN Level 2 ●●
Forum|alt.badge.img+7
  • KeirJ
  • QPN Level 2 ●●
  • November 7, 2019
Hi @seanna1360 - I've extracted a dataset using the API and 'useLabels' = True and am seeing all responses using the answer text. Can you provide screenshots of one question where you're seeing the problem? Screenshots should include the question as seen in the survey editor screen and then also the output that you're seeing in the file extracted from the API.
S
  • seanna1360
  • Author
  • November 7, 2019
See below. This is one of many questions where values instead of choice text were returned. ! ! !
S
  • seanna1360
  • Author
  • November 20, 2019
@KeirJ - Any thoughts?
KeirJ
QPN Level 2 ●●
Forum|alt.badge.img+7
  • KeirJ
  • QPN Level 2 ●●
  • November 20, 2019
@seanna1360 - Sorry, I'm not sure, to be honest. Have you applied any transformations to the data in the excel file for the screenshot you provided? The format looks different than what I am seeing when I open the download from the test survey I am exporting w/ the API. Also, I'm guessing we're using the same API call but can you confirm what URL is in the variable `downloadRequestUrl`?
S
  • seanna1360
  • Author
  • November 20, 2019
@KeirJ - I'll open a support ticket - but in the meantime - yes, I do pivot the the data to make it ready for analysis in Tableau; other than that, no transformations. downloadRequestUrl is https://{0}.qualtrics.com/API/v3/responseexports/
KeirJ
QPN Level 2 ●●
Forum|alt.badge.img+7
  • KeirJ
  • QPN Level 2 ●●
  • November 20, 2019
Hi @seanna1360, I'm using a different URL `baseUrl = 'https://{0}.qualtrics.com/API/v3/surveys/{1}/export-responses'.format(dataCenter, surveyId)` for my export. See https://api.qualtrics.com/reference#create-response-export-new in the API documentation. Does that help?
Terms & ConditionsAccessibility statement