Error - Cmmunity Connector

Taner
New Member

My problem is everything seems fine in google appscript and get data.. but  when i published i took this error... even i had similar but different project its fine. this is happening.... 

I shared my last part of code..

 

function sendDataToGoogleDataStudio(request) {
try {
var dataRows = fetchProcessAndFormatData(request);
Logger.log('Fetched data rows: ' + JSON.stringify(dataRows));

if (!dataRows || dataRows.length === 0) {
Logger.log('Error: dataRows is either empty or undefined');
return [];
}

var fieldIds = request && request.fields ? request.fields.map(field => field.name) : ['date', 'stockCode', '1A', '4CBL'];

var formattedRows = dataRows.map(row => {
var resultRow = [];
fieldIds.forEach((id, index) => {
if (id === 'date') {
resultRow.push(row[0]); // Tarih alanı
} else if (id === 'stockCode') {
resultRow.push(row[1]); // Hisse kodu
} else if (id === '1A') {
resultRow.push(row[2]); // Dönen Varlıklar
} else if (id === '4CBL') {
resultRow.push(row[3]); // Dönem Sonu Nakit
} else {
resultRow.push(null); // Bilinmeyen alanlar
}
});
return resultRow;
});

Logger.log('Formatted Rows: ' + JSON.stringify(formattedRows));

var fields = getFields(fieldIds);

var response = cc.newGetDataResponse()
.setFields(fields) // Dinamik fields nesnesini kullanıyoruz
.addAllRows(formattedRows) // Formatlanmış tüm satırları ekliyoruz
.build();

Logger.log('Response built successfully');

return response;
} catch (error) {
Logger.log('Hata oluştu: ' + error.message);
throw error;
}
}
1 1 93
1 REPLY 1

I don't know if it will be possible to debug this, but it would be helpful if you shared the error message that you are getting.