404 error in webhook from Google Sheets

Status: Open · Asked by Javier Salinas on · 0 views

Javier Salinas — Question ·

Im getting this error Exception: Request failed for https://connect.pabbly.com returned code 404 at editRow(Code:35:17) from a Google sheets that works sending a webhook to pabbly, it has been working fine for months but today It stopped working, can anyone help me?

The script send the information when a new row is added in google sheets to a webhook in pabbly

function citatel(e) {
if(e.changeType=="INSERT_ROW"){ //The type of change (EDIT, INSERT_ROW, INSERT_COLUMN, REMOVE_ROW, REMOVE_COLUMN, INSERT_GRID, REMOVE_GRID, FORMAT, or OTHER)
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); //get activated Spreadsheet
var sheet = spreadsheet.getSheetByName("citatel"); //get sheet by sheet name
var headings = sheet.getDataRange().offset(0, 0, 1).getValues()[0]; //get heading
var column_to_watch = 8; //A=1, B=2, C=3 etc...

var row = sheet.getActiveRange().getRow();
var column = sheet.getActiveRange().getColumn();

if (e.changeType=="EDIT" && column != column_to_watch)
return;

var values = sheet.getSheetValues(
row, // starting row
1, // starting column
1, // number of rows
10 // number of columns
);

var payload ={}

for (i = 0; i < headings.length; i++) {
var name = headings[i];
var value = values[0][i];
payload[name] = value;
}
payload["row_number"] = row;

var options = {
'method': 'post',
'contentType': 'application/json',
'payload': JSON.stringify(payload)
};
UrlFetchApp.fetch('https://connect.pabbly.com/workflow/sendwebhookdata/IjU3NjUwNTZhMDYzNTA0MzE1MjY0NTUzZDUmMzUi_pc', options);
}
}

AutoEx — Reply ·

Is this issue in trigger?

Arshil Ahmad — Reply ·

Hi @Javier Salinas,

Could you please share the Workflow URL in which you have this concern?

Back to all forum threads · Log in to reply