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
View original