"Hello,
I would like to ask a question. I have managed to retrieve data from the API using Google Apps Script with a form and token, but the output I receive is in raw code format. I have also attempted to use the API Connector, but the result remains in raw code or the values are not in labels or plain text. Is there a way to retrieve raw text using Google Apps Script while also utilizing the form and token API?"
This is my syntax
function testBasicAuthentication() {
var url = “https://kf.kobotoolbox.org/assets/[API_Fom]/submissions/?format=json”;
var header = {
“Authorization” : “Token [API]”
}
var params = {
“method” : “GET”,
“headers” : header
}
var response = UrlFetchApp.fetch(url, params);
var object = JSON.parse(response.getContentText());
var headers = Object.keys(object[0]);
var values = object.map(function(e) {return headers.map(function(f) {return e[f]})});
values.unshift(headers);
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(“Raw Code”);
sheet.clear();
sheet.getRange(1, 1, values.length, values[0].length).setValues(values);
}
