getLegacyResponseData API - Using URL Parameters to Filter by Embedded Data Field | XM Community
Solved

getLegacyResponseData API - Using URL Parameters to Filter by Embedded Data Field

  • 7 October 2018
  • 3 replies
  • 110 views

Hi all,

I'm currently trying to import ~10k survey responses (from the same survey) into Google Sheets (using =importdata). I have two issues I'm trying to work through (#1 being the priority issue):

1. Define an embedded data field as a parameter in the URL. For example, if I have an embedded data field called 'Group' that has values A-Z, I would like to add '&Group=D' to only pull responses where Group = D. Is this possible?
2. Remove some embedded data fields from the initial API pull. I know I can use Google Scripts to do this securely (I'll end up using scripts to manipulate the data anyway), but was wondering if I could limit which embedded data fields before initially pulling in the survey responses. I'm only using ~20% of the embedded data fields, so it would help with how many rows I could import.

I'm only able to bring in ~1500 responses before the =importdata function in google sheets tells me the dataset is too large. I need to eventually filter by this Group field anyway, so it would solve two problems if I could do this.

I'm using the 360 API version 2.5... I'm open to changing this if needed: https://datacenter.qualtrics.com//WRAPI/ThreeSixty/api.php?API_SELECT=ThreeSixty&Version=2.5&Request=getLegacyResponseData.......

I used this documentation to construct the URL so far: https://survey.qualtrics.com/WRAPI/ThreeSixty/docs.php#getLegacyResponseData_2.5

Any insight would be greatly appreciated! I'm new to using APIs in general, and have very little programming experience to do this anywhere but in the URL parameters.
icon

Best answer by LaurenK 29 October 2018, 16:49

View original

3 replies

Userlevel 7
Badge +13
Hey @Ryan! If you have not yet already, I would recommend reaching out to our Integration's Support team, as they will best be able to handle these questions!
Badge +4

Hi Lauren,
I tried to use the link you provided above to contact the Integration's Support Team but I got (kinda) an error. Is there another way to contact your integrations support team?

Thanks

Badge +48

https://community.qualtrics.com/XMcommunity/discussion/comment/47531#Comment_47531Hi there! Our team is so sorry to hear about your recent experience logging into the community. If you are still having trouble signing into the community, we would recommend contacting the support team as they are best equipped to help 😃
In order to contact the support team, you can file a limited support ticket, which doesn't require authentication/login. You can do so by clicking "Contact Support" in the top right of the support site. Then, select "Can't log in or don't have an account?" in the center of the page!


Leave a Reply