I have most of the code written, but testing i am getting this error. The upserRow is an issue with CodaAPI 12 library. What could be causing it. Here is the code i am testing to inusre it can push it.
function pushRowWithLibrary() {
CodaAPI.authenticate(‘your-token-here’);
const docId = ‘your-doc-id’;
const tableId = ‘YourCodaTable’;
const result = CodaAPI.upsertRows(docId, tableId, {
rows: [
{
cells: [
{ column: ‘ColumnA Name’, value: ‘LIB-456’ },
{ column: ‘ColumnB Qty’, value: 77 },
{ column: ‘columnC Location’, value: ‘Library Row’ }
]
}
]
});
Logger.log(JSON.stringify(result));
}
And here is the error code.
Exception: Request failed for https://coda.io returned code 404. Truncated server response: {“statusCode”:404,“statusMessage”:“Not Found”,“message”:“Doc does not exist or is inaccessible.”} (use muteHttpExceptions option to examine full response)
upsertRows
@ Coda.gs:822
pushRowWithLibrary
@ Code.gs:114
I have tripled check my doc id and table id info. No issues there. IF i go to lower version of CodaAPI the error moves with the upsertRow based on the rev of library. Don’t know if that helps.