[{"_1":2,"_233":-5,"_234":-5},"loaderData",{"_3":4,"_91":92,"_207":208},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":22,"_29":22,"_30":22,"_31":32,"_33":22},"auth",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"tokenType","session_token","sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","ENV",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","1681543666622bf82800567d49e717e71c06d8ec","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","API_URL","https://api.val.town","clerkState",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":22,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":22,"_90":22},"__clerk_ssr_state",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_81":22,"_21":22,"_82":72,"_83":84,"_85":72,"_86":45,"_87":22,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_93":94,"_95":96,"_97":-7,"_98":72,"_99":-7,"_100":101,"_146":147,"_179":180,"_181":182,"_192":193,"_200":-5,"_201":-5,"_202":-5,"_203":22,"_204":22,"_205":206},"handle","arequipe","name","SantaFedeGuanajuato","branchName","path","version","project",{"_102":103,"_95":96,"_104":105,"_106":-5,"_107":22,"_108":109,"_110":-5,"_111":-5,"_14":112,"_113":-5,"_114":22,"_115":-5,"_116":32,"_16":117,"_118":119,"_120":119,"_121":122,"_123":122,"_124":122,"_125":119,"_126":119,"_23":127,"_130":131,"_133":134,"_145":22},"id","4a90b2c6-70b7-11f0-8c4f-0224a6c84d84","createdAt",["D",1754259298075],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","b45123f0-3406-11f0-994d-f304847156a7","pinnedFileId","pinPreview","screenshotVersion","likeCount","a7d312c4-47a4-45c8-b4c3-e46228d5db68","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_128":129},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4SEUwMzRLMGRyUDM0ZTVuazBHR1Jaa3g3VyJ9","org",{"_93":94,"_132":129},"avatar","branch",{"_99":135,"_95":43,"_102":136,"_137":103,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":96,"_144":94},159,"4a911a90-70b7-11f0-8c4f-0224a6c84d84","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","tree",[148,169],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":135,"_156":157,"_104":158,"_99":159,"_160":161,"_162":163,"_164":22,"_165":-5,"_166":167,"_98":168},"6b42c0d8-9a90-11f0-aa2d-0224a6c84d84","XML_CSV","fileId","937f9b10-9a8c-11f0-af57-0224a6c84d84","parentId","branchId","branchVersion","latest",true,["D",1758860551385],11,"fileType","http","content","import { fetch } from \"https://esm.town/v/std/fetch\";\nimport { parseStringPromise } from \"npm:xml2js\";\n\nexport default async function generateXMLCsv(req: Request): Promise {\n const AIRTABLE_API_KEY = Deno.env.get(\"AIRTABLE_API_KEY\")!;\n const AIRTABLE_BASE_ID = \"appPEkGGXqiMWmpB5\";\n const AIRTABLE_TABLE_ID = \"tbluae26QBVM79lNO\";\n\n const airtableHeaders = {\n Authorization: `Bearer ${AIRTABLE_API_KEY}`,\n \"Content-Type\": \"application/json\",\n };\n\n const fetchRecord = async (recordId: string) => {\n const res = await fetch(\n `https://api.airtable.com/v0/${AIRTABLE_BASE_ID}/${AIRTABLE_TABLE_ID}/${recordId}`,\n { headers: airtableHeaders }\n );\n if (!res.ok) throw new Error(`Airtable fetch failed: ${await res.text()}`);\n return (await res.json()).fields;\n };\n\n const updateAirtableFields = async (recordId: string, fields: Record) => {\n const res = await fetch(\n `https://api.airtable.com/v0/${AIRTABLE_BASE_ID}/${AIRTABLE_TABLE_ID}/${recordId}`,\n {\n method: \"PATCH\",\n headers: airtableHeaders,\n body: JSON.stringify({ fields }),\n }\n );\n if (!res.ok) throw new Error(`Airtable update failed: ${await res.text()}`);\n return res.json();\n };\n\n const flattenXmlJson = (obj: any, path = \"\"): [string, string][] => {\n const rows: [string, string][] = [];\n if (typeof obj === \"string\" || typeof obj === \"number\" || typeof obj === \"boolean\") {\n rows.push([path, String(obj)]);\n return rows;\n }\n if (Array.isArray(obj)) {\n obj.forEach((item, i) => {\n rows.push(...flattenXmlJson(item, `${path}[${i}]`));\n });\n } else if (typeof obj === \"object\" && obj !== null) {\n for (const key in obj) {\n rows.push(...flattenXmlJson(obj[key], path ? `${path}/${key}` : key));\n }\n }\n return rows;\n };\n\n const uploadCsvToTransferSh = async (csvContent: string, filename: string): Promise => {\n const res = await fetch(`https://transfer.sh/${filename}`, {\n method: \"PUT\",\n body: csvContent,\n headers: {\n \"Content-Type\": \"text/csv\",\n },\n });\n if (!res.ok) throw new Error(`Failed to upload CSV to transfer.sh: ${await res.text()}`);\n return await res.text(); // Returns the public URL\n };\n\n const uploadCsvToFileIo = async (csvContent: string, filename: string): Promise => {\n try {\n const formData = new FormData();\n formData.append(\"file\", new Blob([csvContent], { type: \"text/csv\" }), filename);\n\n const res = await fetch(\"https://file.io/\", {\n method: \"POST\",\n body: formData,\n });\n if (!res.ok) {\n const errorText = await res.text();\n throw new Error(`Failed to upload CSV to file.io: ${errorText}`);\n }\n const result = await res.json();\n if (!result.link) throw new Error(\"No link returned from file.io\");\n return result.link;\n } catch (err) {\n console.error(\"file.io upload failed, falling back to transfer.sh:\", err);\n return uploadCsvToTransferSh(csvContent, filename);\n }\n };\n\n try {\n const recordId = new URL(req.url).searchParams.get(\"recordId\");\n if (!recordId) {\n return new Response(JSON.stringify({ error: \"Missing recordId\" }), { status: 400 });\n }\n\n const record = await fetchRecord(recordId);\n const xmlFiles = record.XML;\n if (!xmlFiles || xmlFiles.length === 0) {\n return new Response(JSON.stringify({ error: \"No XML file found\" }), { status: 400 });\n }\n const xmlUrl = xmlFiles[0].url;\n\n const xmlRes = await fetch(xmlUrl);\n if (!xmlRes.ok) throw new Error(`Failed to fetch XML: ${await xmlRes.text()}`);\n const xmlText = await xmlRes.text();\n\n const xmlObj = await parseStringPromise(xmlText);\n const flattened = flattenXmlJson(xmlObj);\n\n const csvRows = [\"Path,Value\"];\n for (const [path, value] of flattened) {\n const safeValue = `\"${value.replace(/\"/g, '\"\"')}\"`;\n csvRows.push(`${path},${safeValue}`);\n }\n const csvContent = csvRows.join(\"\\n\");\n const filename = `xml_${recordId}.csv`;\n\n // Upload CSV to file.io, fallback to transfer.sh if it fails\n const csvUrl = await uploadCsvToFileIo(csvContent, filename);\n\n // Update Airtable with the CSV attachment\n await updateAirtableFields(recordId, {\n flds8NbnkEOyZWgKR: [{ url: csvUrl, filename }],\n });\n\n return new Response(\n JSON.stringify({\n success: true,\n message: `XML converted to CSV and uploaded for record ${recordId}`,\n }),\n { status: 200 }\n );\n } catch (err: any) {\n console.error(err);\n return new Response(JSON.stringify({ error: err.message }), { status: 500 });\n }\n}import { fetch } from \"https://esm.town/v/std/fetch\";\nimport { parseStringPromise } from \"npm:xml2js\";\n\nexport default async function generateXMLCsv(req: Request): Promise {\n const AIRTABLE_API_KEY = Deno.env.get(\"AIRTABLE_API_KEY\")!;\n const AIRTABLE_BASE_ID = \"appPEkGGXqiMWmpB5\";\n const AIRTABLE_TABLE_ID = \"tbluae26QBVM79lNO\";\n\n const airtableHeaders = {\n Authorization: `Bearer ${AIRTABLE_API_KEY}`,\n \"Content-Type\": \"application/json\",\n };\n\n const fetchRecord = async (recordId: string) => {\n const res = await fetch(\n `https://api.airtable.com/v0/${AIRTABLE_BASE_ID}/${AIRTABLE_TABLE_ID}/${recordId}`,\n { headers: airtableHeaders }\n );\n if (!res.ok) throw new Error(`Airtable fetch failed: ${await res.text()}`);\n return (await res.json()).fields;\n };\n\n const updateAirtableFields = async (recordId: string, fields: Record) => {\n const res = await fetch(\n `https://api.airtable.com/v0/${AIRTABLE_BASE_ID}/${AIRTABLE_TABLE_ID}/${recordId}`,\n {\n method: \"PATCH\",\n headers: airtableHeaders,\n body: JSON.stringify({ fields }),\n }\n );\n if (!res.ok) throw new Error(`Airtable update failed: ${await res.text()}`);\n return res.json();\n };\n\n const flattenXmlJson = (obj: any, path = \"\"): [string, string][] => {\n const rows: [string, string][] = [];\n if (typeof obj === \"string\" || typeof obj === \"number\" || typeof obj === \"boolean\") {\n rows.push([path, String(obj)]);\n return rows;\n }\n if (Array.isArray(obj)) {\n obj.forEach((item, i) => {\n rows.push(...flattenXmlJson(item, `${path}[${i}]`));\n });\n } else if (typeof obj === \"object\" && obj !== null) {\n for (const key in obj) {\n rows.push(...flattenXmlJson(obj[key], path ? `${path}/${key}` : key));\n }\n }\n return rows;\n };\n\n const uploadCsvToTransferSh = async (csvContent: string, filename: string): Promise => {\n const res = await fetch(`https://transfer.sh/${filename}`, {\n method: \"PUT\",\n body: csvContent,\n headers: {\n \"Content-Type\": \"text/csv\",\n },\n });\n if (!res.ok) throw new Error(`Failed to upload CSV to transfer.sh: ${await res.text()}`);\n return await res.text(); // Returns the public URL\n };\n\n const uploadCsvToFileIo = async (csvContent: string, filename: string): Promise => {\n try {\n const formData = new FormData();\n formData.append(\"file\", new Blob([csvContent], { type: \"text/csv\" }), filename);\n\n const res = await fetch(\"https://file.io/\", {\n method: \"POST\",\n body: formData,\n });\n if (!res.ok) {\n const errorText = await res.text();\n throw new Error(`Failed to upload CSV to file.io: ${errorText}`);\n }\n const result = await res.json();\n if (!result.link) throw new Error(\"No link returned from file.io\");\n return result.link;\n } catch (err) {\n console.error(\"file.io upload failed, falling back to transfer.sh:\", err);\n return uploadCsvToTransferSh(csvContent, filename);\n }\n };\n\n try {\n const recordId = new URL(req.url).searchParams.get(\"recordId\");\n if (!recordId) {\n return new Response(JSON.stringify({ error: \"Missing recordId\" }), { status: 400 });\n }\n\n const record = await fetchRecord(recordId);\n const xmlFiles = record.XML;\n if (!xmlFiles || xmlFiles.length === 0) {\n return new Response(JSON.stringify({ error: \"No XML file found\" }), { status: 400 });\n }\n const xmlUrl = xmlFiles[0].url;\n\n const xmlRes = await fetch(xmlUrl);\n if (!xmlRes.ok) throw new Error(`Failed to fetch XML: ${await xmlRes.text()}`);\n const xmlText = await xmlRes.text();\n\n const xmlObj = await parseStringPromise(xmlText);\n const flattened = flattenXmlJson(xmlObj);\n\n const csvRows = [\"Path,Value\"];\n for (const [path, value] of flattened) {\n const safeValue = `\"${value.replace(/\"/g, '\"\"')}\"`;\n csvRows.push(`${path},${safeValue}`);\n }\n const csvContent = csvRows.join(\"\\n\");\n const filename = `xml_${recordId}.csv`;\n\n // Upload CSV to file.io, fallback to transfer.sh if it fails\n const csvUrl = await uploadCsvToFileIo(csvContent, filename);\n\n // Update Airtable with the CSV attachment\n await updateAirtableFields(recordId, {\n flds8NbnkEOyZWgKR: [{ url: csvUrl, filename }],\n });\n\n return new Response(\n JSON.stringify({\n success: true,\n message: `XML converted to CSV and uploaded for record ${recordId}`,\n }),\n { status: 200 }\n );\n } catch (err: any) {\n console.error(err);\n return new Response(JSON.stringify({ error: err.message }), { status: 500 });\n }\n}","deleted","label","children",[],[150],{"_102":170,"_95":171,"_151":172,"_153":-5,"_154":136,"_155":173,"_156":157,"_104":174,"_99":175,"_160":161,"_162":176,"_164":22,"_165":-5,"_166":177,"_98":178},"f2fe1762-73b6-11f0-a34d-0224a6c84d84","main.tsx","4a938550-70b7-11f0-8c4f-0224a6c84d84",147,["D",1754589004634],143,"import { blob } from \"https://esm.town/v/std/blob\";\nimport { fetch } from \"https://esm.town/v/std/fetch\";\n\nexport default async function generateCartaPorteCFDI(req: Request): Promise {\n // Environment variables (ensure these are set in your Val Town environment)\n const AIRTABLE_API_KEY = Deno.env.get(\"AIRTABLE_API_KEY\")!;\n const AIRTABLE_BASE_ID = Deno.env.get(\"AIRTABLE_BASE_ID\")!;\n const FACTURAMA_AUTH = Deno.env.get(\"FACTURAMA_AUTH\")!;\n const CLOUDINARY_UPLOAD_PRESET = Deno.env.get(\"CLOUDINARY_UPLOAD_PRESET\")!;\n const CLOUDINARY_CLOUD_NAME = Deno.env.get(\"CLOUDINARY_CLOUD_NAME\")!;\n\n // Validate environment variables\n if (!CLOUDINARY_CLOUD_NAME || CLOUDINARY_CLOUD_NAME.trim() === \"\") {\n return new Response(\n JSON.stringify({ error: \"CLOUDINARY_CLOUD_NAME not configured in Val Town environment variables.\" }),\n { status: 400 },\n );\n }\n if (!CLOUDINARY_UPLOAD_PRESET || CLOUDINARY_UPLOAD_PRESET.trim() === \"\") {\n return new Response(\n JSON.stringify({ error: \"CLOUDINARY_UPLOAD_PRESET not configured in Val Town environment variables.\" }),\n { status: 400 },\n );\n }\n\n // Updated table names to match baseschema_safeg107.json\n const VIAJES_TABLE = \"Viajes3\";\n const CLIENTES_TABLE = \"Clientes3\";\n const UBICACIONES_TABLE = \"Ubicaciones3\";\n const UNIDADES_TABLE = \"Unidades3\";\n const BIENES_TABLE = \"Bienes3\";\n const OPERADORES_TABLE = \"Operadores3\";\n const REMOLQUES_TABLE = \"Remolques3\";\n\n const BLOB_NAME_PREFIX = \"sat_json_\";\n\n // Extract recordId from request\n let recordId: string | null = null;\n try {\n const body = await req.json();\n recordId = body.recordId || new URL(req.url).searchParams.get(\"recordId\");\n } catch (e) {\n recordId = new URL(req.url).searchParams.get(\"recordId\");\n }\n\n if (!recordId) {\n return new Response(\n JSON.stringify({ error: \"Missing recordId in request body or query parameters\" }),\n { status: 400 },\n );\n }\n\n // Airtable API headers\n const airtableHeaders = {\n Authorization: `Bearer ${AIRTABLE_API_KEY}`,\n \"Content-Type\": \"application/json\",\n };\n\n // Helper function to fetch a single record from Airtable\n const fetchRecord = async (tableId: string, id: string) => {\n const res = await fetch(`https://api.airtable.com/v0/${AIRTABLE_BASE_ID}/${tableId}/${id}`, {\n headers: airtableHeaders,\n });\n if (!res.ok) throw new Error(`Airtable fetch failed for ${tableId}/${id}: ${await res.text()}`);\n return (await res.json()).fields;\n };\n\n // Helper function to fetch multiple linked records\n const fetchMultipleLinkedRecords = async (tableId: string, recordIds: string[]) => {\n if (!recordIds || recordIds.length === 0) return [];\n return Promise.all(recordIds.map(id => fetchRecord(tableId, id)));\n };\n\n // Helper function to upload files to Cloudinary\n const uploadToCloudinary = async (base64: string, filename: string, mime: string): Promise => {\n const form = new FormData();\n form.append(\"file\", `data:${mime};base64,${base64}`);\n form.append(\"upload_preset\", CLOUDINARY_UPLOAD_PRESET);\n const res = await fetch(`https://api.cloudinary.com/v1_1/${CLOUDINARY_CLOUD_NAME}/upload`, {\n method: \"POST\",\n body: form,\n });\n if (!res.ok) throw new Error(`Cloudinary upload failed: ${await res.text()}`);\n return (await res.json()).secure_url;\n };\n\n // Helper function to update Airtable fields\n const updateAirtableFields = async (tableId: string, id: string, fields: Record) => {\n const res = await fetch(`https://api.airtable.com/v0/${AIRTABLE_BASE_ID}/${tableId}/${id}`, {\n method: \"PATCH\",\n headers: airtableHeaders,\n body: JSON.stringify({ fields }),\n });\n if (!res.ok) throw new Error(`Airtable update failed for ${tableId}/${id}: ${await res.text()}`);\n };\n\n // Helper function to fetch CFDI files from Facturama\n const fetchFromFacturama = async (id: string, type: \"xml\" | \"pdf\") => {\n const url = `https://apisandbox.facturama.mx/api/Cfdi/${type}/issued/${id}`;\n const res = await fetch(url, { headers: { Authorization: FACTURAMA_AUTH, \"User-Agent\": \"Arequipe\" } });\n if (!res.ok) throw new Error(`Facturama ${type.toUpperCase()} fetch failed: ${await res.text()}`);\n return JSON.parse(await res.text())?.Content;\n };\n\n // Helper function to format dates\n const formatDate = (dateStr: string | undefined): string => {\n const date = dateStr ? new Date(dateStr) : new Date();\n return `${date.getFullYear()}-${String(date.getMonth() + 1).padStart(2, \"0\")}-${\n String(date.getDate()).padStart(\n 2,\n \"0\",\n )\n }T${String(date.getHours()).padStart(2, \"0\")}:${String(date.getMinutes()).padStart(2, \"0\")}:${\n String(\n date.getSeconds(),\n ).padStart(2, \"0\")\n }`;\n };\n\n // Helper function to get string values with defaults\n const getStringValue = (airtableValue: any, satDefault?: string): string => {\n return airtableValue !== undefined && airtableValue !== null ? String(airtableValue) : satDefault || \"\";\n };\n\n // Helper function to generate padded location IDs\n const generatePaddedUbicacionId = (prefix: string, baseId?: string): string => {\n let numId = baseId ? parseInt(baseId, 10) || 0 : 0;\n if (numId === 0) numId = Math.floor(100000 + Math.random() * 900000);\n return `${prefix}${String(numId).padStart(6, \"0\")}`;\n };\n\n // Helper function to extract Via code\n const getViaCode = (via: string) => {\n if (via) {\n const match = via.match(/^(\\d{2})/);\n return match ? match[1] : \"01\";\n }\n return \"01\";\n };\n\n // Helper function to extract Regimen code\n const getRegimenCode = (regimen: string) => {\n if (regimen) {\n const match = regimen.match(/^([A-Z]{3})/);\n return match ? match[1] : \"IMD\";\n }\n return \"IMD\";\n };\n\n // Helper function to pad numbers with leading zeros\n const padNumberToLength = (num: any, length: number): string => {\n if (num === null || num === undefined) return \"\";\n return String(num).padStart(length, \"0\");\n };\n\n // Helper function to find catalog key by name or key\n const findCatalogKey = (name: any, catalog: any[], keyField: string, nameField: string): string => {\n let searchName = name;\n if (Array.isArray(searchName) && searchName.length > 0) {\n searchName = searchName[0]; // Take the first element if it's an array\n }\n searchName = String(searchName || \"\").toLowerCase().trim();\n\n // Try to extract numeric code if format is \"XX-Description\"\n let potentialCode = searchName;\n const codeMatch = searchName.match(/^(\\d{2,3})-/); // Matches \"01-\" or \"14-\" etc.\n if (codeMatch && codeCodeMatch[1]) {\n potentialCode = codeMatch[1];\n console.log(`DEBUG: Extracted potential code '${potentialCode}' from searchName '${searchName}'.`);\n }\n\n console.log(\n `Searching for '${searchName}' (or code '${potentialCode}') in catalog (keyField: ${keyField}, nameField: ${nameField}). Catalog size: ${catalog.length}`,\n );\n let found = catalog.find(item => {\n const itemName = String(item[nameField] || \"\").toLowerCase().trim();\n const itemKey = String(item[keyField] || \"\").toLowerCase().trim();\n\n // Try matching by name field directly\n if (itemName === searchName) return true;\n // Try matching by key field directly\n if (itemKey === searchName) return true;\n // Try matching by extracted code if available\n if (potentialCode && (itemName === potentialCode || itemKey === potentialCode)) return true;\n\n return false;\n });\n\n // Attempt to find by parsing as integer if keyField is numeric and searchName can be parsed\n if (!found && !isNaN(Number(searchName))) {\n const searchNum = Number(searchName);\n found = catalog.find(item => {\n const itemKeyNum = Number(item[keyField]);\n return !isNaN(itemKeyNum) && itemKeyNum === searchNum;\n });\n }\n // Also try with potentialCode if it's numeric\n if (!found && potentialCode && !isNaN(Number(potentialCode))) {\n const searchNum = Number(potentialCode);\n found = catalog.find(item => {\n const itemKeyNum = Number(item[keyField]);\n return !isNaN(itemKeyNum) && itemKeyNum === searchNum;\n });\n }\n\n if (!found) {\n console.log(` No match found for '${searchName}' (or code '${potentialCode}') in catalog.`);\n }\n return found ? String(found[keyField]) : \"\"; // Ensure the key is returned as a string\n };\n\n // Validation variables\n let validationMessages: string[] = [];\n let allValid = true;\n\n // Helper function to fetch catalog data from Val Town blobs\n const getCatalogData = async (tableName: string) => {\n const data = await blob.getJSON(BLOB_NAME_PREFIX + tableName);\n if (!data) throw new Error(`Catalog '${tableName}' not found or empty in Val Town blobs.`);\n return data;\n };\n\n // Catalog variables\n let cfdi40CodigosPostales: any[] = [];\n let cfdi40Municipios: any[] = [];\n let cfdi40Estados: any[] = [];\n let cfdi40Colonias: any[] = [];\n let cfdi40Localidades: any[] = [];\n let cfdi40RegimenesFiscales: any[] = [];\n let cfdi40UsosCfdi: any[] = [];\n let ccp31ProductosServicios: any[] = [];\n let ccp31ClavesUnidades: any[] = [];\n let ccp31TiposPermiso: any[] = [];\n let ccp31ConfiguracionesAutotransporte: any[] = [];\n let ccp31TiposRemolque: any[] = [];\n let ccp31FigurasTransporte: any[] = [];\n let ccp31TiposMateria: any[] = [];\n let ccp31DocumentosAduaneros: any[] = [];\n\n try {\n console.log(`Starting Carta Porte process for Trip ID: ${recordId}`);\n\n // Fetch all catalog data concurrently\n [\n cfdi40CodigosPostales,\n cfdi40Municipios,\n cfdi40Estados,\n cfdi40Colonias,\n cfdi40Localidades,\n cfdi40RegimenesFiscales,\n cfdi40UsosCfdi,\n ccp31ProductosServicios,\n ccp31ClavesUnidades,\n ccp31TiposPermiso,\n ccp31ConfiguracionesAutotransporte,\n ccp31TiposRemolque,\n ccp31FigurasTransporte,\n ccp31TiposMateria,\n ccp31DocumentosAduaneros,\n ] = await Promise.all([\n getCatalogData(\"cfdi_40_codigos_postales\"),\n getCatalogData(\"cfdi_40_municipios\"),\n getCatalogData(\"cfdi_40_estados\"),\n getCatalogData(\"cfdi_40_colonias\"),\n getCatalogData(\"cfdi_40_localidades\"),\n getCatalogData(\"cfdi_40_regimenes_fiscales\"),\n getCatalogData(\"cfdi_40_usos_cfdi\"),\n getCatalogData(\"ccp_31_productos_servicios\"),\n getCatalogData(\"ccp_31_claves_unidades\"),\n getCatalogData(\"ccp_31_tipos_permiso\"),\n getCatalogData(\"ccp_31_configuraciones_autotransporte\"),\n getCatalogData(\"ccp_31_tipos_remolque\"),\n getCatalogData(\"ccp_31_figuras_transporte\"),\n getCatalogData(\"ccp_31_tipos_materia\"),\n getCatalogData(\"ccp_31_documentos_aduaneros\"),\n ]);\n\n // Fetch trip data for the given recordId\n const viajeData = await fetchRecord(VIAJES_TABLE, recordId);\n\n // Extract linked record IDs\n const emisorId = viajeData.Emisor?.[0];\n const clienteOrigenId = viajeData.ClienteOrigen?.[0];\n const clienteDestinoId = viajeData.ClienteDestino?.[0];\n const origenId = viajeData.Origen?.[0];\n const destinoId = viajeData.Destino?.[0];\n const unidadId = viajeData.Unidad?.[0];\n const operadorId = viajeData.Operador?.[0];\n const bienesIds = viajeData.Bienes || [];\n const remolqueIds = viajeData.Remolque || [];\n\n // Fetch all linked records concurrently\n const [emisor, clienteOrigen, clienteDestino, origen, destino, unidad, operador, remolques, bienes] = await Promise\n .all([\n emisorId ? fetchRecord(CLIENTES_TABLE, emisorId) : Promise.resolve(null),\n clienteOrigenId ? fetchRecord(CLIENTES_TABLE, clienteOrigenId) : Promise.resolve(null),\n clienteDestinoId ? fetchRecord(CLIENTES_TABLE, clienteDestinoId) : Promise.resolve(null),\n origenId ? fetchRecord(UBICACIONES_TABLE, origenId) : Promise.resolve(null),\n destinoId ? fetchRecord(UBICACIONES_TABLE, destinoId) : Promise.resolve(null),\n unidadId ? fetchRecord(UNIDADES_TABLE, unidadId) : Promise.resolve(null),\n operadorId ? fetchRecord(OPERADORES_TABLE, operadorId) : Promise.resolve(null),\n fetchMultipleLinkedRecords(REMOLQUES_TABLE, remolqueIds),\n fetchMultipleLinkedRecords(BIENES_TABLE, bienesIds),\n ]);\n\n // Validation checks for core data before Domicilio construction\n if (!unidad) {\n validationMessages.push(\"Unit: Could not load the Unit record.\");\n allValid = false;\n }\n if (!operador) {\n validationMessages.push(\"Operator: Could not load the Operator record.\");\n allValid = false;\n }\n if (bienes.length === 0) {\n validationMessages.push(\"Goods: No Goods found.\");\n allValid = false;\n }\n\n // Prepare CFDI data\n const facturaDate = formatDate(viajeData.Fecha);\n const folio = viajeData.Folio || `V-${Math.floor(Math.random() * 100000)}`;\n\n const serviceSubtotal = parseFloat(viajeData.Total || \"0.01\");\n const serviceIVA = parseFloat((serviceSubtotal * 0.16).toFixed(2));\n const serviceTotal = parseFloat((serviceSubtotal + serviceIVA).toFixed(2));\n\n const serviceItem = {\n ProductCode: \"78121603\", // Road transport service\n Description: \"Servicio de transporte por carretera\",\n UnitCode: \"E48\",\n Quantity: 1,\n UnitPrice: serviceSubtotal,\n Subtotal: serviceSubtotal,\n TaxObject: \"02\",\n Taxes: [{ Total: serviceIVA, Name: \"IVA\", Base: serviceSubtotal, Rate: 0.16, IsRetention: false }],\n Total: serviceTotal,\n };\n\n // Determine if TranspInternac should be forced to \"No\" due to TipoDocumento \"01\"\n let forceTranspInternacNo = false;\n for (const bien of bienes) {\n const docAduaneraType = findCatalogKey(bien.TipoDocumentoAduanero, ccp31DocumentosAduaneros, \"id\", \"description\")\n || \"01\";\n if (docAduaneraType === \"01\") {\n forceTranspInternacNo = true;\n console.log(`DEBUG: Found TipoDocumento '01' for a good. Forcing global TranspInternac to 'No' as a bypass.`);\n break; // No need to check other goods\n }\n }\n const finalTranspInternac = forceTranspInternacNo ? \"No\" : (viajeData.TranspInternac || \"No\");\n\n // Map goods (Mercancias)\n const mercanciasItems = bienes.map((bien) => {\n // Determine TipoMateria based on TranspInternac\n const tipoMateria = finalTranspInternac === \"Sí\" // Use finalTranspInternac here\n ? findCatalogKey(bien.TipoMateria || \"Mercancía\", ccp31TiposMateria, \"id\", \"description\") || \"01\" // Default to \"01\" (Mercancía) if not found\n : undefined; // Omit if not international transport\n\n // Determine DocumentacionAduanera only if finalTranspInternac is \"Sí\"\n let documentacionAduaneraObject: any | undefined;\n if (finalTranspInternac === \"Sí\") { // Only process if international transport is \"Sí\"\n console.log(`DEBUG: Raw Airtable TipoDocumentoAduanero for bien: '${bien.TipoDocumentoAduanero}'`);\n const docAduaneraType =\n findCatalogKey(bien.TipoDocumentoAduanero, ccp31DocumentosAduaneros, \"id\", \"description\") || \"01\"; // Default to \"01\" (Pedimento)\n console.log(`DEBUG: Determined docAduaneraType after lookup: '${docAduaneraType}'`);\n\n let docAduaneraNumPedimento = bien.NumPedimentoAduanero ? String(bien.NumPedimentoAduanero) : undefined;\n let docAduaneraRFCImpo = bien.RFCImpo; // Assuming RFCImpo exists in Bienes3 table\n\n if (docAduaneraType === \"01\") {\n // For TipoDocumento \"01\" (Pedimento), NumPedimento and IdentDocAduanero must be omitted.\n // Since we are now forcing TranspInternac to \"No\" globally if this type is found,\n // this block should ideally not be reached if the bypass works.\n // If it is reached, it means TranspInternac is \"Sí\" but TipoDocumento is \"01\",\n // which is the problematic scenario. We still omit the object.\n console.log(\n `DEBUG: TipoDocumento is '01' and TranspInternac is 'Sí'. Omitting DocumentacionAduanera object.`,\n );\n } else { // For TipoDocumento other than \"01\" (e.g., \"02\")\n documentacionAduaneraObject = {\n TipoDocumento: docAduaneraType,\n };\n\n // NumPedimento is expected to be present and valid for TipoDocumento \"02\"\n if (docAduaneraNumPedimento) {\n // Clean NumPedimentoAduanero: remove all non-digits\n const cleanedNumPedimento = docAduaneraNumPedimento.replace(/\\D/g, \"\");\n documentacionAduaneraObject.NumPedimento = cleanedNumPedimento;\n\n // Validate cleaned NumPedimento length (standard 15 digits for SAT pedimento)\n if (cleanedNumPedimento.length !== 15) {\n validationMessages.push(\n `Mercancía: NumPedimentoAduanero '${docAduaneraNumPedimento}' (limpio: '${cleanedNumPedimento}') para TipoDocumento '${docAduaneraType}' no tiene la longitud esperada de 15 dígitos. Longitud actual: ${cleanedNumPedimento.length}.`,\n );\n allValid = false;\n }\n // Facturama's error mentioned max 21, so also check if it exceeds that (after cleaning)\n if (cleanedNumPedimento.length > 21) {\n validationMessages.push(\n `Mercancía: NumPedimentoAduanero '${docAduaneraNumPedimento}' (limpio: '${cleanedNumPedimento}') para TipoDocumento '${docAduaneraType}' excede la longitud máxima de 21 dígitos permitida por Facturama.`,\n );\n allValid = false;\n }\n } else {\n // If TipoDocumento is \"02\" and NumPedimento is missing, it's a validation error.\n validationMessages.push(\n `Mercancía: NumPedimentoAduanero es requerido para TipoDocumento '${docAduaneraType}' cuando TranspInternac es 'Sí'.`,\n );\n allValid = false;\n }\n\n // IdentDocAduanero is also expected to be present for TipoDocumento \"02\" with NumPedimento.\n if (docAduaneraRFCImpo) {\n documentacionAduaneraObject.IdentDocAduanero = docAduaneraRFCImpo;\n } else if (docAduaneraNumPedimento) { // Only default RFCImpo if NumPedimento is present and RFCImpo is missing\n documentacionAduaneraObject.IdentDocAduanero = \"XEXX010101000\"; // Default to generic foreign RFC\n console.log(\n `DEBUG: RFCImpo was undefined for TipoDocumento '${docAduaneraType}' with NumPedimento. Defaulting IdentDocAduanero to '${documentacionAduaneraObject.IdentDocAduanero}'.`,\n );\n validationMessages.push(\n `Mercancía: RFCImpo (IdentDocAduanero) estaba vacío para TipoDocumento '${docAduaneraType}' con pedimento. Se usó el valor por defecto 'XEXX010101000'.`,\n );\n }\n }\n }\n const documentacionAduanera = documentacionAduaneraObject ? [documentacionAduaneraObject] : undefined;\n\n return {\n BienesTransp: bien.SAT_ClaveProdServP || \"15101505\",\n FraccionArancelaria: bien.FraccionArancelaria || \"\",\n Descripcion: bien.Descripcion || \"Mercancía sin descripción\",\n Cantidad: parseFloat(bien.Cantidad || \"0.000001\"),\n ClaveUnidad: bien.SAT_ClaveUnidadPeso || \"KGM\",\n Unidad: bien.Unidad || \"Kilogramo\",\n PesoEnKg: parseFloat(bien.PesoBruto || \"0.001\"),\n ValorMercancia: parseFloat(bien.Valor || \"0.01\"),\n Moneda: bien.Moneda || \"MXN\",\n MaterialPeligroso: getStringValue(bien.fldURUJnOYFe7Fsc5, \"No\"),\n ClaveMaterialPeligroso: bien.ClaveSTCC || \"\",\n PesoNeto: parseFloat(\"0\"),\n PesoBruto: parseFloat(\"0\"),\n PesoTara: parseFloat(\"0\"),\n ...(tipoMateria && { TipoMateria: tipoMateria }), // Conditionally add TipoMateria\n ...(documentacionAduanera && { DocumentacionAduanera: documentacionAduanera }), // Conditionally add DocumentacionAduanera\n };\n });\n\n // Ensure at least one good if none are provided\n if (mercanciasItems.length === 0) {\n mercanciasItems.push({\n BienesTransp: \"15101505\",\n FraccionArancelaria: \"\",\n Descripcion: \"Mercancía general\",\n Cantidad: 0.000001,\n ClaveUnidad: \"KGM\",\n Unidad: \"Kilogramo\",\n PesoEnKg: 0.001,\n ValorMercancia: 0.01,\n Moneda: \"MXN\",\n MaterialPeligroso: \"No\",\n ClaveMaterialPeligroso: \"\",\n PesoNeto: parseFloat(\"0\"),\n PesoBruto: parseFloat(\"0\"),\n PesoTara: parseFloat(\"0\"),\n ...(finalTranspInternac === \"Sí\" && { TipoMateria: \"01\" }), // Use finalTranspInternac here\n });\n }\n\n const pesoBrutoTotalMercancias = mercanciasItems.reduce((sum, item) => sum + item.PesoEnKg, 0) || 0.001;\n const totalDistRec = parseFloat(viajeData.TotalDistRec || \"100\");\n\n // Determine the issuer's ExpeditionPlace (your company's CP)\n const issuerExpeditionPlace = getStringValue(viajeData.ExpeditionPlace, \"76140\");\n console.log(`DEBUG: Issuer's ExpeditionPlace (your company's CP): '${issuerExpeditionPlace}'`);\n\n const receiverRfc = clienteDestino?.RFC || \"EKU9003173C9\";\n let finalReceiverTaxZipCode = getStringValue(clienteDestino?.TaxZipCode, \"42501\"); // Default for specific RFCs\n\n // If receiver is generic, their TaxZipCode MUST be the issuer's ExpeditionPlace\n if (receiverRfc === \"XAXX010101000\" || receiverRfc === \"XEXX010101000\") {\n finalReceiverTaxZipCode = issuerExpeditionPlace; // This is the SAT rule for generic RFCs\n console.log(\n `DEBUG: Receiver RFC is generic. Setting Receiver TaxZipCode to Issuer's ExpeditionPlace: '${finalReceiverTaxZipCode}'`,\n );\n } else {\n console.log(\n `DEBUG: Receiver RFC is specific. Using Receiver TaxZipCode from Airtable: '${finalReceiverTaxZipCode}'`,\n );\n }\n\n // Construct CFDI object\n const cfdi = {\n CfdiType: \"I\",\n NameId: \"36\",\n PaymentForm: viajeData.PaymentForm || \"99\", // Changed default to \"99\" as per common practice\n PaymentMethod: viajeData.PaymentMethod || \"PPD\",\n ExpeditionPlace: issuerExpeditionPlace, // Use the determined issuer's ExpeditionPlace\n Date: facturaDate,\n Folio: folio,\n Issuer: {\n Rfc: emisor?.RFC || \"XAXX010101000\",\n Name: emisor?.Nombre || \"Público en General\",\n FiscalRegime: emisor?.FiscalRegime || \"601\",\n },\n Receiver: {\n Rfc: receiverRfc,\n Name: clienteDestino?.Nombre || \"ESCUELA KEMPER URGATE\",\n CfdiUse: clienteDestino?.UsoCFDI || \"G03\",\n FiscalRegime: clienteDestino?.FiscalRegime || \"601\",\n TaxZipCode: finalReceiverTaxZipCode, // Use the determined finalReceiverTaxZipCode\n ...(clienteDestino?.ResidenciaFiscal && clienteDestino?.ResidenciaFiscal !== \"MEX\" && {\n ResidenciaFiscal: clienteDestino?.ResidenciaFiscal,\n NumRegIdTrib: clienteDestino?.NumRegIdTrib || \"XEXX010101000\", // Default or placeholder if not available\n }),\n },\n Items: [serviceItem],\n Complemento: {\n CartaPorte31: {\n Version: \"3.1\",\n TranspInternac: finalTranspInternac, // Use the determined finalTranspInternac\n TotalDistRec: totalDistRec,\n LogisticaInversaRecoleccionDevolucion: viajeData.LogisticaInversaRecoleccionDevolucion || \"No\",\n ...(finalTranspInternac === \"Sí\" && { // Only include if international transport is \"Sí\"\n EntradaSalidaMerc: viajeData.EntradaSalida || \"Entrada\",\n PaisOrigenDestino: viajeData.PaisOrigenDestino || \"USA\",\n ViaEntradaSalida: getViaCode(viajeData.Vía) || \"01\",\n RegimenesAduaneros: [\n {\n RegimenAduanero: getRegimenCode(viajeData[\"Régimen Aduanero\"]) || \"IMD\",\n },\n ],\n }),\n Ubicaciones: [\n {\n TipoUbicacion: \"Origen\",\n IDUbicacion: generatePaddedUbicacionId(\"OR\", origen?.ID),\n FechaHoraSalidaLlegada: formatDate(origen?.FechaHoraSalida || viajeData.FechaHoraSalida),\n RFCRemitenteDestinatario: origen?.RFC || \"XAXX010101000\",\n NombreRemitenteDestinatario: origen?.Nombre || \"ORIGEN DESCONOCIDO\",\n ...(origen?.ResidenciaFiscal && origen?.ResidenciaFiscal !== \"MEX\" && {\n ResidenciaFiscal: origen?.ResidenciaFiscal,\n NumRegIdTrib: origen?.NumRegIdTrib || \"\",\n }),\n Domicilio: (() => {\n const domicilioObj: any = {\n Calle: getStringValue(origen?.Calle),\n NumeroExterior: getStringValue(origen?.NumeroExterior, \"S/N\"),\n Pais: getStringValue(origen?.Pais, \"MEX\"),\n };\n\n // Use the country from Airtable to determine logic\n const airtablePaisOrigen = getStringValue(origen?.Pais, \"MEX\");\n\n if (airtablePaisOrigen === \"MEX\") {\n // For Mexican addresses\n const airtableEstado = origen?.[\"Estado Link\"];\n if (!airtableEstado) {\n validationMessages.push(`Origen: El campo 'Estado Link' está vacío o no es válido.`);\n allValid = false;\n }\n console.log(\n `DEBUG: Origen Domicilio (MEX) - Valor de Estado de Airtable (lookup): '${airtableEstado}', Tipo: ${typeof airtableEstado}`,\n );\n const estadoKey = findCatalogKey(airtableEstado, cfdi40Estados, \"estado\", \"texto\");\n console.log(\n `DEBUG: Origen Domicilio (MEX) - Resultado de findCatalogKey para Estado: '${estadoKey}'`,\n );\n if (!estadoKey && airtableEstado) {\n validationMessages.push(\n `Origen: Estado '${airtableEstado}' no válido o faltante en el catálogo SAT. Se esperaba la abreviatura (ej. 'TAM').`,\n );\n allValid = false;\n }\n domicilioObj.Estado = estadoKey;\n\n const airtableCP = origen?.[\"CP Link\"];\n if (!airtableCP) {\n validationMessages.push(`Origen: El campo 'CP Link' está vacío o no es válido.`);\n allValid = false;\n }\n const paddedCP = padNumberToLength(airtableCP, 5);\n console.log(\n `DEBUG: Origen Domicilio (MEX) - Valor de CodigoPostal de Airtable (lookup, padded): '${paddedCP}', Tipo: ${typeof paddedCP}`,\n );\n const cpKey = findCatalogKey(paddedCP, cfdi40CodigosPostales, \"id\", \"id\");\n console.log(\n `DEBUG: Origen Domicilio (MEX) - Resultado de findCatalogKey para CodigoPostal: '${cpKey}'`,\n );\n if (!cpKey && airtableCP) {\n validationMessages.push(\n `Origen: CodigoPostal '${airtableCP}' no válido o faltante en el catálogo SAT. Asegúrese de que sea un código postal válido.`,\n );\n allValid = false;\n }\n domicilioObj.CodigoPostal = cpKey;\n\n const airtableColonia = origen?.[\"Colonia Link\"];\n const paddedColonia = padNumberToLength(airtableColonia, 4);\n console.log(\n `DEBUG: Origen Domicilio (MEX) - Valor de Colonia de Airtable (lookup, padded): '${paddedColonia}', Tipo: ${typeof paddedColonia}`,\n );\n const coloniaKey = findCatalogKey(paddedColonia, cfdi40Colonias, \"c_Colonia\", \"c_Colonia\");\n console.log(\n `DEBUG: Origen Domicilio (MEX) - Resultado de findCatalogKey para Colonia: '${coloniaKey}'`,\n );\n // If not found in catalog, use padded Airtable value. If Airtable value is empty, use empty string.\n domicilioObj.Colonia = coloniaKey || paddedColonia;\n\n const airtableLocalidad = origen?.[\"Localidad Link\"];\n const paddedLocalidad = padNumberToLength(airtableLocalidad, 2);\n console.log(\n `DEBUG: Origen Domicilio (MEX) - Valor de Localidad de Airtable (lookup, padded): '${paddedLocalidad}', Tipo: ${typeof paddedLocalidad}`,\n );\n const localidadKey = findCatalogKey(paddedLocalidad, cfdi40Localidades, \"c_Localidad\", \"c_Localidad\");\n console.log(\n `DEBUG: Origen Domicilio (MEX) - Resultado de findCatalogKey para Localidad: '${localidadKey}'`,\n );\n // If not found in catalog, use padded Airtable value. If Airtable value is empty, use empty string.\n domicilioObj.Localidad = localidadKey || paddedLocalidad;\n\n const airtableMunicipio = origen?.[\"Municipio Link\"];\n const paddedMunicipio = padNumberToLength(airtableMunicipio, 3);\n console.log(\n `DEBUG: Origen Domicilio (MEX) - Valor de Municipio de Airtable (lookup, padded): '${paddedMunicipio}', Tipo: ${typeof paddedMunicipio}`,\n );\n const municipioKey = findCatalogKey(paddedMunicipio, cfdi40Municipios, \"c_Municipio\", \"c_Municipio\");\n console.log(\n `DEBUG: Origen Domicilio (MEX) - Resultado de findCatalogKey para Municipio: '${municipioKey}'`,\n );\n // If not found in catalog, use padded Airtable value. If Airtable value is empty, use empty string.\n domicilioObj.Municipio = municipioKey || paddedMunicipio;\n } else {\n // For non-Mexican addresses (e.g., USA), use values directly from Airtable\n console.log(\n `DEBUG: Origen Domicilio (Non-MEX) - Usando Estado '${origen?.[\"Estado Link\"]}' directamente.`,\n );\n domicilioObj.Estado = getStringValue(origen?.[\"Estado Link\"]);\n domicilioObj.CodigoPostal = getStringValue(origen?.[\"CP Link\"]);\n domicilioObj.Colonia = getStringValue(origen?.[\"Colonia Link\"]);\n domicilioObj.Localidad = getStringValue(origen?.[\"Localidad Link\"]);\n domicilioObj.Municipio = getStringValue(origen?.[\"Municipio Link\"]);\n }\n return domicilioObj;\n })(),\n },\n {\n TipoUbicacion: \"Destino\",\n IDUbicacion: generatePaddedUbicacionId(\"DE\", destino?.ID),\n FechaHoraSalidaLlegada: formatDate(destino?.FechaHoraLlegada || viajeData.FechaHoraLlegada),\n DistanciaRecorrida: totalDistRec,\n RFCRemitenteDestinatario: destino?.RFC || \"XAXX010101000\",\n NombreRemitenteDestinatario: destino?.Nombre || \"DESTINO DESCONOCIDO\",\n ...(destino?.ResidenciaFiscal && destino?.ResidenciaFiscal !== \"MEX\" && {\n ResidenciaFiscal: destino?.ResidenciaFiscal,\n NumRegIdTrib: destino?.NumRegIdTrib || \"\",\n }),\n Domicilio: (() => {\n const domicilioObj: any = {\n Calle: getStringValue(destino?.Calle),\n NumeroExterior: getStringValue(destino?.NumeroExterior, \"S/N\"),\n Pais: getStringValue(destino?.Pais, \"MEX\"),\n };\n\n // Use the country from Airtable to determine logic\n const airtablePaisDestino = getStringValue(destino?.Pais, \"MEX\");\n\n if (airtablePaisDestino === \"MEX\") {\n // For Mexican addresses\n const airtableEstado = destino?.[\"Estado Link\"];\n if (!airtableEstado) {\n validationMessages.push(`Destino: El campo 'Estado Link' está vacío o no es válido.`);\n allValid = false;\n }\n console.log(\n `DEBUG: Destino Domicilio (MEX) - Valor de Estado de Airtable (lookup): '${airtableEstado}', Tipo: ${typeof airtableEstado}`,\n );\n const estadoKey = findCatalogKey(airtableEstado, cfdi40Estados, \"estado\", \"texto\");\n console.log(\n `DEBUG: Destino Domicilio (MEX) - Resultado de findCatalogKey para Estado: '${estadoKey}'`,\n );\n if (!estadoKey && airtableEstado) {\n validationMessages.push(\n `Destino: Estado '${airtableEstado}' no válido o faltante en el catálogo SAT. Se esperaba la abreviatura (ej. 'TAM').`,\n );\n allValid = false;\n }\n domicilioObj.Estado = estadoKey;\n\n const airtableCP = destino?.[\"CP Link\"];\n if (!airtableCP) {\n validationMessages.push(`Destino: El campo 'CP Link' está vacío o no es válido.`);\n allValid = false;\n }\n const paddedCP = padNumberToLength(airtableCP, 5);\n console.log(\n `DEBUG: Destino Domicilio (MEX) - Valor de CodigoPostal de Airtable (lookup, padded): '${paddedCP}', Tipo: ${typeof paddedCP}`,\n );\n const cpKey = findCatalogKey(paddedCP, cfdi40CodigosPostales, \"id\", \"id\");\n console.log(\n `DEBUG: Destino Domicilio (MEX) - Resultado de findCatalogKey para CodigoPostal: '${cpKey}'`,\n );\n if (!cpKey && airtableCP) {\n validationMessages.push(\n `Destino: CodigoPostal '${airtableCP}' no válido o faltante en el catálogo SAT. Asegúrese de que sea un código postal válido.`,\n );\n allValid = false;\n }\n domicilioObj.CodigoPostal = cpKey;\n\n const airtableColonia = destino?.[\"Colonia Link\"];\n const paddedColonia = padNumberToLength(airtableColonia, 4);\n console.log(\n `DEBUG: Destino Domicilio (MEX) - Valor de Colonia de Airtable (lookup, padded): '${paddedColonia}', Tipo: ${typeof paddedColonia}`,\n );\n const coloniaKey = findCatalogKey(paddedColonia, cfdi40Colonias, \"c_Colonia\", \"c_Colonia\");\n console.log(\n `DEBUG: Destino Domicilio (MEX) - Resultado de findCatalogKey para Colonia: '${coloniaKey}'`,\n );\n // If not found in catalog, use padded Airtable value. If Airtable value is empty, use empty string.\n domicilioObj.Colonia = coloniaKey || paddedColonia;\n\n const airtableLocalidad = destino?.[\"Localidad Link\"];\n const paddedLocalidad = padNumberToLength(airtableLocalidad, 2);\n console.log(\n `DEBUG: Destino Domicilio (MEX) - Valor de Localidad de Airtable (lookup, padded): '${paddedLocalidad}', Tipo: ${typeof paddedLocalidad}`,\n );\n const localidadKey = findCatalogKey(paddedLocalidad, cfdi40Localidades, \"c_Localidad\", \"c_Localidad\");\n console.log(\n `DEBUG: Destino Domicilio (MEX) - Resultado de findCatalogKey para Localidad: '${localidadKey}'`,\n );\n // If not found in catalog, use padded Airtable value. If Airtable value is empty, use empty string.\n domicilioObj.Localidad = localidadKey || paddedLocalidad;\n\n const airtableMunicipio = destino?.[\"Municipio Link\"];\n const paddedMunicipio = padNumberToLength(airtableMunicipio, 3);\n console.log(\n `DEBUG: Destino Domicilio (MEX) - Valor de Municipio de Airtable (lookup, padded): '${paddedMunicipio}', Tipo: ${typeof paddedMunicipio}`,\n );\n const municipioKey = findCatalogKey(paddedMunicipio, cfdi40Municipios, \"c_Municipio\", \"c_Municipio\");\n console.log(\n `DEBUG: Destino Domicilio (MEX) - Resultado de findCatalogKey para Municipio: '${municipioKey}'`,\n );\n // If not found in catalog, use padded Airtable value. If Airtable value is empty, use empty string.\n domicilioObj.Municipio = municipioKey || paddedMunicipio;\n } else {\n // For non-Mexican addresses, use values directly from Airtable\n console.log(\n `DEBUG: Destino Domicilio (Non-MEX) - Usando Estado '${destino?.[\"Estado Link\"]}' directamente.`,\n );\n domicilioObj.Estado = getStringValue(destino?.[\"Estado Link\"]);\n domicilioObj.CodigoPostal = getStringValue(destino?.[\"CP Link\"]);\n domicilioObj.Colonia = getStringValue(destino?.[\"Colonia Link\"]);\n domicilioObj.Localidad = getStringValue(destino?.[\"Localidad Link\"]);\n domicilioObj.Municipio = getStringValue(destino?.[\"Municipio Link\"]);\n }\n return domicilioObj;\n })(),\n },\n ],\n Mercancias: {\n UnidadPeso: getStringValue(bienes[0]?.SAT_ClaveUnidadPeso, \"KGM\"),\n PesoBrutoTotal: parseFloat(pesoBrutoTotalMercancias.toFixed(3)),\n NumTotalMercancias: mercanciasItems.length,\n Mercancia: mercanciasItems,\n Autotransporte: {\n PermSCT: unidad?.PermisoSCT || \"TPAF03\",\n NumPermisoSCT: unidad?.NumPermisoSCT || \"TPXX123456789\",\n IdentificacionVehicular: {\n ConfigVehicular: unidad?.ConfigVehicular || \"T3S2\",\n PlacaVM: unidad?.Placa || \"0000000\",\n AnioModeloVM: parseInt(String(unidad?.AnioModelo) || \"2000\"),\n PesoBrutoVehicular: parseFloat(viajeData.PesoBrutoVehicular || \"0\"),\n },\n Seguros: {\n AseguraRespCivil: unidad?.[\"Seguro de la Unidad\"] || \"ASEGURADORA EJEMPLO RC\",\n PolizaRespCivil: unidad?.PolizaRespCivil || \"POLIZA123456\",\n AseguraCarga: viajeData.AseguraCarga || \"ASEGURADORA EJEMPLO CARGA\",\n PolizaCarga: viajeData.AseguraCarga || \"POLIZA987654\",\n ...(mercanciasItems.some((item) => item.MaterialPeligroso === \"Sí\") && {\n AseguraMedAmbiente: viajeData.AseguraMedAmbiente || \"ASEGURADORA EJEMPLO MA\",\n PolizaMedAmbiente: viajeData.PolizaMedAmbiente || \"POLIZA_MA_EJEMPLO\",\n }),\n },\n Remolques: remolques.map((rem) => ({\n SubTipoRem: rem.SubTipoRem || \"CTR004\",\n Placa: rem.Placa || \"SINPLACA\",\n })),\n },\n },\n FiguraTransporte: [\n {\n TipoFigura: operador?.TipoFigura || \"01\",\n RFCFigura: operador?.RFC || \"XAXX010101000\",\n NumLicencia: operador?.NumLicencia || \"NOLICENCIA\",\n NombreFigura: operador?.Nombre || \"OPERADOR DESCONOCIDO\",\n },\n ],\n },\n },\n };\n\n // Update Airtable with validation status before sending to Facturama\n await updateAirtableFields(VIAJES_TABLE, recordId, {\n \"SAT_Validation_Status\": allValid ? \"Valid\" : \"Invalid\",\n \"SAT_Validation_Messages\": validationMessages.join(\"\\n\") || \"No issues found.\",\n });\n\n if (!allValid) {\n return new Response(JSON.stringify({ success: false, messages: validationMessages }), { status: 400 });\n }\n\n // Send CFDI to Facturama\n const facturamaRes = await fetch(\"https://apisandbox.facturama.mx/3/cfdis\", {\n method: \"POST\",\n headers: { Authorization: FACTURAMA_AUTH, \"Content-Type\": \"application/json\" },\n body: JSON.stringify(cfdi),\n });\n\n if (!facturamaRes.ok) {\n const errorText = await facturamaRes.text();\n await updateAirtableFields(VIAJES_TABLE, recordId, {\n \"fldC40vBy3YMeegv2\": errorText, // Facturama_Error field\n \"CartaPorteUUID\": \"ERROR\",\n \"FacturamaID\": \"ERROR\",\n \"XML\": [],\n \"PDF\": [],\n });\n return new Response(JSON.stringify({ error: errorText }), { status: facturamaRes.status });\n }\n\n const result = await facturamaRes.json();\n const uuid = result?.Complement?.TaxStamp?.Uuid;\n const id = result?.Id;\n const fechaTimbrado = result?.Complement?.TaxStamp?.FechaTimbrado || result?.Complement?.TaxStamp?.Date;\n\n if (!uuid || !id || !fechaTimbrado) {\n const errorMsg = \"UUID, Facturama ID, or FechaTimbrado missing.\";\n await updateAirtableFields(VIAJES_TABLE, recordId, {\n \"fldC40vBy3YMeegv2\": errorMsg,\n \"CartaPorteUUID\": \"ERROR\",\n \"FacturamaID\": \"ERROR\",\n \"XML\": [],\n \"PDF\": [],\n });\n return new Response(JSON.stringify({ error: errorMsg }), { status: 500 });\n }\n\n // Update Airtable with initial success data\n await updateAirtableFields(VIAJES_TABLE, recordId, {\n CartaPorteUUID: uuid,\n FacturamaID: id,\n FechaTimbrado: fechaTimbrado,\n });\n\n // Fetch XML and PDF from Facturama\n const [xmlBase64, pdfBase64] = await Promise.all([\n fetchFromFacturama(id, \"xml\"),\n fetchFromFacturama(id, \"pdf\"),\n ]);\n\n // Upload to Cloudinary\n const [xmlUrl, pdfUrl] = await Promise.all([\n uploadToCloudinary(xmlBase64, `cfdi_${id}.xml`, \"application/xml\"),\n uploadToCloudinary(pdfBase64, `cfdi_${id}.pdf`, \"application/pdf\"),\n ]);\n\n // Update Airtable with file URLs\n await updateAirtableFields(VIAJES_TABLE, recordId, {\n XML: [{ url: xmlUrl, filename: `cfdi_${id}.xml` }],\n PDF: [{ url: pdfUrl, filename: `cfdi_${id}.pdf` }],\n });\n\n return new Response(\n JSON.stringify({ success: true, uuid, facturamaId: id, xmlUrl, pdfUrl }),\n { status: 200 },\n );\n } catch (err: any) {\n console.error(\"Error in process:\", err);\n await updateAirtableFields(VIAJES_TABLE, recordId, {\n \"CartaPorteUUID\": \"CRITICAL ERROR\",\n \"FacturamaID\": \"CRITICAL ERROR\",\n \"fldC40vBy3YMeegv2\": `Unexpected error: ${String(err)}`,\n \"XML\": [],\n \"PDF\": [],\n });\n return new Response(JSON.stringify({ error: `Unexpected error: ${String(err)}` }), { status: 500 });\n }\n}",[],[171],"files",[148,169],"counts",{"_183":32,"_184":185,"_186":32,"_187":188},"pulls","branches",1,"forks","envVars",{"_189":190,"_191":32},"count",5,"emptyCount","contents",[194,197],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":135,"_156":157,"_104":195,"_99":159,"_160":161,"_162":163,"_164":22,"_165":-5,"_98":196},["D",1758860551385],[150],{"_102":170,"_95":171,"_151":172,"_153":-5,"_154":136,"_155":173,"_156":157,"_104":198,"_99":175,"_160":161,"_162":176,"_164":22,"_165":-5,"_98":199},["D",1754589004634],[171],"file","upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.environment-variables",{"_93":94,"_95":96,"_100":209,"_187":214},{"_102":103,"_95":96,"_104":210,"_106":-5,"_107":22,"_108":109,"_110":-5,"_111":-5,"_14":112,"_113":-5,"_114":22,"_115":-5,"_116":32,"_16":117,"_118":119,"_120":119,"_121":122,"_123":122,"_124":122,"_125":119,"_126":119,"_23":211,"_130":212,"_133":213,"_145":22},["D",1754259298075],{"_93":94,"_128":129},{"_93":94,"_132":129},{"_99":135,"_95":43,"_102":136,"_137":103,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":96,"_144":94},[215,221,224,227,230],{"_216":217,"_104":218,"_219":-5,"_110":-5,"_220":22},"key","AIRTABLE_API_KEY",["D",1754259465584],"updatedAt","isEmpty",{"_216":222,"_104":223,"_219":-5,"_110":-5,"_220":22},"AIRTABLE_BASE_ID",["D",1754259465584],{"_216":225,"_104":226,"_219":-5,"_110":-5,"_220":22},"CLOUDINARY_CLOUD_NAME",["D",1754259465584],{"_216":228,"_104":229,"_219":-5,"_110":-5,"_220":22},"CLOUDINARY_UPLOAD_PRESET",["D",1754259465584],{"_216":231,"_104":232,"_219":-5,"_110":-5,"_220":22},"FACTURAMA_AUTH",["D",1754259465584],"actionData","errors"]