App Script to push data from Google Sheet to Coda Table

1

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.

2

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.