[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_210":211,"_212":213},"routes/_app.x.$handle.$name",{"_99":98,"_32":44,"_108":89,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":58,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",20,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":20,"_34":36,"_37":38,"_39":14,"_40":41,"_24":25},"previous",{"_30":31,"_32":28,"_33":20,"_34":35},"deleted",false,"deletedHere","path","README.md","latestPath","fileId","01a03a6b-1697-71fe-a680-fa2e6414fd9f","name","fileType","content","# 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","# 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 these into tawk's visitor attributes so they show in the\nagent's Details panel:\n\n| Attribute | Source |\n| --- | --- |\n| `visitor-phone` | scraped from the visitor's own messages |\n| `visitor-email` | scraped |\n| `mentioned-zip` | scraped (phone digits stripped first so they can't be mistaken for a ZIP) |\n| `sf-status` | `existing customer` / `existing customer - multiple accounts` / `no account match` |\n| `sf-account` | Salesforce account name, when exactly one matched |\n\nValues accumulate across the conversation, so a number given in message one is\nstill on screen when an agent joins at message six.\n\nCustom attributes need no Secure Mode — only `name`/`email` do, which is why\nthese use dashed custom keys.\n\n### The `/enrich-lookup` tradeoff — read before changing it\n\n`sf-status` and `sf-account` require a lookup the **visitor's browser** performs,\nso `/enrich-lookup` cannot carry a secret. Anything it returns is readable by\nanyone who finds the URL: feed it phone numbers, learn which are customers and\nwhat those accounts are called.\n\nThat was accepted deliberately. The controls that bound it:\n\n- **phone only** — Salesforce exposes no email field to this integration user\n- **minimal response** — `known`, `ambiguous`, `account_name`. Never a delivery\n date, address, other contact, or record id. Do not widen this.\n- **per-IP rate limit** — 15/hour (verified: 16th request returns 429)\n- **Origin allow-list** — non-Tribeca origins get 403 (friction only; a header\n is trivially forged with curl)\n- **every call logged** with IP and outcome, so abuse is visible\n\nThe clean fix, if it ever matters: tawk's REST API (beta, gated behind their\naccess-request form) would let this val set visitor attributes server-side, and\n`/enrich-lookup` could then be deleted entirely.\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","createdAt",["D",1787694504963],"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",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":54,"_104":105,"_106":25},"branch",{"_13":88,"_32":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"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",{"_42":43,"_32":44,"_37":205,"_46":-5,"_47":25,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":206,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":207,"_83":208,"_85":209,"_87":25},"tree",[184,185,186,187,188],"files",[184,185,186,187,188],"counts",{"_173":62,"_174":175,"_176":62,"_177":178,"_179":180},"contents",[130,131,132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":169,"_32":28,"_30":31,"_137":-5,"_40":41,"_39":14,"_139":58,"_37":170,"_13":171,"_33":20,"_34":36,"_24":25,"_144":-5,"_27":172},{"_42":162,"_32":163,"_30":164,"_137":-5,"_40":41,"_39":165,"_139":58,"_37":166,"_13":159,"_33":151,"_34":167,"_24":25,"_144":-5,"_27":168},{"_42":154,"_32":155,"_30":156,"_137":-5,"_40":41,"_39":157,"_139":25,"_37":158,"_13":159,"_33":151,"_34":160,"_24":25,"_144":-5,"_27":161},{"_42":146,"_32":147,"_30":148,"_137":-5,"_40":41,"_39":149,"_139":58,"_37":150,"_13":62,"_33":151,"_34":152,"_24":25,"_144":-5,"_27":153},{"_42":135,"_32":136,"_30":56,"_137":-5,"_40":41,"_39":138,"_139":25,"_37":140,"_13":141,"_33":142,"_34":143,"_24":25,"_144":44,"_27":145},"6266ec31-19c1-4637-ae22-738dab9fe608","main.ts","parentId",19,"latest",["D",1787694455941],7,"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 { allowLookup, 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.replaceAll(\"__BASE__\", url.origin), {\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\" && url.pathname === \"/enrich-lookup\") return enrichLookup(req, url);\n if (req.method === \"GET\") return viewer(url);\n return new Response(\"Method not allowed\", { status: 405 });\n}\n\n// -------------------------------------------------------- enrichment lookup\n// PUBLIC endpoint, called from the visitor's browser by enrich.js. It cannot\n// carry a secret, so anything it returns is readable by anyone who finds it.\n//\n// Everything here exists to keep that blast radius small:\n// - resolves phone only, never email (Salesforce exposes no email field)\n// - returns ONLY whether they are a customer and the account name.\n// No delivery date, no address, no other contacts, no record ids.\n// - per-IP rate limit\n// - Origin check (friction, not security — a header is trivially forged)\n// - every call logged, so abuse is visible in the val's logs\nconst ALLOWED_ORIGINS = [\"https://tribecabeverage.com\", \"https://www.tribecabeverage.com\"];\n\nasync function enrichLookup(req: Request, url: URL): Promise {\n const cors = (origin: string | null) => ({\n \"Access-Control-Allow-Origin\": origin && ALLOWED_ORIGINS.includes(origin) ? origin : ALLOWED_ORIGINS[0],\n \"Content-Type\": \"application/json\",\n \"Cache-Control\": \"no-store\",\n });\n const origin = req.headers.get(\"Origin\");\n const ip = req.headers.get(\"cf-connecting-ip\") ?? req.headers.get(\"x-forwarded-for\")?.split(\",\")[0]?.trim() ??\n \"unknown\";\n\n if (origin && !ALLOWED_ORIGINS.includes(origin)) {\n console.warn(`enrich-lookup blocked: origin=${origin} ip=${ip}`);\n return new Response(JSON.stringify({ known: false }), { status: 403, headers: cors(origin) });\n }\n\n if (!await allowLookup(ip, 15, 60)) {\n console.warn(`enrich-lookup rate limited: ip=${ip}`);\n return new Response(JSON.stringify({ known: false, throttled: true }), { status: 429, headers: cors(origin) });\n }\n\n const phone = (url.searchParams.get(\"phone\") ?? \"\").replace(/\\D/g, \"\").slice(0, 15);\n if (phone.length < 10) {\n return new Response(JSON.stringify({ known: false }), { headers: cors(origin) });\n }\n\n const base = Deno.env.get(\"ACCOUNT_LOOKUP_URL\") ?? \"https://tribeca-apollo.val.run/account-lookup\";\n const key = Deno.env.get(\"APOLLO_TOOL_KEY\");\n if (!key) {\n console.error(\"enrich-lookup: APOLLO_TOOL_KEY not set\");\n return new Response(JSON.stringify({ known: false }), { headers: cors(origin) });\n }\n\n try {\n const r = await fetch(`${base}?phone=${encodeURIComponent(phone)}`, { headers: { \"x-api-key\": key } });\n const j = await r.json();\n console.log(`enrich-lookup ip=${ip} found=${j.found} ambiguous=${!!j.ambiguous}`);\n // Deliberately narrow: never pass through next_delivery_date or messages.\n if (j.ambiguous) return new Response(JSON.stringify({ known: true, ambiguous: true }), { headers: cors(origin) });\n if (!j.found) return new Response(JSON.stringify({ known: false }), { headers: cors(origin) });\n return new Response(\n JSON.stringify({ known: true, account_name: String(j.account_name ?? \"\").slice(0, 120) }),\n { headers: cors(origin) },\n );\n } catch (err) {\n console.error(\"enrich-lookup failed:\", err);\n return new Response(JSON.stringify({ known: false }), { headers: cors(origin) });\n }\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",[136],"6511678d-a93c-4496-b757-90e21c120849","lookup.ts","2d97073e-a0bc-11f1-80af-1607ee4eb77e",3,["D",1787686550422],"script","// 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",[147],"c1979783-7f43-410c-8c54-06273eee6fad","enrich.ts","a7465ac4-a0cd-11f1-88e7-1607ee4eb77e",18,["D",1787694449968],2,"// 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 if (found.sfStatus) attrs[\"sf-status\"] = found.sfStatus;\n if (found.sfAccount) attrs[\"sf-account\"] = found.sfAccount;\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 if (changed && found.phone && !looked) resolve(found.phone);\n }\n\n // Resolve the phone to a Salesforce account once per conversation and stamp\n // the result for the agent. The endpoint returns only \"known\" plus the\n // account name — never a delivery date, address, or record id.\n var looked = false;\n function resolve(phone) {\n looked = true;\n var u = \"__BASE__/enrich-lookup?phone=\" + encodeURIComponent(phone.replace(/\\D/g, \"\"));\n fetch(u, { credentials: \"omit\" })\n .then(function (r) { return r.ok ? r.json() : null; })\n .then(function (j) {\n if (!j) return;\n if (j.ambiguous) {\n found.sfStatus = \"existing customer - multiple accounts\";\n } else if (j.known) {\n found.sfStatus = \"existing customer\";\n if (j.account_name) found.sfAccount = j.account_name;\n } else {\n found.sfStatus = \"no account match\";\n }\n apply();\n })\n .catch(function () { looked = false; /* allow a retry on the next message */ });\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","db.ts","01a03a6b-1697-71fe-a680-fddd67ed3651",14,["D",1787694405142],"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",[163],"2eadb934-c3dd-46da-aef6-23012980f565",["D",1787694504963],4,[28],"pulls","branches",1,"forks","envVars",{"_181":159,"_183":175},"connections",{"_181":62,"_182":62},"count","unfilledCount","emptyCount",{"_42":169,"_32":28,"_30":31,"_137":-5,"_40":41,"_39":14,"_139":58,"_37":202,"_13":171,"_33":20,"_34":36,"_24":25,"_144":-5,"_190":203,"_27":204},{"_42":162,"_32":163,"_30":164,"_137":-5,"_40":41,"_39":165,"_139":58,"_37":199,"_13":159,"_33":151,"_34":167,"_24":25,"_144":-5,"_190":200,"_27":201},{"_42":154,"_32":155,"_30":156,"_137":-5,"_40":41,"_39":157,"_139":25,"_37":196,"_13":159,"_33":151,"_34":160,"_24":25,"_144":-5,"_190":197,"_27":198},{"_42":146,"_32":147,"_30":148,"_137":-5,"_40":41,"_39":149,"_139":58,"_37":193,"_13":62,"_33":151,"_34":152,"_24":25,"_144":-5,"_190":194,"_27":195},{"_42":135,"_32":136,"_30":56,"_137":-5,"_40":41,"_39":138,"_139":25,"_37":189,"_13":141,"_33":142,"_34":143,"_24":25,"_144":44,"_190":191,"_27":192},["D",1787694455941],"children",[],[136],["D",1787686550422],[],[147],["D",1787694449968],[],[155],["D",1787694405142],[],[163],["D",1787694504963],[],[28],["D",1787686491713],["D",1789438866375],{"_99":98,"_107":103},{"_99":98,"_100":101,"_102":103,"_18":54,"_104":105,"_106":25},{"_13":88,"_32":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"ctx",{"_81":-5,"_127":243,"_244":245,"_246":247,"_248":25,"_249":25,"_250":25,"_251":58,"_252":-5,"_253":-7,"_254":-7,"_255":62,"_256":25,"_257":25,"_258":-5,"_259":25,"_260":25,"_261":25,"_262":-5},"ENV",{"_214":215,"_216":217,"_218":89,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242},"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 · v20