I am trying to update a column date value anytime any changes occur in any columns of the groups subitem. When I make any change it runs via the webhook “when any column changes.” And it is linked to the ScriptRunner. Same result API key or not.

import { UpdateSubitemColumnValueEvent } from ‘@sr-connect/monday/events’;

import Monday from “./api/monday”;

// Define the constants for the script

const WORKSPACE_ID = “Design Phase”;

const BOARD_ID = “Active Projects”;

const COLUMN_NAME = “Date Last”;

/**

• 
  

  Entry point to when “any subitem column changes” event is triggered

  
  




• 
  

  @param event Object that holds When any subitem column changes event data

  
  


• 
  

  @param context Object that holds function invocation context data
  
  */
  
  export default async function (event: UpdateSubitemColumnValueEvent, context: Context): Promise {
  
  if (context.triggerType === ‘MANUAL’) {
  
  console.error(‘This script is designed to be triggered externally or manually from the Event Listener. Please consider using Event Listener Test Event Payload if you need to trigger this script manually.’);
  
  return;
  
  }
  
  try {
  
  // Extract necessary parameters from the event
  
  const { parentItemId } = event.event;

  
  

   // Function to update the "Date Last" column for an item to today's date
  
   const updateDateLast = async (itemId: string) => {
  
       try {
  
           const today = new Date().toISOString().split('T') 0];
  
  
  
           // Construct the mutation query to update the "Date Last" column
  
           const query = `
  
               mutation {
  
                   change_column_value (board_id: "${BOARD_ID}", item_id: "${itemId}", column_id: "${COLUMN_NAME}", value: "${today}") {
  
                       id
  
                   }
  
               }
  
           `;
  
  
  
           // Execute the mutation query to update the column value
  
           const response = await fetch('https://api.monday.com/v2', {
  
               method: 'POST',
  
               headers: {
  
                   'Content-Type': 'application/json',
  
                   'Authorization': 'Bearer YOUR_API_KEY' 
  
               },
  
               body: JSON.stringify({ query })
  
           });
  
  
  
           const data = await response.json();
  
  
  
           console.log(`"Date Last" column updated for item ${itemId} to ${today}`);
  
       } catch (error) {
  
           console.error('Error updating column:', error);
  
       }
  
   };
  
  
  
   // Update the "Date Last" column for the affected item
  
   await updateDateLast(parentItemId);
  
  

  
  

  } catch (error) {
  
  console.error(‘Error handling subitem column updates:’, error);
  
  }
  
  }