[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_209":210,"_211":212},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_109":90,"_27":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_20":-5,"_121":-5,"_122":-5,"_123":25,"_124":125,"_126":59,"_127":-5,"_128":-5,"_129":130},"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":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",14,"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","db.ts","latestPath","fileId","01a03a6b-1697-71fe-a680-fddd67ed3651","name","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport type ChatRow = {\n id: string;\n event: string;\n time: string;\n domain: string | null;\n referrer: string | null;\n visitorName: string | null;\n visitorEmail: string | null;\n city: string | null;\n country: string | null;\n /** Contact details scraped out of what the visitor actually typed. */\n foundEmail: string | null;\n foundPhone: string | null;\n transcript: string;\n sfStatus: string;\n sfJson: string | null;\n};\n\nlet ready: Promise | null = null;\n/** Runs once per isolate; CREATE TABLE IF NOT EXISTS makes it safe to repeat. */\nfunction init() {\n ready ??= sqlite.execute(`CREATE TABLE IF NOT EXISTS tawk_chats (\n id TEXT PRIMARY KEY,\n event TEXT NOT NULL,\n time TEXT NOT NULL,\n domain TEXT,\n referrer TEXT,\n visitor_name TEXT,\n visitor_email TEXT,\n city TEXT,\n country TEXT,\n found_email TEXT,\n found_phone TEXT,\n transcript TEXT NOT NULL,\n sf_status TEXT NOT NULL DEFAULT 'not_checked',\n sf_json TEXT,\n received_at TEXT NOT NULL\n )`);\n return ready;\n}\n\nexport async function saveChat(row: ChatRow) {\n await init();\n // REPLACE not IGNORE: chat:start arrives first with one message, then\n // chat:transcript_created arrives with the full thread for the same chatId.\n // The later, richer payload should win.\n await sqlite.execute({\n sql: `INSERT OR REPLACE INTO tawk_chats\n (id, event, time, domain, referrer, visitor_name, visitor_email, city, country,\n found_email, found_phone, transcript, sf_status, sf_json, received_at)\n VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,\n args: [\n row.id,\n row.event,\n row.time,\n row.domain,\n row.referrer,\n row.visitorName,\n row.visitorEmail,\n row.city,\n row.country,\n row.foundEmail,\n row.foundPhone,\n row.transcript,\n row.sfStatus,\n row.sfJson,\n new Date().toISOString(),\n ],\n });\n}\n\nexport async function listChats(limit = 100) {\n await init();\n const res = await sqlite.execute({\n sql: `SELECT * FROM tawk_chats ORDER BY received_at DESC LIMIT ?`,\n args: [limit],\n });\n return rowsToObjects(res);\n}\n\nexport async function getChat(id: string) {\n await init();\n const res = await sqlite.execute({\n sql: `SELECT * FROM tawk_chats WHERE id = ?`,\n args: [id],\n });\n return rowsToObjects(res)[0] ?? null;\n}\n\n/** std/sqlite returns {columns, rows}; zip them into plain objects. */\nfunction rowsToObjects(res: { columns: string[]; rows: unknown[][] }) {\n return res.rows.map((r) => Object.fromEntries(res.columns.map((c, i) => [c, r[i]])));\n}\n","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport type ChatRow = {\n id: string;\n event: string;\n time: string;\n domain: string | null;\n referrer: string | null;\n visitorName: string | null;\n visitorEmail: string | null;\n city: string | null;\n country: string | null;\n /** Contact details scraped out of what the visitor actually typed. */\n foundEmail: string | null;\n foundPhone: string | null;\n transcript: string;\n sfStatus: string;\n sfJson: string | null;\n};\n\nlet ready: Promise | null = null;\n/** Runs once per isolate; CREATE TABLE IF NOT EXISTS makes it safe to repeat. */\nfunction init() {\n ready ??= sqlite.execute(`CREATE TABLE IF NOT EXISTS tawk_chats (\n id TEXT PRIMARY KEY,\n event TEXT NOT NULL,\n time TEXT NOT NULL,\n domain TEXT,\n referrer TEXT,\n visitor_name TEXT,\n visitor_email TEXT,\n city TEXT,\n country TEXT,\n found_email TEXT,\n found_phone TEXT,\n transcript TEXT NOT NULL,\n sf_status TEXT NOT NULL DEFAULT 'not_checked',\n sf_json TEXT,\n received_at TEXT NOT NULL\n )`);\n return ready;\n}\n\n/**\n * Per-IP rate limit for the public enrichment lookup.\n * Returns true if the caller may proceed. Counts calls in a rolling window.\n */\nexport async function allowLookup(ip: string, limit: number, windowMinutes: number): Promise {\n await init();\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS lookup_hits (\n ip TEXT NOT NULL,\n at TEXT NOT NULL\n )`);\n const cutoff = new Date(Date.now() - windowMinutes * 60_000).toISOString();\n await sqlite.execute({ sql: `DELETE FROM lookup_hits WHERE at < ?`, args: [cutoff] });\n const res = await sqlite.execute({\n sql: `SELECT COUNT(*) FROM lookup_hits WHERE ip = ? AND at >= ?`,\n args: [ip, cutoff],\n });\n const used = Number(res.rows?.[0]?.[0] ?? 0);\n if (used >= limit) return false;\n await sqlite.execute({\n sql: `INSERT INTO lookup_hits (ip, at) VALUES (?, ?)`,\n args: [ip, new Date().toISOString()],\n });\n return true;\n}\n\nexport async function saveChat(row: ChatRow) {\n await init();\n // REPLACE not IGNORE: chat:start arrives first with one message, then\n // chat:transcript_created arrives with the full thread for the same chatId.\n // The later, richer payload should win.\n await sqlite.execute({\n sql: `INSERT OR REPLACE INTO tawk_chats\n (id, event, time, domain, referrer, visitor_name, visitor_email, city, country,\n found_email, found_phone, transcript, sf_status, sf_json, received_at)\n VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)`,\n args: [\n row.id,\n row.event,\n row.time,\n row.domain,\n row.referrer,\n row.visitorName,\n row.visitorEmail,\n row.city,\n row.country,\n row.foundEmail,\n row.foundPhone,\n row.transcript,\n row.sfStatus,\n row.sfJson,\n new Date().toISOString(),\n ],\n });\n}\n\nexport async function listChats(limit = 100) {\n await init();\n const res = await sqlite.execute({\n sql: `SELECT * FROM tawk_chats ORDER BY received_at DESC LIMIT ?`,\n args: [limit],\n });\n return rowsToObjects(res);\n}\n\nexport async function getChat(id: string) {\n await init();\n const res = await sqlite.execute({\n sql: `SELECT * FROM tawk_chats WHERE id = ?`,\n args: [id],\n });\n return rowsToObjects(res)[0] ?? null;\n}\n\n/** std/sqlite returns {columns, rows}; zip them into plain objects. */\nfunction rowsToObjects(res: { columns: string[]; rows: unknown[][] }) {\n return res.rows.map((r) => Object.fromEntries(res.columns.map((c, i) => [c, r[i]])));\n}\n","createdAt",["D",1787694405142],"branchVersion","branchId","ae272551-0b66-498e-893a-608c3c317b83","id","68d21ace-3c73-4585-929b-fc6f43782874","tribeca-tawk-transcripts",["D",1787686491713],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Receives tawk.to chat transcripts, matches to Salesforce","imageUrl","c5acd3b3-60a7-4deb-bc6d-528f83012ea9","pinnedFileId","01a03a6b-1697-71fe-a681-032b2cbe7562","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f8fe2-cdfc-775d-a845-a69af13d39cb","tursoName","68d21ace3c734585929bfc6f43782874","tursoHostname","68d21ace3c734585929bfc6f43782874-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789438866375],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_108":104},"org",{"_100":99,"_101":102,"_103":104,"_18":55,"_105":106,"_107":25},"branch",{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"isOwned",31,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Tribeca_Rep","handle","displayName","M A","avatar","https://lh3.googleusercontent.com/a/ACg8ocI9znhXn2hWp1wjjyWzeuOyoO_JrDgJo8aD0umFraR7bAG3UAmc=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":204,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":205,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":206,"_84":207,"_86":208,"_88":25},"tree",[183,184,185,186,187],"files",[183,184,185,186,187],"counts",{"_172":63,"_173":174,"_175":63,"_176":177,"_178":179},"contents",[131,132,133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":165,"_32":166,"_30":167,"_138":-5,"_41":42,"_40":168,"_140":25,"_38":169,"_13":150,"_33":20,"_35":170,"_24":25,"_145":-5,"_27":171},{"_43":161,"_32":28,"_30":31,"_138":-5,"_41":42,"_40":14,"_140":59,"_38":162,"_13":163,"_33":34,"_35":37,"_24":25,"_145":-5,"_27":164},{"_43":154,"_32":155,"_30":156,"_138":-5,"_41":42,"_40":157,"_140":25,"_38":158,"_13":63,"_33":34,"_35":159,"_24":25,"_145":-5,"_27":160},{"_43":147,"_32":148,"_30":149,"_138":-5,"_41":42,"_40":150,"_140":59,"_38":151,"_13":63,"_33":34,"_35":152,"_24":25,"_145":-5,"_27":153},{"_43":136,"_32":137,"_30":57,"_138":-5,"_41":42,"_40":139,"_140":25,"_38":141,"_13":142,"_33":143,"_35":144,"_24":25,"_145":45,"_27":146},"db37d087-5415-4547-b401-a93b8a7b9e4f","main.ts","parentId",11,"latest",["D",1787694076342],4,"http","// tawk.to chat transcripts -> SQLite, with a Salesforce match.\n//\n// POST / tawk webhook receiver (set this URL in tawk Admin > Webhooks)\n// GET /?key=... read the chats, their full message bodies, and any SF match\n//\n// Env vars:\n// TAWK_WEBHOOK_SECRET required — the secret you set when creating the webhook\n// VIEW_KEY required to open the viewer (transcripts are customer PII)\n// SALESFORCE_AGENT_URL optional — endpoint of tribeca-salesforce-agent\n// SALESFORCE_AGENT_KEY optional — its API_SHARED_SECRET\n// Without the Salesforce pair, transcripts still land; matching reports \"error\".\nimport { getChat, listChats, saveChat } from \"./db.ts\";\nimport { findInSalesforce, scrapeContact } from \"./lookup.ts\";\nimport { ENRICH_JS } from \"./enrich.ts\";\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n if (req.method === \"POST\") return receive(req);\n // Served before the viewer's key check: this is public JS for your website,\n // not customer data. It contains no secrets and calls no endpoint.\n if (req.method === \"GET\" && url.pathname === \"/enrich.js\") {\n return new Response(ENRICH_JS, {\n headers: {\n \"Content-Type\": \"application/javascript; charset=utf-8\",\n \"Access-Control-Allow-Origin\": \"*\",\n \"Cache-Control\": \"public, max-age=300\",\n },\n });\n }\n if (req.method === \"GET\") return viewer(url);\n return new Response(\"Method not allowed\", { status: 405 });\n}\n\n// ------------------------------------------------------------------ webhook\nasync function receive(req: Request): Promise {\n const secret = Deno.env.get(\"TAWK_WEBHOOK_SECRET\");\n if (!secret) return new Response(\"TAWK_WEBHOOK_SECRET not set\", { status: 500 });\n\n const raw = await req.text();\n const signature = req.headers.get(\"X-Tawk-Signature\") ?? \"\";\n if (!await verify(raw, signature, secret)) {\n console.error(\"Rejected webhook: bad signature\");\n return new Response(\"Invalid signature\", { status: 401 });\n }\n\n let payload: Record;\n try {\n payload = JSON.parse(raw);\n } catch {\n return new Response(\"Bad JSON\", { status: 400 });\n }\n\n const event = String(payload.event ?? \"unknown\");\n const parsed = parseEvent(event, payload);\n if (!parsed) {\n // Acknowledge anything we don't model, so tawk doesn't retry it for 12h.\n console.log(`Ignoring unmodelled event: ${event}`);\n return Response.json({ received: true, ignored: event });\n }\n\n // Scrape ONLY what the visitor typed. Agents paste the office number and\n // support links constantly; matching on those would tie every chat to Tribeca.\n const { email: foundEmail, phone: foundPhone } = scrapeContact(parsed.visitorText);\n const email = parsed.visitorEmail || foundEmail;\n const match = await findInSalesforce(email, foundPhone);\n\n await saveChat({\n id: parsed.id,\n event,\n time: String(payload.time ?? new Date().toISOString()),\n domain: payload.domain ?? null,\n referrer: payload.referrer ?? null,\n visitorName: parsed.visitorName,\n visitorEmail: parsed.visitorEmail,\n city: parsed.city,\n country: parsed.country,\n foundEmail,\n foundPhone,\n transcript: parsed.transcript,\n sfStatus: match.status,\n sfJson: JSON.stringify(match),\n });\n\n return Response.json({ received: true });\n}\n\ntype Parsed = {\n id: string;\n visitorName: string | null;\n visitorEmail: string | null;\n city: string | null;\n country: string | null;\n transcript: string;\n /** Visitor messages only — what we're allowed to scrape for contact details. */\n visitorText: string;\n};\n\nexport function parseEvent(event: string, p: Record): Parsed | null {\n const v = (o: any) => ({\n visitorName: o?.name ?? null,\n visitorEmail: o?.email ?? null,\n city: o?.city ?? null,\n country: o?.country ?? null,\n });\n\n if (event === \"chat:transcript_created\") {\n const chat = p.chat ?? {};\n const messages: any[] = Array.isArray(chat.messages) ? chat.messages : [];\n const label = (m: any) =>\n m?.sender?.t === \"v\" ? \"visitor\" : m?.sender?.t === \"a\" ? `agent ${m?.sender?.n ?? \"\"}`.trim() : \"system\";\n return {\n id: String(chat.id ?? p.chatId ?? crypto.randomUUID()),\n ...v(chat.visitor),\n transcript: messages.map((m) => `${label(m)}: ${m?.msg ?? \"\"}`).join(\"\\n\"),\n visitorText: messages.filter((m) => m?.sender?.t === \"v\").map((m) => m?.msg ?? \"\").join(\"\\n\"),\n };\n }\n\n if (event === \"chat:start\") {\n const text = p.message?.text ?? \"\";\n const fromVisitor = p.message?.sender?.type === \"visitor\";\n return {\n id: String(p.chatId ?? crypto.randomUUID()),\n ...v(p.visitor),\n transcript: `${fromVisitor ? \"visitor\" : \"agent\"}: ${text}`,\n visitorText: fromVisitor ? text : \"\",\n };\n }\n\n if (event === \"ticket:create\") {\n const t = p.ticket ?? {};\n const text = `${t.subject ?? \"\"}\\n${t.message ?? \"\"}`.trim();\n return {\n id: `ticket-${t.id ?? crypto.randomUUID()}`,\n visitorName: p.requester?.name ?? null,\n visitorEmail: p.requester?.email ?? null,\n city: null,\n country: null,\n transcript: text,\n visitorText: text,\n };\n }\n\n // chat:end carries no message body — the transcript event covers that chat.\n return null;\n}\n\n/** tawk signs with HMAC-SHA1 over the raw body, hex encoded. */\nasync function verify(body: string, signature: string, secret: string): Promise {\n const enc = new TextEncoder();\n const key = await crypto.subtle.importKey(\n \"raw\",\n enc.encode(secret),\n { name: \"HMAC\", hash: \"SHA-1\" },\n false,\n [\"sign\"],\n );\n const sig = await crypto.subtle.sign(\"HMAC\", key, enc.encode(body));\n const hex = [...new Uint8Array(sig)].map((b) => b.toString(16).padStart(2, \"0\")).join(\"\");\n return timingSafeEqual(hex, signature.trim().toLowerCase());\n}\n\nfunction timingSafeEqual(a: string, b: string): boolean {\n if (a.length !== b.length) return false;\n let diff = 0;\n for (let i = 0; i < a.length; i++) diff |= a.charCodeAt(i) ^ b.charCodeAt(i);\n return diff === 0;\n}\n\n// ------------------------------------------------------------------- viewer\nasync function viewer(url: URL): Promise {\n const expected = Deno.env.get(\"VIEW_KEY\");\n if (!expected) {\n return new Response(\n \"Set a VIEW_KEY environment variable, then open /?key=YOUR_KEY.\\n\" +\n \"This page shows chat transcripts and customer contact details, so it stays closed until you do.\",\n { status: 503 },\n );\n }\n if (url.searchParams.get(\"key\") !== expected) return new Response(\"Not found\", { status: 404 });\n\n const id = url.searchParams.get(\"chat\");\n if (id) {\n const chat = await getChat(id);\n if (!chat) return new Response(\"Not found\", { status: 404 });\n return html(detailPage(chat, url.searchParams.get(\"key\")!));\n }\n return html(listPage(await listChats(), url.searchParams.get(\"key\")!));\n}\n\nconst esc = (s: unknown) =>\n String(s ?? \"\").replace(/[&<>\"]/g, (m) => ({ \"&\": \"&\", \"<\": \"<\", \">\": \">\", '\"': \""\" }[m]!));\n\nconst STYLE =\n ``;\n\nconst html = (body: string) => new Response(`${STYLE}${body}`, {\n headers: { \"Content-Type\": \"text/html; charset=utf-8\" },\n});\n\nfunction listPage(chats: Record[], key: string) {\n if (!chats.length) {\n return `

tawk chats

Nothing received yet. Point a tawk webhook at this URL and start a chat.

`;\n }\n const rows = chats.map((c) =>\n `\n ${esc(String(c.received_at).replace(\"T\", \" \").slice(0, 16))}\n ${esc(c.visitor_name) || '-'}\n ${esc(c.city) || '-'}\n ${esc(c.found_email || c.visitor_email) || '-'}\n ${esc(c.found_phone) || '-'}\n ${esc(String(c.sf_status).replace(/_/g, \" \"))}\n read\n `\n ).join(\"\");\n return `

tawk chats (${chats.length})

\n${rows}

Received	Name	City	Email	Phone	Salesforce

`;\n}\n\nfunction detailPage(c: Record, key: string) {\n let sf = \"\";\n try {\n const m = JSON.parse(String(c.sf_json ?? \"{}\"));\n sf = m.status === \"matched\"\n ? `

Matched on ${esc(m.matchedOn)}

${esc(JSON.stringify(m.records, null, 2))}

`\n : `

${esc(m.status)}${m.error ? `: ${esc(m.error)}` : \"\"}

`;\n } catch {\n sf = `

`;\n }\n return `

← all chats

${esc(c.visitor_name) || \"Visitor\"} ${esc(c.city)}

${esc(c.event)} · ${esc(c.time)} · ${esc(c.referrer)}

Transcript

${esc(c.transcript)}

Scraped from what the visitor typed

email: ${esc(c.found_email) || \"-\"} · phone: ${esc(c.found_phone) || \"-\"}

Salesforce

${sf}`;\n}\n","label",[137],"6511678d-a93c-4496-b757-90e21c120849","lookup.ts","2d97073e-a0bc-11f1-80af-1607ee4eb77e",3,["D",1787686550422],"// Scrape contact details out of what the visitor typed, then ask Salesforce\n// whether we already know them.\n//\n// This runs server-side and the answer is only ever shown to your own team, so\n// matching here is safe in a way it would NOT be if a bot were reporting the\n// result back to the visitor. Never reuse this to tell a visitor whether an\n// account exists — that lets anyone probe your customer list.\n\nconst EMAIL_RE = /[\\w.+-]+@[\\w-]+\\.[\\w.-]+/;\n// US-ish: optional +1, then 3-3-4 with common separators.\nconst PHONE_RE = /(?:\\+?1[\\s.-]?)?\$?\\d{3}\$?[\\s.-]?\\d{3}[\\s.-]?\\d{4}/;\n\nexport function scrapeContact(text: string) {\n const email = text.match(EMAIL_RE)?.[0] ?? null;\n const rawPhone = text.match(PHONE_RE)?.[0] ?? null;\n return { email, phone: rawPhone ? normalizePhone(rawPhone) : null };\n}\n\n/** Digits only, dropping a leading US country code. */\nfunction normalizePhone(raw: string): string | null {\n const digits = raw.replace(/\\D/g, \"\");\n const ten = digits.length === 11 && digits.startsWith(\"1\") ? digits.slice(1) : digits;\n return ten.length === 10 ? ten : null;\n}\n\n/** SOQL has no bound parameters here, so escape what we interpolate. */\nfunction soqlEscape(v: string): string {\n return v.replace(/\\\\/g, \"\\\\\\\\\").replace(/'/g, \"\\\\'\").slice(0, 120);\n}\n\nasync function query(soql: string): Promise[]> {\n const base = Deno.env.get(\"SALESFORCE_AGENT_URL\");\n const key = Deno.env.get(\"SALESFORCE_AGENT_KEY\");\n if (!base || !key) throw new Error(\"SALESFORCE_AGENT_URL / SALESFORCE_AGENT_KEY not set\");\n const url = `${base}${base.includes(\"?\") ? \"&\" : \"?\"}q=${encodeURIComponent(soql)}`;\n const res = await fetch(url, { headers: { \"x-api-key\": key } });\n if (!res.ok) throw new Error(`Salesforce proxy ${res.status}: ${(await res.text()).slice(0, 200)}`);\n const json = await res.json();\n return json.records ?? [];\n}\n\nexport type Match = {\n status: \"matched\" | \"no_match\" | \"no_identifier\" | \"error\";\n matchedOn?: string;\n records?: Record[];\n error?: string;\n};\n\n/**\n * Look for an existing Contact, Lead, or Account.\n * Email and phone only — deliberately not name. Names aren't unique and a\n * confident wrong match is worse than no match.\n */\nexport async function findInSalesforce(email: string | null, phone: string | null): Promise {\n if (!email && !phone) return { status: \"no_identifier\" };\n try {\n if (email) {\n const e = soqlEscape(email);\n const contacts = await query(\n `SELECT Id, Name, Email, Phone, Account.Name FROM Contact WHERE Email = '${e}' LIMIT 3`,\n );\n if (contacts.length) return { status: \"matched\", matchedOn: \"contact email\", records: contacts };\n\n const leads = await query(\n `SELECT Id, Name, Company, Email, Phone, Status FROM Lead WHERE Email = '${e}' AND IsConverted = false LIMIT 3`,\n );\n if (leads.length) return { status: \"matched\", matchedOn: \"lead email\", records: leads };\n }\n\n if (phone) {\n // Salesforce stores phones inconsistently formatted, so compare on the\n // last 7 digits rather than the whole string.\n const tail = soqlEscape(phone.slice(-7));\n const contacts = await query(\n `SELECT Id, Name, Email, Phone, Account.Name FROM Contact WHERE Phone LIKE '%${tail}' LIMIT 3`,\n );\n if (contacts.length) return { status: \"matched\", matchedOn: \"contact phone\", records: contacts };\n\n const leads = await query(\n `SELECT Id, Name, Company, Email, Phone, Status FROM Lead WHERE Phone LIKE '%${tail}' AND IsConverted = false LIMIT 3`,\n );\n if (leads.length) return { status: \"matched\", matchedOn: \"lead phone\", records: leads };\n }\n\n return { status: \"no_match\" };\n } catch (err) {\n return { status: \"error\", error: String(err).slice(0, 300) };\n }\n}\n",[148],"f316fda5-9d2d-4162-ad06-596381c2d614","enrich.ts","a7465ac4-a0cd-11f1-88e7-1607ee4eb77e",9,["D",1787694056015],"// Agent-facing enrichment for the tawk widget, served as plain JS.\n//\n// Scans what the VISITOR types for a phone number, email, or ZIP and writes\n// them into tawk's visitor attributes, so they appear in the agent's Details\n// panel the moment they're mentioned — instead of the agent scrolling the\n// transcript hunting for a number.\n//\n// It deliberately performs NO lookup. Everything it surfaces is something the\n// visitor just said out loud in that chat, so there is no endpoint for a\n// stranger to probe and nothing disclosed that the agent couldn't already read.\n// The agent has authenticated Salesforce access; the last mile is theirs.\n//\n// Only `name` and `email` need tawk's Secure Mode. These are all custom\n// attributes (alphanumeric + dash keys), so no Secure Mode and no hashing.\nexport const ENRICH_JS = String.raw`\n(function () {\n if (window.__tribecaTawkEnrich) return;\n window.__tribecaTawkEnrich = true;\n\n var EMAIL_RE = /[\\w.+-]+@[\\w-]+\\.[\\w.-]+/;\n var PHONE_RE = /(?:\\+?1[\\s.-]?)?\$?\\d{3}\$?[\\s.-]?\\d{3}[\\s.-]?\\d{4}/;\n var ZIP_RE = /\\b\\d{5}(?:-\\d{4})?\\b/;\n\n window.Tawk_API = window.Tawk_API || {};\n\n // Accumulated across the whole conversation, so a number given in message one\n // is still on screen when the agent joins at message six.\n var found = {};\n\n function normPhone(raw) {\n var d = String(raw).replace(/\\D/g, \"\");\n if (d.length === 11 && d.charAt(0) === \"1\") d = d.slice(1);\n return d.length === 10 ? d.slice(0, 3) + \"-\" + d.slice(3, 6) + \"-\" + d.slice(6) : null;\n }\n\n function apply() {\n if (!window.Tawk_API || typeof window.Tawk_API.setAttributes !== \"function\") return;\n var attrs = {};\n if (found.phone) attrs[\"visitor-phone\"] = found.phone;\n if (found.email) attrs[\"visitor-email\"] = found.email;\n if (found.zip) attrs[\"mentioned-zip\"] = found.zip;\n var keys = [];\n for (var k in attrs) if (attrs.hasOwnProperty(k)) keys.push(k);\n if (!keys.length) return;\n try {\n window.Tawk_API.setAttributes(attrs, function (err) {\n if (err) console.warn(\"tawk enrich: setAttributes failed\", err);\n });\n } catch (e) {\n console.warn(\"tawk enrich: setAttributes threw\", e);\n }\n }\n\n function scan(text) {\n if (!text) return;\n var changed = false;\n if (!found.email) {\n var e = text.match(EMAIL_RE);\n if (e) { found.email = e[0]; changed = true; }\n }\n if (!found.phone) {\n var p = text.match(PHONE_RE);\n if (p) { var n = normPhone(p[0]); if (n) { found.phone = n; changed = true; } }\n }\n if (!found.zip) {\n // Run the ZIP check on text with any phone number removed, so the digits\n // of a phone can never be mistaken for a postal code.\n var stripped = text.replace(new RegExp(PHONE_RE.source, \"g\"), \" \");\n var z = stripped.match(ZIP_RE);\n if (z) { found.zip = z[0]; changed = true; }\n }\n if (changed) apply();\n }\n\n // Chain onto any existing handlers rather than replacing them — another\n // script on the page may already own these callbacks.\n var prevMessage = window.Tawk_API.onChatMessageVisitor;\n window.Tawk_API.onChatMessageVisitor = function (message) {\n if (typeof prevMessage === \"function\") { try { prevMessage(message); } catch (e) {} }\n try {\n scan(typeof message === \"string\" ? message : (message && (message.message || message.text)) || \"\");\n } catch (e) { /* never let enrichment break the chat */ }\n };\n\n var prevPrechat = window.Tawk_API.onPrechatSubmit;\n window.Tawk_API.onPrechatSubmit = function (data) {\n if (typeof prevPrechat === \"function\") { try { prevPrechat(data); } catch (e) {} }\n try { scan(JSON.stringify(data || {})); } catch (e) {}\n };\n\n // If the visitor returns mid-session, re-stamp what we already know.\n var prevLoad = window.Tawk_API.onLoad;\n window.Tawk_API.onLoad = function () {\n if (typeof prevLoad === \"function\") { try { prevLoad(); } catch (e) {} }\n apply();\n };\n})();\n`;\n",[155],"4eb5f669-0cbf-4496-a085-2f5ba5c26cb4",["D",1787694405142],2,[28],"7c2fb1fd-e6f9-4e5b-a5ce-490d011a53c5","README.md","01a03a6b-1697-71fe-a680-fa2e6414fd9f",13,["D",1787694119081],"# tawk.to chat transcripts → SQLite → Salesforce match\n\nReceives tawk.to webhooks, stores the full message body of every chat, scrapes\ncontact details out of what the **visitor** typed, and checks whether that\nperson is already in Salesforce.\n\nFree and ungated — this uses tawk webhooks, not the beta REST API, and needs no\nplan upgrade.\n\n## Endpoints\n\n| | |\n| --- | --- |\n| `POST /` | webhook receiver. Put this URL in tawk **Admin → Webhooks**. |\n| `GET /enrich.js` | agent-facing enrichment script for your website (public, no secrets) |\n| `GET /?key=…` | list of chats |\n| `GET /?key=…&chat=` | one chat: full transcript, what was scraped, Salesforce match |\n\n## Setup\n\n1. In tawk: **Admin → Webhooks** → add a webhook pointing at this val's URL.\n Subscribe to **chat:transcript_created** (the one carrying the message body);\n `chat:start` and `ticket:create` are also handled. Set a secret.\n2. Set the env vars below.\n\n| Key | Required | What it does |\n| --- | --- | --- |\n| `TAWK_WEBHOOK_SECRET` | yes | The secret from step 1. Requests failing HMAC are rejected with 401. |\n| `VIEW_KEY` | to read anything | Any random string. Transcripts are customer PII, so the viewer stays shut until this is set. Use letters and digits only — it goes in a URL. |\n| `SALESFORCE_AGENT_URL` | for matching | Endpoint of `tribeca-salesforce-agent`. Copy from `tribeca-outbound-sales-call`. |\n| `SALESFORCE_AGENT_KEY` | for matching | That val's `API_SHARED_SECRET`. |\n\nWithout the Salesforce pair, transcripts still land — matches just report `error`.\n\n## enrich.js — showing agents who they're talking to\n\nAdd this to tribecabeverage.com **above the tawk embed** (tawk reads its\n`Tawk_API` callbacks at init, so load order matters):\n\n```html\n\n\n```\n\nIt hooks `onChatMessageVisitor` and `onPrechatSubmit`, scans what the visitor\ntypes, and writes `visitor-phone`, `visitor-email` and `mentioned-zip` into\ntawk's visitor attributes — so the agent sees them in the Details panel instead\nof scrolling the transcript for a number. Values accumulate across the\nconversation, so a number given in message one is still shown at message six.\n\n**It performs no lookup and calls no endpoint.** Everything it surfaces is\nsomething the visitor just said in that chat. That is deliberate: an endpoint the\nbrowser could call to resolve a phone number into a customer would be one a\nstranger could probe. Agents have authenticated Salesforce access; the last mile\nis theirs.\n\nCustom attributes need no Secure Mode — only `name`/`email` do, which is why\nthese use dashed custom keys instead.\n\n## Two deliberate design decisions\n\n**Only visitor messages are scraped for contact details.** Agents paste the\noffice number and support address constantly; scraping the whole transcript\nwould match every single chat to Tribeca itself. Verified: given a thread where\nMichael pastes 973-913-4568 and info@tribecabeverage.com, the scraper returns\nonly the visitor's own `dana@acmedeli.com` / `2015550147`.\n\n**Matching is by email and phone, never by name.** Names aren't unique and a\nconfident wrong match is worse than no match.\n\n## Do not reuse this for a customer-facing bot\n\nThe Salesforce match here is safe because the result is only ever shown to your\nown team. Wiring the same lookup into a bot that tells a *visitor* whether an\naccount exists would let anyone probe your customer list — type a name, learn\nwhether that business is a customer, then get handed their address. If that\ncapability is wanted in Apollo, it needs to match on something the real customer\nwould know before revealing anything.\n\n## Related\n\n- `tribeca-afterhours-chat` — the standalone after-hours widget (superseded if\n tawk's Apollo AI agent gets turned on)\n- `tribeca-salesforce-agent` — the read-only SOQL proxy this queries\n",[166],"pulls","branches",1,"forks","envVars",{"_180":163,"_182":174},"connections",{"_180":63,"_181":63},"count","unfilledCount","emptyCount",{"_43":165,"_32":166,"_30":167,"_138":-5,"_41":42,"_40":168,"_140":25,"_38":201,"_13":150,"_33":20,"_35":170,"_24":25,"_145":-5,"_189":202,"_27":203},{"_43":161,"_32":28,"_30":31,"_138":-5,"_41":42,"_40":14,"_140":59,"_38":198,"_13":163,"_33":34,"_35":37,"_24":25,"_145":-5,"_189":199,"_27":200},{"_43":154,"_32":155,"_30":156,"_138":-5,"_41":42,"_40":157,"_140":25,"_38":195,"_13":63,"_33":34,"_35":159,"_24":25,"_145":-5,"_189":196,"_27":197},{"_43":147,"_32":148,"_30":149,"_138":-5,"_41":42,"_40":150,"_140":59,"_38":192,"_13":63,"_33":34,"_35":152,"_24":25,"_145":-5,"_189":193,"_27":194},{"_43":136,"_32":137,"_30":57,"_138":-5,"_41":42,"_40":139,"_140":25,"_38":188,"_13":142,"_33":143,"_35":144,"_24":25,"_145":45,"_189":190,"_27":191},["D",1787694076342],"children",[],[137],["D",1787686550422],[],[148],["D",1787694056015],[],[155],["D",1787694405142],[],[28],["D",1787694119081],[],[166],["D",1787686491713],["D",1789438866375],{"_100":99,"_108":104},{"_100":99,"_101":102,"_103":104,"_18":55,"_105":106,"_107":25},{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"ctx",{"_82":-5,"_128":242,"_243":244,"_245":246,"_247":25,"_248":25,"_249":25,"_250":59,"_251":-5,"_252":-7,"_253":-7,"_254":63,"_255":25,"_256":25,"_257":-5,"_258":25,"_259":25,"_260":25,"_261":-5},"ENV",{"_213":214,"_215":216,"_217":90,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241},"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 · v14