New to API, need help pulling ONLY specific variables from a survey | XM Community
Skip to main content
Question

New to API, need help pulling ONLY specific variables from a survey

  • June 28, 2019
  • 6 replies
  • 29 views

Forum|alt.badge.img+5
As far as I can tell, the API pull seems to be an all or nothing approach. Does someone have instructions for how to pull only certain variables using the API and not pull any extra information? Thanks in advance!

6 replies

Alok_Painuly
Level 2 ●●
Forum|alt.badge.img+4
  • Level 2 ●●
  • July 1, 2019
Hi @uhrxx005, this can help you: ! https://api.qualtrics.com/reference#create-response-export-new

  • July 14, 2019
I have a requirement to pass end date as a parameter while pulling the responses. And the end date needs to change dynamically, without manual input, based on when we are refreshing the data. Is that possible?

Alok_Painuly
Level 2 ●●
Forum|alt.badge.img+4
  • Level 2 ●●
  • July 15, 2019
@Kajal - yes it is possible. You can use excel macro where you can pass the end date parameter dynamically based on your requirement. Use the response export API in the macro.

  • July 15, 2019
@Alok: Thanks for the response. My use - case involves around bringing this data onto our Data Lake. So cannot use an excel macro here. Is there any other way?

Alok_Painuly
Level 2 ●●
Forum|alt.badge.img+4
  • Level 2 ●●
  • July 15, 2019
@Kajal - please let me know the source from where you want to trigger the API.

  • July 15, 2019
@Alok: I am not sure what you are referring to? Are you asking what data I need to pull through API?