• 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.