Hi,
We are trying to get data of ERPNext using rest API into the Google Sheet. We are getting the request but when we try to get data by using the method getContentText(), getting an error like below TypeError: Cannot read property ‘getContentText’ of undefined
function myFunction() {
var request = {
‘url’ : ‘https://pranera.erpnext.com/api/resource/Item/?limit_start=None&limit_page_length=None&parent=Item&'+encodeURIComponent('filters=[["Item", "commercial_name", "like", "Mars 200"]]’),
‘method’ : ‘get’,
‘escaping’ : false,
‘muteHttpExceptions’: true,
‘contentType’: ‘application/json’,
‘headers’:
{
'Authorization': "token "+ "xxxxxxxxxxxxxxx" + ":" + "xxxxxxxxxxxxxxx",
'Accept': 'application/json'
}
};
var response = UrlFetchApp.fetchAll([request]);
Logger.log(jsonresponse.getContentText());
var jsontype = typeof(response);
var json1 = JSON.parse(response);
var jsontype1 = typeof(json1);
var jsonresponse = response;
for (var c = 0; c < response[0].length; c++) {
Logger.log(response[c]);
}
Logger.log(jsontype);
Logger.log(jsontype1);
Logger.log(json1);
var sheet = SpreadsheetApp.getActiveSheet();
sheet.getRange(1,1).setValue([jsonresponse]);
}