Auto SYnc and Autofetch not working
-
The trigger is working but the sheet doesnt update.
I have watched the instructions several times and have played around with the code.gs file with some success.
I was getting this error
Error while connecting your site: Exception: Request failed for https://broomfish.co.nz returned code 404. Truncated server response: {“code”:”rest_no_route”,”message”:”No route was found matching the URL and request method.”,”data”:{“status”:404}} (use muteHttpExceptions option to examine full response)
i made these changes recommended by a debugging AI site
// Preprating for batch update
function separateDataForCreatingAndUpdating(data) {
? var existingItems = [];
? var newItems = [];
// ?const variations = data.filter(obj => {
// const parent_id = Object.values(obj)[0].parent_id;
// ?return parent_id !== '' && parent_id !== "0";
// ?});
const variations = data.filter(obj => {
const values = Object.values(obj);
if (!values.length || typeof values[0] !== 'object') return false;
return values[0].parent_id === '' || values[0].parent_id === "0";
});
// const non_variations = data.filter(obj => {
// ? ?const parent_id = Object.values(obj)[0].parent_id;
// ? ?return parent_id === '' || parent_id === "0";
// ?});and the error is now
Cloud logs
Mar 2, 2025, 2:29:39?PM
Info
{create=[], update=[], variations=[]}
which looks to indicate no data is being sent?
Please help as i would like this to work
- You must be logged in to reply to this topic.