Solved
getLegacyResponseData API - Using URL Parameters to Filter by Embedded Data Field
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.
Best answer by LaurenK
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
