Exporting survey responses using Google Apps Scripts | XM Community
Solved

Exporting survey responses using Google Apps Scripts

  • 24 April 2019
  • 8 replies
  • 44 views
J
I am trying to export survey responses using Google Apps Scripts using the POST API. I know I am pinging an address, but it comes back with

httpStatus":"400 - Bad Request".

My code works theoretically, but I believe its calling incorrectly and I am not sure why.

var option = {
async: true,
crossDomain: true,
url:"https://ousurvey.ca1.qualtrics.com/API/v3/surveys/SV_8dK8AKUFyAH8qyN/export-responses/",
method: "POST",
"headers": {
"X-API-TOKEN": "",
"Content-Type": "application/json",
"cache-control": "no-cache",
"Postman-Token": ""
},
processData: false,
data : '{"format":"csv"}',
muteHttpExceptions: true
};
var qUrl='https://ousurvey.ca1.qualtrics.com/API/v3/surveys/SV_8dK8AKUFyAH8qyN/export-responses/'
var getSurvey = UrlFetchApp.fetch(qUrl, option);

Currently I am just trying to pull the responses from a test survey I made, but have had no luck. I can get the two GET APIs to work by obtaining the IDs using POSTMAN, but the POST is being stubborn. I feel like I am missing something very obvious but I can't make any connections.
icon

Best answer by jeNguyen 25 April 2019, 17:51

View original

8 replies

w.patrick.gale
Rank
Userlevel 5
Badge +13
@jeNguyen Never post your Tokens to a forum. I suggest editing your original post and remove them pronto.
w.patrick.gale
Rank
Userlevel 5
Badge +13
@jeNguyen Secondly, your code is referencing two different survey IDs (you only want work with one).
J
@w.patrick.gale, I did not think about the API token, thank you but I'm not sure how to edit a post on here. Also I fixed the url in my code and it doesn't solve the problem unfortunately and at the moment I can't update my post to show the changes.
w.patrick.gale
Rank
Userlevel 5
Badge +13
@jeNguyen There is a little icon that appears on the top right of the post. Click that to edit.
J
My current monitor made that icon near invisible, I had to squint extra hard, thank you. I also updated my code.

This is the current error I am receiving in the Google Log.
{"meta":{"httpStatus":"400 - Bad Request","error":{"errorMessage":"Error decoding json body: com.fasterxml.jackson.databind.JsonMappingException: No content to map due to end-of-input\\n at [Source: akka.util.ByteIterator$ByteArrayIterator$$anon$1@3c9d2a4e; line: 1, column: 0]"}}}
TomG
Rank
Userlevel 7
Badge +27
@jeNguyen,

Usually a 400 means the data you sent to the API was in the wrong format. Try removing the line feed and tab characters from the json string. Also, I think if you use single quotes, then you don't need to escape the double quotes.
```
data : '{"format":"csv"}',
```
J
@TomG,
I thought that was the problem as well and was fiddling with it, but I still get the same error.
J
I was able to figure out what was wrong with it with some help. It was mainly due to my format of the call itself:

var qUrl = "https://ousurvey.ca1.qualtrics.com/API/v3/surveys/SV_dd7ZjV7L1RX5WKh/export-responses/";
var option = {
method: "post",
headers: {"X-API-TOKEN": "JCu7bnl5ldjN9ipobqGUZj7kLO69Hklfxbr6YT9R"},
contentType: "application/json",
payload: JSON.stringify({"format": "csv"}),
muteHttpExceptions: true,
};

Leave a Reply


Terms & Conditions