Error processing email attachments: ${error.message}

`\n });\n \n throw error;\n }\n}\n\nasync function getDropboxAccessToken(): Promise {\n const refreshToken = Deno.env.get('DROPBOX_REFRESH_TOKEN');\n const clientId = Deno.env.get('DROPBOX_CLIENT_ID');\n const clientSecret = Deno.env.get('DROPBOX_CLIENT_SECRET');\n\n if (!refreshToken || !clientId || !clientSecret) {\n throw new Error('DROPBOX_REFRESH_TOKEN, DROPBOX_CLIENT_ID, and DROPBOX_CLIENT_SECRET environment variables are required');\n }\n\n const url = 'https://api.dropbox.com/oauth2/token';\n \n const formData = new URLSearchParams();\n formData.append('grant_type', 'refresh_token');\n formData.append('refresh_token', refreshToken);\n formData.append('client_id', clientId);\n formData.append('client_secret', clientSecret);\n\n const response = await fetch(url, {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/x-www-form-urlencoded',\n },\n body: formData\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`Failed to refresh Dropbox token: ${response.status} ${response.statusText} - ${errorText}`);\n }\n\n const tokenData: DropboxTokenResponse = await response.json();\n return tokenData.access_token;\n}\n\nasync function uploadToDropbox(\n accessToken: string,\n folderPath: string,\n fileName: string,\n fileData: ArrayBuffer,\n contentType: string\n): Promise {\n const url = 'https://content.dropboxapi.com/2/files/upload';\n \n // Create full path including folder\n const fullPath = `/${folderPath}/${fileName}`;\n \n const headers = {\n 'Authorization': `Bearer ${accessToken}`,\n 'Content-Type': 'application/octet-stream',\n 'Dropbox-API-Arg': JSON.stringify({\n path: fullPath,\n mode: 'add',\n autorename: true,\n mute: false,\n strict_conflict: false\n })\n };\n\n const response = await fetch(url, {\n method: 'POST',\n headers,\n body: fileData\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`Dropbox upload failed: ${response.status} ${response.statusText} - ${errorText}`);\n }\n\n return await response.json();\n} \n\nfunction getCurrentDateInAustraliaEast(): string {\n const now = new Date();\n\n // Use the Australia/Melbourne time zone (AEST or AEDT depending on date)\n const formatter = new Intl.DateTimeFormat('en-AU', {\n timeZone: 'Australia/Melbourne',\n year: 'numeric',\n month: '2-digit',\n day: '2-digit',\n });\n\n const parts = formatter.formatToParts(now);\n const year = parts.find(p => p.type === 'year')?.value;\n const month = parts.find(p => p.type === 'month')?.value;\n const day = parts.find(p => p.type === 'day')?.value;\n\n return `${year}-${month}-${day}`;\n}",[],[104],"files",[149,170,178,187],"counts",{"_200":31,"_201":182,"_202":31,"_203":204},"pulls","branches","forks","envVars",6,"contents",[],{"_108":188,"_100":104,"_152":189,"_154":-5,"_155":139,"_156":138,"_158":159,"_110":208,"_105":191,"_161":192,"_163":193,"_165":27,"_166":-5,"_103":209},["D",1750578530175],[104],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_98":99,"_100":101,"_102":42,"_103":104,"_106":216,"_162":220,"_223":224,"_275":276,"_289":-7,"_290":31,"_291":27},{"_108":109,"_100":101,"_110":217,"_112":-5,"_113":27,"_114":115,"_116":73,"_117":-5,"_12":118,"_119":-5,"_120":27,"_121":-5,"_122":31,"_123":124,"_125":124,"_126":127,"_128":127,"_129":127,"_130":124,"_131":124,"_132":27,"_21":218,"_136":219},["D",1750547731596],{"_98":99,"_134":135},{"_105":138,"_100":42,"_108":139,"_140":109,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":101,"_146":99},{"_108":188,"_100":104,"_152":189,"_154":-5,"_155":139,"_156":138,"_158":159,"_110":221,"_105":191,"_161":192,"_163":193,"_165":27,"_166":-5,"_103":222},["D",1750578530175],[104],"history",[225,227,233,239,244,248,253,258,262,267,271],{"_108":188,"_155":139,"_152":189,"_100":104,"_163":193,"_161":192,"_105":191,"_154":-5,"_110":226,"_156":138,"_166":-5},["D",1750578530175],{"_108":228,"_155":139,"_152":189,"_100":104,"_163":229,"_161":192,"_105":230,"_154":-5,"_110":231,"_156":232,"_166":-5},"d8def264-4f3c-11f0-876f-f69ea79377d9","import { email } from \"https://esm.town/v/std/email\";\n\ninterface Email {\n from: string;\n to: string;\n subject: string;\n text: string;\n html: string;\n attachments: File[];\n}\n\ninterface DropboxUploadResponse {\n id: string;\n name: string;\n path_display: string;\n size: number;\n}\n\ninterface DropboxTokenResponse {\n access_token: string;\n token_type: string;\n expires_in: number;\n refresh_token?: string;\n}\n\nexport default async function (emailData: Email) {\n try {\n console.log(\"emailData\", emailData);\n // Get current date in YYYY-mm-dd format\n const today = getCurrentDateInAustraliaEast();\n \n // Clean the subject for use as filename (remove special characters)\n const cleanSubject = emailData.subject\n .replace(/[^a-zA-Z0-9\\s-]/g, '') // Remove special characters except spaces and hyphens\n .replace(/\\s+/g, '-') // Replace spaces with hyphens\n .toLowerCase()\n .substring(0, 50); // Limit length\n \n if (emailData.attachments.length === 0) {\n console.log(\"No attachments found in email\");\n return;\n }\n\n // Get fresh access token\n const dropboxToken = await getDropboxAccessToken();\n if (!dropboxToken) {\n throw new Error('Failed to obtain Dropbox access token');\n }\n\n // Determine upload path based on email sender\n let uploadPath: string;\n if (emailData.from === Deno.env.get(\"SENDER_EMAIL_INVESTMENT\")) {\n uploadPath = Deno.env.get(\"DROPBOX_PATH_INVESTMENT\");\n } else {\n uploadPath = Deno.env.get(\"DROPBOX_PATH_EXPENSES\");\n }\n\n const results = [];\n\n for (const attachment of emailData.attachments) {\n try {\n // Create filename with date and subject\n const fileExtension = attachment.name.split('.').pop() || '';\n const baseName = attachment.name.split('.')[0] || 'attachment';\n const fileName = `${today}-${cleanSubject}-${baseName}.${fileExtension}`;\n \n // Upload to Dropbox with specific path\n const uploadResult = await uploadToDropbox(\n dropboxToken,\n uploadPath,\n fileName,\n await attachment.arrayBuffer(),\n attachment.type\n );\n \n results.push({\n originalName: attachment.name,\n uploadedName: fileName,\n dropboxPath: uploadResult.path_display,\n success: true\n });\n \n console.log(`Successfully uploaded: ${attachment.name} -> ${uploadPath}/${fileName}`);\n \n } catch (error) {\n console.error(`Failed to upload ${attachment.name}:`, error);\n results.push({\n originalName: attachment.name,\n success: false,\n error: error.message\n });\n }\n }\n\n // Send confirmation email\n const successCount = results.filter(r => r.success).length;\n const failureCount = results.filter(r => !r.success).length;\n \n let emailBody = `Email processed on ${today}\\n\\n`;\n emailBody += `Subject: ${emailData.subject}\\n`;\n emailBody += `From: ${emailData.from}\\n`;\n emailBody += `Upload Path: ${uploadPath}\\n\\n`;\n \n if (successCount > 0) {\n emailBody += `✅ Successfully uploaded ${successCount} attachment(s):\\n`;\n results.filter(r => r.success).forEach(result => {\n emailBody += ` - ${result.originalName} -> ${result.uploadedName}\\n`;\n emailBody += ` Dropbox path: ${result.dropboxPath}\\n`;\n });\n emailBody += '\\n';\n }\n \n if (failureCount > 0) {\n emailBody += `❌ Failed to upload ${failureCount} attachment(s):\\n`;\n results.filter(r => !r.success).forEach(result => {\n emailBody += ` - ${result.originalName}: ${result.error}\\n`;\n });\n }\n\n await email({\n subject: `Email Attachment Processing - ${today}`,\n text: emailBody,\n html: emailBody.replace(/\\n/g, '
')\n });\n\n } catch (error) {\n console.error('Error processing email:', error);\n \n // Send error notification\n await email({\n subject: 'Email Attachment Processing Error',\n text: `Error processing email attachments: ${error.message}`,\n html: `

Error processing email attachments: ${error.message}

`\n });\n \n throw error;\n }\n}\n\nasync function getDropboxAccessToken(): Promise {\n const refreshToken = Deno.env.get('DROPBOX_REFRESH_TOKEN');\n const clientId = Deno.env.get('DROPBOX_CLIENT_ID');\n const clientSecret = Deno.env.get('DROPBOX_CLIENT_SECRET');\n\n if (!refreshToken || !clientId || !clientSecret) {\n throw new Error('DROPBOX_REFRESH_TOKEN, DROPBOX_CLIENT_ID, and DROPBOX_CLIENT_SECRET environment variables are required');\n }\n\n const url = 'https://api.dropbox.com/oauth2/token';\n \n const formData = new URLSearchParams();\n formData.append('grant_type', 'refresh_token');\n formData.append('refresh_token', refreshToken);\n formData.append('client_id', clientId);\n formData.append('client_secret', clientSecret);\n\n const response = await fetch(url, {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/x-www-form-urlencoded',\n },\n body: formData\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`Failed to refresh Dropbox token: ${response.status} ${response.statusText} - ${errorText}`);\n }\n\n const tokenData: DropboxTokenResponse = await response.json();\n return tokenData.access_token;\n}\n\nasync function uploadToDropbox(\n accessToken: string,\n folderPath: string,\n fileName: string,\n fileData: ArrayBuffer,\n contentType: string\n): Promise {\n const url = 'https://content.dropboxapi.com/2/files/upload';\n \n // Create full path including folder\n const fullPath = `/${folderPath}/${fileName}`;\n \n const headers = {\n 'Authorization': `Bearer ${accessToken}`,\n 'Content-Type': 'application/octet-stream',\n 'Dropbox-API-Arg': JSON.stringify({\n path: fullPath,\n mode: 'add',\n autorename: true,\n mute: false,\n strict_conflict: false\n })\n };\n\n const response = await fetch(url, {\n method: 'POST',\n headers,\n body: fileData\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`Dropbox upload failed: ${response.status} ${response.statusText} - ${errorText}`);\n }\n\n return await response.json();\n} \n\nfunction getCurrentDateInAustraliaEast(): string {\n const now = new Date();\n\n // Use the Australia/Melbourne time zone (AEST or AEDT depending on date)\n const formatter = new Intl.DateTimeFormat('en-AU', {\n timeZone: 'Australia/Melbourne',\n year: 'numeric',\n month: '2-digit',\n day: '2-digit',\n });\n\n const parts = formatter.formatToParts(now);\n const year = parts.find(p => p.type === 'year')?.value;\n const month = parts.find(p => p.type === 'month')?.value;\n const day = parts.find(p => p.type === 'day')?.value;\n\n return `${year}-${month}-${day}`;\n}",9,["D",1750578320331],13,{"_108":234,"_155":139,"_152":189,"_100":104,"_163":235,"_161":192,"_105":236,"_154":-5,"_110":237,"_156":238,"_166":-5},"6fce1110-4f0a-11f0-be16-f69ea79377d9","import { email } from \"https://esm.town/v/std/email\";\n\ninterface Email {\n from: string;\n to: string;\n subject: string;\n text: string;\n html: string;\n attachments: File[];\n}\n\ninterface DropboxUploadResponse {\n id: string;\n name: string;\n path_display: string;\n size: number;\n}\n\nexport default async function (emailData: Email) {\n try {\n console.log(\"emailData\", emailData);\n // Get current date in YYYY-mm-dd format\n const today = getCurrentDateInAustraliaEast();\n \n // Clean the subject for use as filename (remove special characters)\n const cleanSubject = emailData.subject\n .replace(/[^a-zA-Z0-9\\s-]/g, '') // Remove special characters except spaces and hyphens\n .replace(/\\s+/g, '-') // Replace spaces with hyphens\n .toLowerCase()\n .substring(0, 50); // Limit length\n \n if (emailData.attachments.length === 0) {\n console.log(\"No attachments found in email\");\n return;\n }\n\n const dropboxToken = Deno.env.get('DROPBOX_ACCESS_TOKEN');\n if (!dropboxToken) {\n throw new Error('DROPBOX_ACCESS_TOKEN environment variable is required');\n }\n\n // Determine upload path based on email sender\n let uploadPath: string;\n if (emailData.from === Deno.env.get(\"SENDER_EMAIL_INVESTMENT\")) {\n uploadPath = Deno.env.get(\"DROPBOX_PATH_INVESTMENT\");\n } else {\n uploadPath = Deno.env.get(\"DROPBOX_PATH_EXPENSES\");\n }\n\n const results = [];\n\n for (const attachment of emailData.attachments) {\n try {\n // Create filename with date and subject\n const fileExtension = attachment.name.split('.').pop() || '';\n const baseName = attachment.name.split('.')[0] || 'attachment';\n const fileName = `${today}-${cleanSubject}-${baseName}.${fileExtension}`;\n \n // Upload to Dropbox with specific path\n const uploadResult = await uploadToDropbox(\n dropboxToken,\n uploadPath,\n fileName,\n await attachment.arrayBuffer(),\n attachment.type\n );\n \n results.push({\n originalName: attachment.name,\n uploadedName: fileName,\n dropboxPath: uploadResult.path_display,\n success: true\n });\n \n console.log(`Successfully uploaded: ${attachment.name} -> ${uploadPath}/${fileName}`);\n \n } catch (error) {\n console.error(`Failed to upload ${attachment.name}:`, error);\n results.push({\n originalName: attachment.name,\n success: false,\n error: error.message\n });\n }\n }\n\n // Send confirmation email\n const successCount = results.filter(r => r.success).length;\n const failureCount = results.filter(r => !r.success).length;\n \n let emailBody = `Email processed on ${today}\\n\\n`;\n emailBody += `Subject: ${emailData.subject}\\n`;\n emailBody += `From: ${emailData.from}\\n`;\n emailBody += `Upload Path: ${uploadPath}\\n\\n`;\n \n if (successCount > 0) {\n emailBody += `✅ Successfully uploaded ${successCount} attachment(s):\\n`;\n results.filter(r => r.success).forEach(result => {\n emailBody += ` - ${result.originalName} -> ${result.uploadedName}\\n`;\n emailBody += ` Dropbox path: ${result.dropboxPath}\\n`;\n });\n emailBody += '\\n';\n }\n \n if (failureCount > 0) {\n emailBody += `❌ Failed to upload ${failureCount} attachment(s):\\n`;\n results.filter(r => !r.success).forEach(result => {\n emailBody += ` - ${result.originalName}: ${result.error}\\n`;\n });\n }\n\n await email({\n subject: `Email Attachment Processing - ${today}`,\n text: emailBody,\n html: emailBody.replace(/\\n/g, '
')\n });\n\n } catch (error) {\n console.error('Error processing email:', error);\n \n // Send error notification\n await email({\n subject: 'Email Attachment Processing Error',\n text: `Error processing email attachments: ${error.message}`,\n html: `

Error processing email attachments: ${error.message}

`\n });\n \n throw error;\n }\n}\n\nasync function uploadToDropbox(\n accessToken: string,\n folderPath: string,\n fileName: string,\n fileData: ArrayBuffer,\n contentType: string\n): Promise {\n const url = 'https://content.dropboxapi.com/2/files/upload';\n \n // Create full path including folder\n const fullPath = `/${folderPath}/${fileName}`;\n \n const headers = {\n 'Authorization': `Bearer ${accessToken}`,\n 'Content-Type': 'application/octet-stream',\n 'Dropbox-API-Arg': JSON.stringify({\n path: fullPath,\n mode: 'add',\n autorename: true,\n mute: false,\n strict_conflict: false\n })\n };\n\n const response = await fetch(url, {\n method: 'POST',\n headers,\n body: fileData\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`Dropbox upload failed: ${response.status} ${response.statusText} - ${errorText}`);\n }\n\n return await response.json();\n} \n\nfunction getCurrentDateInAustraliaEast(): string {\n const now = new Date();\n\n // Use the Australia/Melbourne time zone (AEST or AEDT depending on date)\n const formatter = new Intl.DateTimeFormat('en-AU', {\n timeZone: 'Australia/Melbourne',\n year: 'numeric',\n month: '2-digit',\n day: '2-digit',\n });\n\n const parts = formatter.formatToParts(now);\n const year = parts.find(p => p.type === 'year')?.value;\n const month = parts.find(p => p.type === 'month')?.value;\n const day = parts.find(p => p.type === 'day')?.value;\n\n return `${year}-${month}-${day}`;\n}",8,["D",1750556669155],11,{"_108":240,"_155":139,"_152":189,"_100":104,"_163":241,"_161":192,"_105":242,"_154":-5,"_110":243,"_156":191,"_166":-5},"ddcd678a-4ef9-11f0-be58-f69ea79377d9","import { email } from \"https://esm.town/v/std/email\";\n\ninterface Email {\n from: string;\n to: string;\n subject: string;\n text: string;\n html: string;\n attachments: File[];\n}\n\ninterface DropboxUploadResponse {\n id: string;\n name: string;\n path_display: string;\n size: number;\n}\n\nexport default async function (emailData: Email) {\n try {\n // Get current date in YYYY-mm-dd format\n const today = getCurrentDateInAustraliaEast();\n \n // Clean the subject for use as filename (remove special characters)\n const cleanSubject = emailData.subject\n .replace(/[^a-zA-Z0-9\\s-]/g, '') // Remove special characters except spaces and hyphens\n .replace(/\\s+/g, '-') // Replace spaces with hyphens\n .toLowerCase()\n .substring(0, 50); // Limit length\n \n if (emailData.attachments.length === 0) {\n console.log(\"No attachments found in email\");\n return;\n }\n\n const dropboxToken = Deno.env.get('DROPBOX_ACCESS_TOKEN');\n if (!dropboxToken) {\n throw new Error('DROPBOX_ACCESS_TOKEN environment variable is required');\n }\n\n // Determine upload path based on email sender\n let uploadPath: string;\n if (emailData.from === Deno.env.get(\"SENDER_EMAIL_INVESTMENT\")) {\n uploadPath = Deno.env.get(\"DROPBOX_PATH_INVESTMENT\");\n } else {\n uploadPath = Deno.env.get(\"DROPBOX_PATH_EXPENSES\");\n }\n\n const results = [];\n\n for (const attachment of emailData.attachments) {\n try {\n // Create filename with date and subject\n const fileExtension = attachment.name.split('.').pop() || '';\n const baseName = attachment.name.split('.')[0] || 'attachment';\n const fileName = `${today}-${cleanSubject}-${baseName}.${fileExtension}`;\n \n // Upload to Dropbox with specific path\n const uploadResult = await uploadToDropbox(\n dropboxToken,\n uploadPath,\n fileName,\n await attachment.arrayBuffer(),\n attachment.type\n );\n \n results.push({\n originalName: attachment.name,\n uploadedName: fileName,\n dropboxPath: uploadResult.path_display,\n success: true\n });\n \n console.log(`Successfully uploaded: ${attachment.name} -> ${uploadPath}/${fileName}`);\n \n } catch (error) {\n console.error(`Failed to upload ${attachment.name}:`, error);\n results.push({\n originalName: attachment.name,\n success: false,\n error: error.message\n });\n }\n }\n\n // Send confirmation email\n const successCount = results.filter(r => r.success).length;\n const failureCount = results.filter(r => !r.success).length;\n \n let emailBody = `Email processed on ${today}\\n\\n`;\n emailBody += `Subject: ${emailData.subject}\\n`;\n emailBody += `From: ${emailData.from}\\n`;\n emailBody += `Upload Path: ${uploadPath}\\n\\n`;\n \n if (successCount > 0) {\n emailBody += `✅ Successfully uploaded ${successCount} attachment(s):\\n`;\n results.filter(r => r.success).forEach(result => {\n emailBody += ` - ${result.originalName} -> ${result.uploadedName}\\n`;\n emailBody += ` Dropbox path: ${result.dropboxPath}\\n`;\n });\n emailBody += '\\n';\n }\n \n if (failureCount > 0) {\n emailBody += `❌ Failed to upload ${failureCount} attachment(s):\\n`;\n results.filter(r => !r.success).forEach(result => {\n emailBody += ` - ${result.originalName}: ${result.error}\\n`;\n });\n }\n\n await email({\n subject: `Email Attachment Processing - ${today}`,\n text: emailBody,\n html: emailBody.replace(/\\n/g, '
')\n });\n\n } catch (error) {\n console.error('Error processing email:', error);\n \n // Send error notification\n await email({\n subject: 'Email Attachment Processing Error',\n text: `Error processing email attachments: ${error.message}`,\n html: `

Error processing email attachments: ${error.message}

`\n });\n \n throw error;\n }\n}\n\nasync function uploadToDropbox(\n accessToken: string,\n folderPath: string,\n fileName: string,\n fileData: ArrayBuffer,\n contentType: string\n): Promise {\n const url = 'https://content.dropboxapi.com/2/files/upload';\n \n // Create full path including folder\n const fullPath = `/${folderPath}/${fileName}`;\n \n const headers = {\n 'Authorization': `Bearer ${accessToken}`,\n 'Content-Type': 'application/octet-stream',\n 'Dropbox-API-Arg': JSON.stringify({\n path: fullPath,\n mode: 'add',\n autorename: true,\n mute: false,\n strict_conflict: false\n })\n };\n\n const response = await fetch(url, {\n method: 'POST',\n headers,\n body: fileData\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`Dropbox upload failed: ${response.status} ${response.statusText} - ${errorText}`);\n }\n\n return await response.json();\n} \n\nfunction getCurrentDateInAustraliaEast(): string {\n const now = new Date();\n\n // Use the Australia/Melbourne time zone (AEST or AEDT depending on date)\n const formatter = new Intl.DateTimeFormat('en-AU', {\n timeZone: 'Australia/Melbourne',\n year: 'numeric',\n month: '2-digit',\n day: '2-digit',\n });\n\n const parts = formatter.formatToParts(now);\n const year = parts.find(p => p.type === 'year')?.value;\n const month = parts.find(p => p.type === 'month')?.value;\n const day = parts.find(p => p.type === 'day')?.value;\n\n return `${year}-${month}-${day}`;\n}",7,["D",1750549552343],{"_108":245,"_155":139,"_152":189,"_100":104,"_163":246,"_161":192,"_105":204,"_154":-5,"_110":247,"_156":230,"_166":-5},"c91c89a2-4ef8-11f0-b9d2-f69ea79377d9","import { email } from \"https://esm.town/v/std/email\";\n\ninterface Email {\n from: string;\n to: string;\n subject: string;\n text: string;\n html: string;\n attachments: File[];\n}\n\ninterface DropboxUploadResponse {\n id: string;\n name: string;\n path_display: string;\n size: number;\n}\n\nexport default async function (emailData: Email) {\n try {\n console.log(\"emailData\", emailData);\n // Get current date in YYYY-mm-dd format\n const today = new Date().toISOString().split('T')[0];\n \n // Clean the subject for use as filename (remove special characters)\n const cleanSubject = emailData.subject\n .replace(/[^a-zA-Z0-9\\s-]/g, '') // Remove special characters except spaces and hyphens\n .replace(/\\s+/g, '-') // Replace spaces with hyphens\n .toLowerCase()\n .substring(0, 50); // Limit length\n \n if (emailData.attachments.length === 0) {\n console.log(\"No attachments found in email\");\n return;\n }\n\n const dropboxToken = Deno.env.get('DROPBOX_ACCESS_TOKEN');\n if (!dropboxToken) {\n throw new Error('DROPBOX_ACCESS_TOKEN environment variable is required');\n }\n\n // Determine upload path based on email sender\n let uploadPath: string;\n if (emailData.from === Deno.env.get(\"SENDER_EMAIL_INVESTMENT\")) {\n uploadPath = Deno.env.get(\"DROPBOX_PATH_INVESTMENT\");\n } else {\n uploadPath = Deno.env.get(\"DROPBOX_PATH_EXPENSES\");\n }\n\n const results = [];\n\n for (const attachment of emailData.attachments) {\n try {\n console.log(\"attachment.keys\", Object.keys(attachment));\n // Create filename with date and subject\n console.log(\"attachment.filename\", attachment.name);\n const fileExtension = attachment.name.split('.').pop() || '';\n const baseName = attachment.name.split('.')[0] || 'attachment';\n const fileName = `${today}-${cleanSubject}-${baseName}.${fileExtension}`;\n \n // Upload to Dropbox with specific path\n const uploadResult = await uploadToDropbox(\n dropboxToken,\n uploadPath,\n fileName,\n await attachment.arrayBuffer(),\n attachment.type\n );\n \n results.push({\n originalName: attachment.name,\n uploadedName: fileName,\n dropboxPath: uploadResult.path_display,\n success: true\n });\n \n console.log(`Successfully uploaded: ${attachment.name} -> ${uploadPath}/${fileName}`);\n \n } catch (error) {\n console.error(`Failed to upload ${attachment.name}:`, error);\n results.push({\n originalName: attachment.name,\n success: false,\n error: error.message\n });\n }\n }\n\n // Send confirmation email\n const successCount = results.filter(r => r.success).length;\n const failureCount = results.filter(r => !r.success).length;\n \n let emailBody = `Email processed on ${today}\\n\\n`;\n emailBody += `Subject: ${emailData.subject}\\n`;\n emailBody += `From: ${emailData.from}\\n`;\n emailBody += `Upload Path: ${uploadPath}\\n\\n`;\n \n if (successCount > 0) {\n emailBody += `✅ Successfully uploaded ${successCount} attachment(s):\\n`;\n results.filter(r => r.success).forEach(result => {\n emailBody += ` - ${result.originalName} -> ${result.uploadedName}\\n`;\n emailBody += ` Dropbox path: ${result.dropboxPath}\\n`;\n });\n emailBody += '\\n';\n }\n \n if (failureCount > 0) {\n emailBody += `❌ Failed to upload ${failureCount} attachment(s):\\n`;\n results.filter(r => !r.success).forEach(result => {\n emailBody += ` - ${result.originalName}: ${result.error}\\n`;\n });\n }\n\n await email({\n subject: `Email Attachment Processing - ${today}`,\n text: emailBody,\n html: emailBody.replace(/\\n/g, '
')\n });\n\n } catch (error) {\n console.error('Error processing email:', error);\n \n // Send error notification\n await email({\n subject: 'Email Attachment Processing Error',\n text: `Error processing email attachments: ${error.message}`,\n html: `

Error processing email attachments: ${error.message}

`\n });\n \n throw error;\n }\n}\n\nasync function uploadToDropbox(\n accessToken: string,\n folderPath: string,\n fileName: string,\n fileData: ArrayBuffer,\n contentType: string\n): Promise {\n const url = 'https://content.dropboxapi.com/2/files/upload';\n \n // Create full path including folder\n const fullPath = `/${folderPath}/${fileName}`;\n \n const headers = {\n 'Authorization': `Bearer ${accessToken}`,\n 'Content-Type': 'application/octet-stream',\n 'Dropbox-API-Arg': JSON.stringify({\n path: fullPath,\n mode: 'add',\n autorename: true,\n mute: false,\n strict_conflict: false\n })\n };\n\n const response = await fetch(url, {\n method: 'POST',\n headers,\n body: fileData\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`Dropbox upload failed: ${response.status} ${response.statusText} - ${errorText}`);\n }\n\n return await response.json();\n} ",["D",1750549088123],{"_108":249,"_155":139,"_152":189,"_100":104,"_163":250,"_161":192,"_105":251,"_154":-5,"_110":252,"_156":236,"_166":-5},"1cfea15a-4ef8-11f0-b027-f69ea79377d9","import { AttachmentData, email } from \"https://esm.town/v/std/email\";\n\ninterface Email {\n from: string;\n to: string;\n subject: string;\n text: string;\n html: string;\n attachments: AttachmentData[];\n}\n\ninterface DropboxUploadResponse {\n id: string;\n name: string;\n path_display: string;\n size: number;\n}\n\nexport default async function (emailData: Email) {\n try {\n console.log(\"emailData\", emailData);\n // Get current date in YYYY-mm-dd format\n const today = new Date().toISOString().split('T')[0];\n \n // Clean the subject for use as filename (remove special characters)\n const cleanSubject = emailData.subject\n .replace(/[^a-zA-Z0-9\\s-]/g, '') // Remove special characters except spaces and hyphens\n .replace(/\\s+/g, '-') // Replace spaces with hyphens\n .toLowerCase()\n .substring(0, 50); // Limit length\n \n if (emailData.attachments.length === 0) {\n console.log(\"No attachments found in email\");\n return;\n }\n\n const dropboxToken = Deno.env.get('DROPBOX_ACCESS_TOKEN');\n if (!dropboxToken) {\n throw new Error('DROPBOX_ACCESS_TOKEN environment variable is required');\n }\n\n // Determine upload path based on email sender\n let uploadPath: string;\n if (emailData.from === Deno.env.get(\"SENDER_EMAIL_INVESTMENT\")) {\n uploadPath = Deno.env.get(\"DROPBOX_PATH_INVESTMENT\");\n } else {\n uploadPath = Deno.env.get(\"DROPBOX_PATH_EXPENSES\");\n }\n\n const results = [];\n\n for (const attachment of emailData.attachments) {\n try {\n console.log(\"attachment.keys\", Object.keys(attachment));\n // Create filename with date and subject\n console.log(\"attachment.filename\", attachment.filename);\n const fileExtension = attachment.filename.split('.').pop() || '';\n const baseName = attachment.filename.split('.')[0] || 'attachment';\n const fileName = `${today}-${cleanSubject}-${baseName}.${fileExtension}`;\n \n // Upload to Dropbox with specific path\n const uploadResult = await uploadToDropbox(\n dropboxToken,\n uploadPath,\n fileName,\n attachment.content,\n attachment.type\n );\n \n results.push({\n originalName: attachment.filename,\n uploadedName: fileName,\n dropboxPath: uploadResult.path_display,\n success: true\n });\n \n console.log(`Successfully uploaded: ${attachment.filename} -> ${uploadPath}/${fileName}`);\n \n } catch (error) {\n console.error(`Failed to upload ${attachment.filename}:`, error);\n results.push({\n originalName: attachment.filename,\n success: false,\n error: error.message\n });\n }\n }\n\n // Send confirmation email\n const successCount = results.filter(r => r.success).length;\n const failureCount = results.filter(r => !r.success).length;\n \n let emailBody = `Email processed on ${today}\\n\\n`;\n emailBody += `Subject: ${emailData.subject}\\n`;\n emailBody += `From: ${emailData.from}\\n`;\n emailBody += `Upload Path: ${uploadPath}\\n\\n`;\n \n if (successCount > 0) {\n emailBody += `✅ Successfully uploaded ${successCount} attachment(s):\\n`;\n results.filter(r => r.success).forEach(result => {\n emailBody += ` - ${result.originalName} -> ${result.uploadedName}\\n`;\n emailBody += ` Dropbox path: ${result.dropboxPath}\\n`;\n });\n emailBody += '\\n';\n }\n \n if (failureCount > 0) {\n emailBody += `❌ Failed to upload ${failureCount} attachment(s):\\n`;\n results.filter(r => !r.success).forEach(result => {\n emailBody += ` - ${result.originalName}: ${result.error}\\n`;\n });\n }\n\n await email({\n subject: `Email Attachment Processing - ${today}`,\n text: emailBody,\n html: emailBody.replace(/\\n/g, '
')\n });\n\n } catch (error) {\n console.error('Error processing email:', error);\n \n // Send error notification\n await email({\n subject: 'Email Attachment Processing Error',\n text: `Error processing email attachments: ${error.message}`,\n html: `

Error processing email attachments: ${error.message}

`\n });\n \n throw error;\n }\n}\n\nasync function uploadToDropbox(\n accessToken: string,\n folderPath: string,\n fileName: string,\n fileData: string,\n contentType: string\n): Promise {\n const url = 'https://content.dropboxapi.com/2/files/upload';\n \n // Decode base64 data\n const binaryData = Uint8Array.from(atob(fileData), c => c.charCodeAt(0));\n \n // Create full path including folder\n const fullPath = `/${folderPath}/${fileName}`;\n \n const headers = {\n 'Authorization': `Bearer ${accessToken}`,\n 'Content-Type': 'application/octet-stream',\n 'Dropbox-API-Arg': JSON.stringify({\n path: fullPath,\n mode: 'add',\n autorename: true,\n mute: false,\n strict_conflict: false\n })\n };\n\n const response = await fetch(url, {\n method: 'POST',\n headers,\n body: binaryData\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`Dropbox upload failed: ${response.status} ${response.statusText} - ${errorText}`);\n }\n\n return await response.json();\n} ",5,["D",1750548799365],{"_108":254,"_155":139,"_152":189,"_100":104,"_163":255,"_161":192,"_105":256,"_154":-5,"_110":257,"_156":242,"_166":-5},"a64b96bc-4ef7-11f0-9df3-f69ea79377d9","import { AttachmentData, email } from \"https://esm.town/v/std/email\";\n\ninterface Email {\n from: string;\n to: string;\n subject: string;\n text: string;\n html: string;\n attachments: AttachmentData[];\n}\n\ninterface DropboxUploadResponse {\n id: string;\n name: string;\n path_display: string;\n size: number;\n}\n\nexport default async function (emailData: Email) {\n try {\n // Get current date in YYYY-mm-dd format\n const today = new Date().toISOString().split('T')[0];\n \n // Clean the subject for use as filename (remove special characters)\n const cleanSubject = emailData.subject\n .replace(/[^a-zA-Z0-9\\s-]/g, '') // Remove special characters except spaces and hyphens\n .replace(/\\s+/g, '-') // Replace spaces with hyphens\n .toLowerCase()\n .substring(0, 50); // Limit length\n \n if (emailData.attachments.length === 0) {\n console.log(\"No attachments found in email\");\n return;\n }\n\n const dropboxToken = Deno.env.get('DROPBOX_ACCESS_TOKEN');\n if (!dropboxToken) {\n throw new Error('DROPBOX_ACCESS_TOKEN environment variable is required');\n }\n\n // Determine upload path based on email sender\n let uploadPath: string;\n if (emailData.from === Deno.env.get(\"SENDER_EMAIL_INVESTMENT\")) {\n uploadPath = Deno.env.get(\"DROPBOX_PATH_INVESTMENT\");\n } else {\n uploadPath = Deno.env.get(\"DROPBOX_PATH_EXPENSES\");\n }\n\n const results = [];\n\n for (const attachment of emailData.attachments) {\n try {\n console.log(\"attachment.keys\", Object.keys(attachment));\n // Create filename with date and subject\n console.log(\"attachment.filename\", attachment.filename);\n const fileExtension = attachment.filename.split('.').pop() || '';\n const baseName = attachment.filename.split('.')[0] || 'attachment';\n const fileName = `${today}-${cleanSubject}-${baseName}.${fileExtension}`;\n \n // Upload to Dropbox with specific path\n const uploadResult = await uploadToDropbox(\n dropboxToken,\n uploadPath,\n fileName,\n attachment.content,\n attachment.type\n );\n \n results.push({\n originalName: attachment.filename,\n uploadedName: fileName,\n dropboxPath: uploadResult.path_display,\n success: true\n });\n \n console.log(`Successfully uploaded: ${attachment.filename} -> ${uploadPath}/${fileName}`);\n \n } catch (error) {\n console.error(`Failed to upload ${attachment.filename}:`, error);\n results.push({\n originalName: attachment.filename,\n success: false,\n error: error.message\n });\n }\n }\n\n // Send confirmation email\n const successCount = results.filter(r => r.success).length;\n const failureCount = results.filter(r => !r.success).length;\n \n let emailBody = `Email processed on ${today}\\n\\n`;\n emailBody += `Subject: ${emailData.subject}\\n`;\n emailBody += `From: ${emailData.from}\\n`;\n emailBody += `Upload Path: ${uploadPath}\\n\\n`;\n \n if (successCount > 0) {\n emailBody += `✅ Successfully uploaded ${successCount} attachment(s):\\n`;\n results.filter(r => r.success).forEach(result => {\n emailBody += ` - ${result.originalName} -> ${result.uploadedName}\\n`;\n emailBody += ` Dropbox path: ${result.dropboxPath}\\n`;\n });\n emailBody += '\\n';\n }\n \n if (failureCount > 0) {\n emailBody += `❌ Failed to upload ${failureCount} attachment(s):\\n`;\n results.filter(r => !r.success).forEach(result => {\n emailBody += ` - ${result.originalName}: ${result.error}\\n`;\n });\n }\n\n await email({\n subject: `Email Attachment Processing - ${today}`,\n text: emailBody,\n html: emailBody.replace(/\\n/g, '
')\n });\n\n } catch (error) {\n console.error('Error processing email:', error);\n \n // Send error notification\n await email({\n subject: 'Email Attachment Processing Error',\n text: `Error processing email attachments: ${error.message}`,\n html: `

Error processing email attachments: ${error.message}

`\n });\n \n throw error;\n }\n}\n\nasync function uploadToDropbox(\n accessToken: string,\n folderPath: string,\n fileName: string,\n fileData: string,\n contentType: string\n): Promise {\n const url = 'https://content.dropboxapi.com/2/files/upload';\n \n // Decode base64 data\n const binaryData = Uint8Array.from(atob(fileData), c => c.charCodeAt(0));\n \n // Create full path including folder\n const fullPath = `/${folderPath}/${fileName}`;\n \n const headers = {\n 'Authorization': `Bearer ${accessToken}`,\n 'Content-Type': 'application/octet-stream',\n 'Dropbox-API-Arg': JSON.stringify({\n path: fullPath,\n mode: 'add',\n autorename: true,\n mute: false,\n strict_conflict: false\n })\n };\n\n const response = await fetch(url, {\n method: 'POST',\n headers,\n body: binaryData\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`Dropbox upload failed: ${response.status} ${response.statusText} - ${errorText}`);\n }\n\n return await response.json();\n} ",4,["D",1750548600223],{"_108":259,"_155":139,"_152":189,"_100":104,"_163":260,"_161":192,"_105":174,"_154":-5,"_110":261,"_156":204,"_166":-5},"9435a83c-4ef7-11f0-8d9a-f69ea79377d9","import { AttachmentData, email } from \"https://esm.town/v/std/email\";\n\ninterface Email {\n from: string;\n to: string;\n subject: string;\n text: string;\n html: string;\n attachments: AttachmentData[];\n}\n\ninterface DropboxUploadResponse {\n id: string;\n name: string;\n path_display: string;\n size: number;\n}\n\nexport default async function (emailData: Email) {\n try {\n // Get current date in YYYY-mm-dd format\n const today = new Date().toISOString().split('T')[0];\n \n // Clean the subject for use as filename (remove special characters)\n const cleanSubject = emailData.subject\n .replace(/[^a-zA-Z0-9\\s-]/g, '') // Remove special characters except spaces and hyphens\n .replace(/\\s+/g, '-') // Replace spaces with hyphens\n .toLowerCase()\n .substring(0, 50); // Limit length\n \n if (emailData.attachments.length === 0) {\n console.log(\"No attachments found in email\");\n return;\n }\n\n const dropboxToken = Deno.env.get('DROPBOX_ACCESS_TOKEN');\n if (!dropboxToken) {\n throw new Error('DROPBOX_ACCESS_TOKEN environment variable is required');\n }\n\n // Determine upload path based on email sender\n let uploadPath: string;\n if (emailData.from === Deno.env.get(\"SENDER_EMAIL_INVESTMENT\")) {\n uploadPath = Deno.env.get(\"DROPBOX_PATH_INVESTMENT\");\n } else {\n uploadPath = Deno.env.get(\"DROPBOX_PATH_EXPENSES\");\n }\n\n const results = [];\n\n for (const attachment of emailData.attachments) {\n try {\n // Create filename with date and subject\n console.log(\"attachment.filename\", attachment.filename);\n const fileExtension = attachment.filename.split('.').pop() || '';\n const baseName = attachment.filename.split('.')[0] || 'attachment';\n const fileName = `${today}-${cleanSubject}-${baseName}.${fileExtension}`;\n \n // Upload to Dropbox with specific path\n const uploadResult = await uploadToDropbox(\n dropboxToken,\n uploadPath,\n fileName,\n attachment.content,\n attachment.type\n );\n \n results.push({\n originalName: attachment.filename,\n uploadedName: fileName,\n dropboxPath: uploadResult.path_display,\n success: true\n });\n \n console.log(`Successfully uploaded: ${attachment.filename} -> ${uploadPath}/${fileName}`);\n \n } catch (error) {\n console.error(`Failed to upload ${attachment.filename}:`, error);\n results.push({\n originalName: attachment.filename,\n success: false,\n error: error.message\n });\n }\n }\n\n // Send confirmation email\n const successCount = results.filter(r => r.success).length;\n const failureCount = results.filter(r => !r.success).length;\n \n let emailBody = `Email processed on ${today}\\n\\n`;\n emailBody += `Subject: ${emailData.subject}\\n`;\n emailBody += `From: ${emailData.from}\\n`;\n emailBody += `Upload Path: ${uploadPath}\\n\\n`;\n \n if (successCount > 0) {\n emailBody += `✅ Successfully uploaded ${successCount} attachment(s):\\n`;\n results.filter(r => r.success).forEach(result => {\n emailBody += ` - ${result.originalName} -> ${result.uploadedName}\\n`;\n emailBody += ` Dropbox path: ${result.dropboxPath}\\n`;\n });\n emailBody += '\\n';\n }\n \n if (failureCount > 0) {\n emailBody += `❌ Failed to upload ${failureCount} attachment(s):\\n`;\n results.filter(r => !r.success).forEach(result => {\n emailBody += ` - ${result.originalName}: ${result.error}\\n`;\n });\n }\n\n await email({\n subject: `Email Attachment Processing - ${today}`,\n text: emailBody,\n html: emailBody.replace(/\\n/g, '
')\n });\n\n } catch (error) {\n console.error('Error processing email:', error);\n \n // Send error notification\n await email({\n subject: 'Email Attachment Processing Error',\n text: `Error processing email attachments: ${error.message}`,\n html: `

Error processing email attachments: ${error.message}

`\n });\n \n throw error;\n }\n}\n\nasync function uploadToDropbox(\n accessToken: string,\n folderPath: string,\n fileName: string,\n fileData: string,\n contentType: string\n): Promise {\n const url = 'https://content.dropboxapi.com/2/files/upload';\n \n // Decode base64 data\n const binaryData = Uint8Array.from(atob(fileData), c => c.charCodeAt(0));\n \n // Create full path including folder\n const fullPath = `/${folderPath}/${fileName}`;\n \n const headers = {\n 'Authorization': `Bearer ${accessToken}`,\n 'Content-Type': 'application/octet-stream',\n 'Dropbox-API-Arg': JSON.stringify({\n path: fullPath,\n mode: 'add',\n autorename: true,\n mute: false,\n strict_conflict: false\n })\n };\n\n const response = await fetch(url, {\n method: 'POST',\n headers,\n body: binaryData\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`Dropbox upload failed: ${response.status} ${response.statusText} - ${errorText}`);\n }\n\n return await response.json();\n} ",["D",1750548569877],{"_108":263,"_155":139,"_152":189,"_100":104,"_163":264,"_161":192,"_105":265,"_154":-5,"_110":266,"_156":251,"_166":-5},"04fef8bc-4ef7-11f0-af03-f69ea79377d9","import { email } from \"https://esm.town/v/std/email\";\n\ninterface EmailAttachment {\n filename: string;\n contentType: string;\n data: string; // base64 encoded data\n}\n\ninterface Email {\n from: string;\n to: string;\n subject: string;\n text: string;\n html: string;\n attachments: EmailAttachment[];\n}\n\ninterface DropboxUploadResponse {\n id: string;\n name: string;\n path_display: string;\n size: number;\n}\n\nexport default async function (emailData: Email) {\n try {\n // Get current date in YYYY-mm-dd format\n const today = new Date().toISOString().split('T')[0];\n \n // Clean the subject for use as filename (remove special characters)\n const cleanSubject = emailData.subject\n .replace(/[^a-zA-Z0-9\\s-]/g, '') // Remove special characters except spaces and hyphens\n .replace(/\\s+/g, '-') // Replace spaces with hyphens\n .toLowerCase()\n .substring(0, 50); // Limit length\n \n if (emailData.attachments.length === 0) {\n console.log(\"No attachments found in email\");\n return;\n }\n\n const dropboxToken = Deno.env.get('DROPBOX_ACCESS_TOKEN');\n if (!dropboxToken) {\n throw new Error('DROPBOX_ACCESS_TOKEN environment variable is required');\n }\n\n // Determine upload path based on email sender\n let uploadPath: string;\n if (emailData.from === Deno.env.get(\"SENDER_EMAIL_INVESTMENT\")) {\n uploadPath = Deno.env.get(\"DROPBOX_PATH_INVESTMENT\");\n } else {\n uploadPath = Deno.env.get(\"DROPBOX_PATH_EXPENSES\");\n }\n\n const results = [];\n\n for (const attachment of emailData.attachments) {\n try {\n // Create filename with date and subject\n console.log(\"attachment.filename\", attachment.filename);\n const fileExtension = attachment.filename.split('.').pop() || '';\n const baseName = attachment.filename.split('.')[0] || 'attachment';\n const fileName = `${today}-${cleanSubject}-${baseName}.${fileExtension}`;\n \n // Upload to Dropbox with specific path\n const uploadResult = await uploadToDropbox(\n dropboxToken,\n uploadPath,\n fileName,\n attachment.data,\n attachment.contentType\n );\n \n results.push({\n originalName: attachment.filename,\n uploadedName: fileName,\n dropboxPath: uploadResult.path_display,\n success: true\n });\n \n console.log(`Successfully uploaded: ${attachment.filename} -> ${uploadPath}/${fileName}`);\n \n } catch (error) {\n console.error(`Failed to upload ${attachment.filename}:`, error);\n results.push({\n originalName: attachment.filename,\n success: false,\n error: error.message\n });\n }\n }\n\n // Send confirmation email\n const successCount = results.filter(r => r.success).length;\n const failureCount = results.filter(r => !r.success).length;\n \n let emailBody = `Email processed on ${today}\\n\\n`;\n emailBody += `Subject: ${emailData.subject}\\n`;\n emailBody += `From: ${emailData.from}\\n`;\n emailBody += `Upload Path: ${uploadPath}\\n\\n`;\n \n if (successCount > 0) {\n emailBody += `✅ Successfully uploaded ${successCount} attachment(s):\\n`;\n results.filter(r => r.success).forEach(result => {\n emailBody += ` - ${result.originalName} -> ${result.uploadedName}\\n`;\n emailBody += ` Dropbox path: ${result.dropboxPath}\\n`;\n });\n emailBody += '\\n';\n }\n \n if (failureCount > 0) {\n emailBody += `❌ Failed to upload ${failureCount} attachment(s):\\n`;\n results.filter(r => !r.success).forEach(result => {\n emailBody += ` - ${result.originalName}: ${result.error}\\n`;\n });\n }\n\n await email({\n subject: `Email Attachment Processing - ${today}`,\n text: emailBody,\n html: emailBody.replace(/\\n/g, '
')\n });\n\n } catch (error) {\n console.error('Error processing email:', error);\n \n // Send error notification\n await email({\n subject: 'Email Attachment Processing Error',\n text: `Error processing email attachments: ${error.message}`,\n html: `

Error processing email attachments: ${error.message}

`\n });\n \n throw error;\n }\n}\n\nasync function uploadToDropbox(\n accessToken: string,\n folderPath: string,\n fileName: string,\n fileData: string,\n contentType: string\n): Promise {\n const url = 'https://content.dropboxapi.com/2/files/upload';\n \n // Decode base64 data\n const binaryData = Uint8Array.from(atob(fileData), c => c.charCodeAt(0));\n \n // Create full path including folder\n const fullPath = `/${folderPath}/${fileName}`;\n \n const headers = {\n 'Authorization': `Bearer ${accessToken}`,\n 'Content-Type': 'application/octet-stream',\n 'Dropbox-API-Arg': JSON.stringify({\n path: fullPath,\n mode: 'add',\n autorename: true,\n mute: false,\n strict_conflict: false\n })\n };\n\n const response = await fetch(url, {\n method: 'POST',\n headers,\n body: binaryData\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`Dropbox upload failed: ${response.status} ${response.statusText} - ${errorText}`);\n }\n\n return await response.json();\n} ",2,["D",1750548329607],{"_108":268,"_155":139,"_152":189,"_100":104,"_163":269,"_161":192,"_105":182,"_154":-5,"_110":270,"_156":256,"_166":-5},"175dde16-4ef6-11f0-9ea1-f69ea79377d9","import { email } from \"https://esm.town/v/std/email\";\n\ninterface EmailAttachment {\n filename: string;\n contentType: string;\n data: string; // base64 encoded data\n}\n\ninterface Email {\n from: string;\n to: string;\n subject: string;\n text: string;\n html: string;\n attachments: EmailAttachment[];\n}\n\ninterface DropboxUploadResponse {\n id: string;\n name: string;\n path_display: string;\n size: number;\n}\n\nexport default async function (emailData: Email) {\n try {\n // Get current date in YYYY-mm-dd format\n const today = new Date().toISOString().split('T')[0];\n \n // Clean the subject for use as filename (remove special characters)\n const cleanSubject = emailData.subject\n .replace(/[^a-zA-Z0-9\\s-]/g, '') // Remove special characters except spaces and hyphens\n .replace(/\\s+/g, '-') // Replace spaces with hyphens\n .toLowerCase()\n .substring(0, 50); // Limit length\n \n if (emailData.attachments.length === 0) {\n console.log(\"No attachments found in email\");\n return;\n }\n\n const dropboxToken = Deno.env.get('DROPBOX_ACCESS_TOKEN');\n if (!dropboxToken) {\n throw new Error('DROPBOX_ACCESS_TOKEN environment variable is required');\n }\n\n // Determine upload path based on email sender\n let uploadPath: string;\n if (emailData.from === Deno.env.get(\"SENDER_EMAIL_INVESTMENT\")) {\n uploadPath = Deno.env.get(\"DROPBOX_PATH_INVESTMENT\");\n } else {\n uploadPath = Deno.env.get(\"DROPBOX_PATH_EXPENSES\");\n }\n\n const results = [];\n\n for (const attachment of emailData.attachments) {\n try {\n // Create filename with date and subject\n const fileExtension = attachment.filename.split('.').pop() || '';\n const baseName = attachment.filename.split('.')[0] || 'attachment';\n const fileName = `${today}-${cleanSubject}-${baseName}.${fileExtension}`;\n \n // Upload to Dropbox with specific path\n const uploadResult = await uploadToDropbox(\n dropboxToken,\n uploadPath,\n fileName,\n attachment.data,\n attachment.contentType\n );\n \n results.push({\n originalName: attachment.filename,\n uploadedName: fileName,\n dropboxPath: uploadResult.path_display,\n success: true\n });\n \n console.log(`Successfully uploaded: ${attachment.filename} -> ${uploadPath}/${fileName}`);\n \n } catch (error) {\n console.error(`Failed to upload ${attachment.filename}:`, error);\n results.push({\n originalName: attachment.filename,\n success: false,\n error: error.message\n });\n }\n }\n\n // Send confirmation email\n const successCount = results.filter(r => r.success).length;\n const failureCount = results.filter(r => !r.success).length;\n \n let emailBody = `Email processed on ${today}\\n\\n`;\n emailBody += `Subject: ${emailData.subject}\\n`;\n emailBody += `From: ${emailData.from}\\n`;\n emailBody += `Upload Path: ${uploadPath}\\n\\n`;\n \n if (successCount > 0) {\n emailBody += `✅ Successfully uploaded ${successCount} attachment(s):\\n`;\n results.filter(r => r.success).forEach(result => {\n emailBody += ` - ${result.originalName} -> ${result.uploadedName}\\n`;\n emailBody += ` Dropbox path: ${result.dropboxPath}\\n`;\n });\n emailBody += '\\n';\n }\n \n if (failureCount > 0) {\n emailBody += `❌ Failed to upload ${failureCount} attachment(s):\\n`;\n results.filter(r => !r.success).forEach(result => {\n emailBody += ` - ${result.originalName}: ${result.error}\\n`;\n });\n }\n\n await email({\n subject: `Email Attachment Processing - ${today}`,\n text: emailBody,\n html: emailBody.replace(/\\n/g, '
')\n });\n\n } catch (error) {\n console.error('Error processing email:', error);\n \n // Send error notification\n await email({\n subject: 'Email Attachment Processing Error',\n text: `Error processing email attachments: ${error.message}`,\n html: `

Error processing email attachments: ${error.message}

History for handler.ts