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

Question

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.

LaurenK · Accepted Answer

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!

UHutch · Answer

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

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded