Exporting survey responses using Google Apps Scripts | XM Community
Skip to main content
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.
@jeNguyen Never post your Tokens to a forum. I suggest editing your original post and remove them pronto.
@jeNguyen Secondly, your code is referencing two different survey IDs (you only want work with one).
@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.
@jeNguyen There is a little icon that appears on the top right of the post. Click that to edit.
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]"}}}
@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"}',

```
@TomG,

I thought that was the problem as well and was fiddling with it, but I still get the same error.
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