TypeError: Cannot read property 'length' of undefined

Can you please post screenshots of your code step, including the input data that is being used and the code itself? And more specifically, it would be vital to know the type of the data you’re trying to get the length of (string, array, etc.)

So I did end up using the beta “Generate with AI” tool within the step to fix this. I simply copied the current code in the Javascript step into the AI tool and ran a test. Thankfully it kicked out the same error, and then offered to fix it. The fix worked and the zap starting working again. Still haven’t figured out how it was completing “lower” steps when it wasn’t getting through that one, but at least it works now. 

Red is the step that failed, green is the step that did the action in the Smartsheet which is adding a timestamp to a cell, yellow is the date/time formatter which may be why it did the lower green step anyway??

Thanks Tony - So another “only continue if” step just before Step 12 that would reference step 11? So “only continue if step 11 was completed?

@Todd Harper

@Troy Tessalone

Hey Todd/Troy - ok, while the AI fix did get the emails sending again I realized it stopped pulling the attachment from the row in SS. So I reverted back to the original code to just work on the original problem of “TypeError: Cannot read property 'length' of undefined”.

I tried using ChatGPT for a while as well as re-using the zapier AI, but nothing seems to work. In the version of the zap that sent an email but did not pull the attachment...the “document” within step 11 (send email via outlook) was yellow but I wasn’t sure how to reselect, so I assume it’s just not coded correctly in the javascript step. 

So here is the original code, and screen shots of the steps:

Steps:

Here is the code that the zapier AI came up with that seemed to work but failed to include the attachment:

// Define an object with a property named 'document'var obj = {  document: "",};// Construct the URL for the API request using the row ID from the inputDatavar url = `https://api.smartsheet.com/2.0/sheets/6322227864987524/rows/${inputData.row}/attachments`;// Make a GET request to the constructed URLvar res = await fetch(url, {  method: "GET",  headers: {    // Include the authorization token in the request headers    Authorization: "Bearer XXXXXXXXXXXXXXXXXXXX",  },});// Parse the response body as JSONvar body = await res.json();// Check if the response data contains any attachmentsif (body && body.data && body.data.length > 0) {  // If attachments are found, construct the URL for the attachment request using the attachment ID from the response  var url = `https://api.smartsheet.com/2.0/sheets/6322227864987524/attachments/${body.data[0].id}`;  // Make a GET request to the constructed URL  var res1 = await fetch(url, {    method: "GET",    headers: {      // Include the authorization token in the request headers      Authorization: "Bearer XXXXXXXXXXXXXXXXXXXX",    },  });  // Parse the response body as JSON  var body1 = await res1.json();  // Update the 'document' property of the 'obj' object with the URL of the attachment  obj.document = body1.url;}// Return the 'obj' objectreturn obj;

@Troy Tessalone 

ok thanks Troy, would this be what we’re looking for? Says the “document” field contains no value. But there was an attachment.

@Todd Harper 

Yes, there is definitely an attachment, and I just ran a test through the Smartsheet again to be sure. The email arrives correctly, but there is no attachment.

Thanks for your advice about the API keys. I’m playing catch up here on an previously existing zapier account and zaps, so I’m not sure what I’m doing. It was all working correctly for many months. How do I edit a post? I’m not seeing any option to? I put a support ticket into zapier to get them redacted.