Sudden 504 using Excel connector - Data well within range

(0) Share

Report

Posted on by Bill51106

152

I am confused and hoping for someone to explain. I have been receiving .xlsx files without issue, saving to SP and running an Office Script against. The biggest file is 500K rows, 12 columns. Not even 1.3MB

Starting today everything is failing with "BadGateway" and "Request to Graph API has timed out." Any advice is appreciated.

Running the script outside of PA with the file yields "Range getCell: The request payload size has exceeded the limit. Please refer to the documentation:"

function main(workbook: ExcelScript.Workbook) {

const currentSheet = workbook.getActiveWorksheet();
const usedRange = currentSheet.getUsedRange();

let values = usedRange.getValues();
let rowCount = usedRange.getRowCount();

for (let i = rowCount - 1; i >= 0; i--) {
if (
values[i][9] == "Apples" ||
values[i][9] == "Oranges" ||
values[i][9] == "Ackee" ||
values[i][9] == "Strawberry") {
usedRange.getCell(i, 1).getEntireRow().delete(ExcelScript.DeleteShiftDirection.up)
}
}
}