Hi I am trying to use this code to import a JSON file from API I keep getting this error "TypeError: Cannot read property 'length' of undefined"
PIVOT_URL_Country = ""
SHEET_NAME_Country = "test"
function updateDataCountry() {
const response = JSON.parse(UrlFetchApp.fetch(PIVOT_URL_Country))
const headers = [response.headers]
const data = response.report
const output = headers.concat(data)
const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(SHEET_NAME_Country)
sheet.getDataRange().clearContent()
sheet.getRange(1, 1, output.length, output[0].length).setValues(output)
}