[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_153":154,"_155":156},"routes/_app.x.$handle.$name",{"_94":93,"_32":45,"_103":84,"_27":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":25,"_118":119,"_120":121,"_122":-5,"_123":-5,"_124":125},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":25},"version",2,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","leadQueueSafetyGate.ts","latestPath","fileId","6414a350-7ef4-11f1-b520-1607ee4eb77e","name","fileType","http","content","// Lead-queue safety gate — validates Sales Leads before Phase F outbound dialing. AIC-29.\n//\n// Validation rules (a queued lead must pass all of these to stay queued):\n// 1. Phone is E.164 US format: +1 followed by 10 digits.\n// 2. TCPA fields present: Opt-In Source, Consent Date, Time Zone all non-empty.\n// 3. Lead is linked to a Business (Active Clients) whose Status = \"Active\".\n// 4. No duplicate phone number among other Status=\"queued\" leads (first occurrence\n// keeps queued; later duplicates get flagged).\n//\n// Rows failing any rule: Status -> \"needs review\", with the reason(s) appended to Notes\n// (existing Notes preserved, one timestamped line added). Passing rows are untouched.\n//\n// This is a preventive gate, meant to run before/alongside salesLeadsOutboundTrigger\n// (AIC-19) — that val already skips invalid rows inline at dial-time, but doesn't write\n// anything back, so a bad row just sits in \"queued\" and gets silently re-skipped every\n// run. This val makes bad rows visible in Airtable instead.\n//\n// Env vars required:\n// AIRTABLE_TOKEN - records read/write (+ schema write, for the \"needs review\" select\n// option to auto-create via typecast on first use) on base\n// appufYpiORDVFQ71x. Copied from airConversationInitWebhook via the\n// temp-val bridge pattern (short-lived second file, invoked once,\n// deleted — see PROJECT-STATE.md section 3).\n//\n// Invoke over HTTP (GET or POST) to run once. No cron trigger attached (same Val.town v2\n// API gap noted in AIC-19/AIC-26 — add manually from the dashboard -> this val -> Triggers\n// if a recurring cadence is wanted).\n//\n// Query param ?dryRun=1 reports what WOULD change without writing anything. Default is\n// live: unlike the outbound trigger, this val only ever moves Sales Leads rows sideways\n// within Airtable — it never dials or spends money — so live-by-default is safe.\n\nconst AIRTABLE_TOKEN = Deno.env.get(\"AIRTABLE_TOKEN\");\n\nconst BASE_ID = \"appufYpiORDVFQ71x\";\nconst LEADS_TABLE = \"tblLLC22pLClBkD6F\"; // Sales Leads\nconst CLIENTS_TABLE = \"tblyodVpJMRN0L8uE\"; // Active Clients\n\nconst E164_US = /^\\+1\\d{10}$/;\n\nfunction airtableHeaders() {\n return { Authorization: `Bearer ${AIRTABLE_TOKEN}`, \"Content-Type\": \"application/json\" };\n}\n\nasync function fetchQueuedLeads() {\n const formula = encodeURIComponent(`{Status}=\"queued\"`);\n const url = `https://api.airtable.com/v0/${BASE_ID}/${LEADS_TABLE}?filterByFormula=${formula}`;\n const resp = await fetch(url, { headers: airtableHeaders() });\n const data = await resp.json();\n return data.records ?? [];\n}\n\nasync function fetchClient(recordId: string) {\n const url = `https://api.airtable.com/v0/${BASE_ID}/${CLIENTS_TABLE}/${recordId}`;\n const resp = await fetch(url, { headers: airtableHeaders() });\n if (!resp.ok) return null;\n return resp.json();\n}\n\nasync function patchLead(id: string, fields: Record) {\n const url = `https://api.airtable.com/v0/${BASE_ID}/${LEADS_TABLE}/${id}`;\n const resp = await fetch(url, {\n method: \"PATCH\",\n headers: airtableHeaders(),\n body: JSON.stringify({ fields, typecast: true }),\n });\n return { ok: resp.ok, body: await resp.json().catch(() => ({})) };\n}\n\nfunction appendNote(existing: unknown, reason: string): string {\n const prior = typeof existing === \"string\" ? existing : \"\";\n return `${prior}\\n[${new Date().toISOString()}] needs review: ${reason}`.trim();\n}\n\nexport default async function (req: Request): Promise {\n if (!AIRTABLE_TOKEN) {\n return Response.json({ error: \"AIRTABLE_TOKEN not configured\" }, { status: 500 });\n }\n\n const url = new URL(req.url);\n const dryRun = url.searchParams.get(\"dryRun\") === \"1\";\n\n const leads = await fetchQueuedLeads();\n const clientCache = new Map();\n const phoneSeen = new Map(); // phone -> first lead id that claimed it\n\n const results: Record[] = [];\n\n for (const lead of leads) {\n const f = lead.fields;\n const reasons: string[] = [];\n const phone = f[\"Phone\"];\n const optInSource = f[\"Opt-In Source\"];\n const consentDate = f[\"Consent Date\"];\n const timeZone = f[\"Time Zone\"];\n const businessLinks = f[\"Business\"] ?? [];\n\n if (!phone || typeof phone !== \"string\" || !E164_US.test(phone)) {\n reasons.push(`phone \"${phone ?? \"\"}\" is not E.164 US format (+1XXXXXXXXXX)`);\n }\n if (!optInSource) reasons.push(\"missing Opt-In Source\");\n if (!consentDate) reasons.push(\"missing Consent Date\");\n if (!timeZone) reasons.push(\"missing Time Zone\");\n\n if (!businessLinks.length) {\n reasons.push(\"no linked Business record\");\n } else {\n const clientId = businessLinks[0];\n if (!clientCache.has(clientId)) {\n clientCache.set(clientId, await fetchClient(clientId));\n }\n const client = clientCache.get(clientId);\n const clientStatus = client?.fields?.[\"Status\"];\n if (clientStatus !== \"Active\") {\n reasons.push(`linked business status = \"${clientStatus ?? \"unknown\"}\" (not Active)`);\n }\n }\n\n if (phone && typeof phone === \"string\") {\n if (phoneSeen.has(phone)) {\n reasons.push(`duplicate phone — already queued on lead ${phoneSeen.get(phone)}`);\n } else {\n phoneSeen.set(phone, lead.id);\n }\n }\n\n const entry: Record = { id: lead.id, name: f[\"Name\"] ?? f[\"First Name\"], phone };\n\n if (reasons.length) {\n entry.valid = false;\n entry.reasons = reasons;\n if (dryRun) {\n entry.dryRun = true;\n } else {\n const patch = await patchLead(lead.id, {\n Status: \"needs review\",\n Notes: appendNote(f[\"Notes\"], reasons.join(\"; \")),\n });\n entry.patched = patch.ok;\n if (!patch.ok) entry.patchError = patch.body;\n }\n } else {\n entry.valid = true;\n }\n results.push(entry);\n }\n\n return Response.json({\n mode: dryRun ? \"DRY_RUN\" : \"LIVE\",\n checkedAt: new Date().toISOString(),\n processed: results.length,\n flagged: results.filter((r) => r.valid === false).length,\n results,\n });\n}\n","// Lead-queue safety gate — validates Sales Leads before Phase F outbound dialing. AIC-29.\n// v2 (AIC-45): Airtable read/patch failures now console.error with actionable\n// context instead of silently degrading. No business logic changed.\n//\n// Validation rules (a queued lead must pass all of these to stay queued):\n// 1. Phone is E.164 US format: +1 followed by 10 digits.\n// 2. TCPA fields present: Opt-In Source, Consent Date, Time Zone all non-empty.\n// 3. Lead is linked to a Business (Active Clients) whose Status = \"Active\".\n// 4. No duplicate phone number among other Status=\"queued\" leads (first occurrence\n// keeps queued; later duplicates get flagged).\n//\n// Rows failing any rule: Status -> \"needs review\", with the reason(s) appended to Notes\n// (existing Notes preserved, one timestamped line added). Passing rows are untouched.\n//\n// This is a preventive gate, meant to run before/alongside salesLeadsOutboundTrigger\n// (AIC-19) — that val already skips invalid rows inline at dial-time, but doesn't write\n// anything back, so a bad row just sits in \"queued\" and gets silently re-skipped every\n// run. This val makes bad rows visible in Airtable instead.\n//\n// Env vars required:\n// AIRTABLE_TOKEN - records read/write (+ schema write, for the \"needs review\" select\n// option to auto-create via typecast on first use) on base\n// appufYpiORDVFQ71x. Copied from airConversationInitWebhook via the\n// temp-val bridge pattern (short-lived second file, invoked once,\n// deleted — see PROJECT-STATE.md section 3).\n//\n// Invoke over HTTP (GET or POST) to run once. No cron trigger attached (same Val.town v2\n// API gap noted in AIC-19/AIC-26 — add manually from the dashboard -> this val -> Triggers\n// if a recurring cadence is wanted).\n//\n// Query param ?dryRun=1 reports what WOULD change without writing anything. Default is\n// live: unlike the outbound trigger, this val only ever moves Sales Leads rows sideways\n// within Airtable — it never dials or spends money — so live-by-default is safe.\n\nconst AIRTABLE_TOKEN = Deno.env.get(\"AIRTABLE_TOKEN\");\n\nconst BASE_ID = \"appufYpiORDVFQ71x\";\nconst LEADS_TABLE = \"tblLLC22pLClBkD6F\"; // Sales Leads\nconst CLIENTS_TABLE = \"tblyodVpJMRN0L8uE\"; // Active Clients\n\nconst E164_US = /^\\+1\\d{10}$/;\n\nfunction airtableHeaders() {\n return { Authorization: `Bearer ${AIRTABLE_TOKEN}`, \"Content-Type\": \"application/json\" };\n}\n\nasync function fetchQueuedLeads() {\n const formula = encodeURIComponent(`{Status}=\"queued\"`);\n const url = `https://api.airtable.com/v0/${BASE_ID}/${LEADS_TABLE}?filterByFormula=${formula}`;\n const resp = await fetch(url, { headers: airtableHeaders() });\n const data = await resp.json();\n if (!resp.ok || data.error) {\n // AIC-45: an Airtable error here previously became a silent empty list —\n // a run reporting \"processed: 0\" is indistinguishable from a genuinely\n // empty queue unless this is logged.\n console.error(\"AIC-45: fetchQueuedLeads Airtable error:\", resp.status, JSON.stringify(data));\n }\n return data.records ?? [];\n}\n\nasync function fetchClient(recordId: string) {\n const url = `https://api.airtable.com/v0/${BASE_ID}/${CLIENTS_TABLE}/${recordId}`;\n const resp = await fetch(url, { headers: airtableHeaders() });\n if (!resp.ok) {\n // AIC-45: previously returned null silently — downstream reads that as\n // clientStatus undefined -> flagged \"not Active\", masking a real Airtable\n // fetch failure as a business-status problem.\n console.error(\"AIC-45: fetchClient Airtable error for record\", recordId, \"-\", resp.status, await resp.text().catch(() => \"\"));\n return null;\n }\n return resp.json();\n}\n\nasync function patchLead(id: string, fields: Record) {\n const url = `https://api.airtable.com/v0/${BASE_ID}/${LEADS_TABLE}/${id}`;\n const resp = await fetch(url, {\n method: \"PATCH\",\n headers: airtableHeaders(),\n body: JSON.stringify({ fields, typecast: true }),\n });\n const body = await resp.json().catch(() => ({}));\n if (!resp.ok) {\n // AIC-45: previously only surfaced via entry.patchError in the JSON\n // response — not in Val.town logs, so a run invoked without inspecting\n // the response body (e.g. a future cron trigger) would miss it entirely.\n console.error(\"AIC-45: patchLead failed for\", id, JSON.stringify(fields), \"-\", resp.status, JSON.stringify(body));\n }\n return { ok: resp.ok, body };\n}\n\nfunction appendNote(existing: unknown, reason: string): string {\n const prior = typeof existing === \"string\" ? existing : \"\";\n return `${prior}\\n[${new Date().toISOString()}] needs review: ${reason}`.trim();\n}\n\nexport default async function (req: Request): Promise {\n if (!AIRTABLE_TOKEN) {\n return Response.json({ error: \"AIRTABLE_TOKEN not configured\" }, { status: 500 });\n }\n\n const url = new URL(req.url);\n const dryRun = url.searchParams.get(\"dryRun\") === \"1\";\n\n const leads = await fetchQueuedLeads();\n const clientCache = new Map();\n const phoneSeen = new Map(); // phone -> first lead id that claimed it\n\n const results: Record[] = [];\n\n for (const lead of leads) {\n const f = lead.fields;\n const reasons: string[] = [];\n const phone = f[\"Phone\"];\n const optInSource = f[\"Opt-In Source\"];\n const consentDate = f[\"Consent Date\"];\n const timeZone = f[\"Time Zone\"];\n const businessLinks = f[\"Business\"] ?? [];\n\n if (!phone || typeof phone !== \"string\" || !E164_US.test(phone)) {\n reasons.push(`phone \"${phone ?? \"\"}\" is not E.164 US format (+1XXXXXXXXXX)`);\n }\n if (!optInSource) reasons.push(\"missing Opt-In Source\");\n if (!consentDate) reasons.push(\"missing Consent Date\");\n if (!timeZone) reasons.push(\"missing Time Zone\");\n\n if (!businessLinks.length) {\n reasons.push(\"no linked Business record\");\n } else {\n const clientId = businessLinks[0];\n if (!clientCache.has(clientId)) {\n clientCache.set(clientId, await fetchClient(clientId));\n }\n const client = clientCache.get(clientId);\n const clientStatus = client?.fields?.[\"Status\"];\n if (clientStatus !== \"Active\") {\n reasons.push(`linked business status = \"${clientStatus ?? \"unknown\"}\" (not Active)`);\n }\n }\n\n if (phone && typeof phone === \"string\") {\n if (phoneSeen.has(phone)) {\n reasons.push(`duplicate phone — already queued on lead ${phoneSeen.get(phone)}`);\n } else {\n phoneSeen.set(phone, lead.id);\n }\n }\n\n const entry: Record = { id: lead.id, name: f[\"Name\"] ?? f[\"First Name\"], phone };\n\n if (reasons.length) {\n entry.valid = false;\n entry.reasons = reasons;\n if (dryRun) {\n entry.dryRun = true;\n } else {\n const patch = await patchLead(lead.id, {\n Status: \"needs review\",\n Notes: appendNote(f[\"Notes\"], reasons.join(\"; \")),\n });\n entry.patched = patch.ok;\n if (!patch.ok) entry.patchError = patch.body;\n }\n } else {\n entry.valid = true;\n }\n results.push(entry);\n }\n\n return Response.json({\n mode: dryRun ? \"DRY_RUN\" : \"LIVE\",\n checkedAt: new Date().toISOString(),\n processed: results.length,\n flagged: results.filter((r) => r.valid === false).length,\n results,\n });\n}\n","createdAt",["D",1784406720832],"branchVersion","branchId","2b6a33ca-2082-439b-bd70-7831a76c12a4","id","172c883d-3995-4ba6-9f2c-0114a37726e5","leadQueueSafetyGate",["D",1783972323391],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","AIC-29 Sales Leads validation gate","imageUrl","5a072328-1f44-4d09-b8a0-7919504ab306","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019e5c50-a8bf-778d-aaf9-5ede2971faa5","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_94":93,"_102":98},"org",{"_94":93,"_95":96,"_97":98,"_18":55,"_99":100,"_101":25},"branch",{"_13":14,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","timothylawrence","handle","displayName","Timothy Lawrence","avatar","https://lh3.googleusercontent.com/a/ACg8ocJ-QXv4wwoyobVsfZEjp7nCiQrTDtRRy_t2AK6YRWGNRQQYLLA=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":149,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":-5,"_57":25,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":150,"_79":151,"_81":152,"_83":25},"tree",[144],"files",[144],"counts",{"_134":61,"_135":131,"_136":61,"_137":138,"_139":140},"contents",[126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":121,"_38":130,"_13":131,"_33":34,"_35":37,"_24":25,"_132":-5,"_27":133},"7b34bb8d-d682-4c65-80e2-297db8bc4904","parentId","latest",["D",1784406720832],1,"label",[28],"pulls","branches","forks","envVars",{"_141":131,"_143":61},"connections",{"_141":61,"_142":61},"count","unfilledCount","emptyCount",{"_43":127,"_32":28,"_30":31,"_128":-5,"_41":42,"_40":14,"_129":121,"_38":145,"_13":131,"_33":34,"_35":37,"_24":25,"_132":-5,"_146":147,"_27":148},["D",1784406720832],"children",[],[28],["D",1783972323391],{"_94":93,"_102":98},{"_94":93,"_95":96,"_97":98,"_18":55,"_99":100,"_101":25},{"_13":14,"_32":84,"_43":42,"_85":44,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":45,"_92":93},"ctx",{"_77":-5,"_123":186,"_187":188,"_189":190,"_191":25,"_192":25,"_193":25,"_194":121,"_195":-5,"_196":-7,"_197":-7,"_198":61,"_199":25,"_200":25,"_201":-5,"_202":25,"_203":25,"_204":25,"_205":-5},"ENV",{"_157":158,"_159":160,"_161":84,"_162":163,"_164":165,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","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","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v2