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.