[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_204":205,"_206":207},"routes/_app.x.$handle.$name",{"_98":97,"_32":44,"_107":88,"_27":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":26,"_122":123,"_124":24,"_125":-5,"_126":-5,"_127":128},"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":26,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":24,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":26},"version",6,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":26,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":26},"previous","deleted",true,"deletedHere",false,"path","_test.ts","latestPath","fileId","61907f20-a0bc-11f1-886c-1607ee4eb77e","name","fileType","http","content","// Temporary: exercise parsing + scraping without needing a signed webhook.\n// Delete after use.\nimport { parseEvent } from \"./main.ts\";\nimport { findInSalesforce, scrapeContact } from \"./lookup.ts\";\n\nconst PAYLOAD = {\n event: \"chat:transcript_created\",\n time: \"2026-08-25T18:01:00.000Z\",\n domain: \"tribecabeverage.com\",\n referrer: \"https://tribecabeverage.com/water-delivery\",\n chat: {\n id: \"V1787679305943806\",\n visitor: { name: \"\", city: \"Cedar Grove\", country: \"US\" },\n messages: [\n { sender: { t: \"v\" }, type: \"msg\", msg: \"cedar grove\", time: \"2026-08-25T18:01:00Z\" },\n { sender: { t: \"v\" }, type: \"msg\", msg: \"i am a business\", time: \"2026-08-25T18:01:12Z\" },\n { sender: { t: \"s\" }, type: \"msg\", msg: \"Michael has joined the conversation.\", time: \"2026-08-25T18:01:20Z\" },\n {\n sender: { t: \"a\", n: \"Michael\" },\n type: \"msg\",\n msg: \"Hi there! Yes we service all of CG and all commercial accounts. Call us at 973-913-4568 or info@tribecabeverage.com\",\n time: \"2026-08-25T18:01:30Z\",\n },\n { sender: { t: \"v\" }, type: \"msg\", msg: \"great, reach me at 201-555-0147 or dana@acmedeli.com\", time: \"2026-08-25T18:02:00Z\" },\n ],\n },\n property: { id: \"5a57beb3d7591465c706a9d3\", name: \"TriBeCa Beverage\" },\n};\n\nexport default async function () {\n const parsed = parseEvent(PAYLOAD.event, PAYLOAD);\n if (!parsed) return Response.json({ error: \"parseEvent returned null\" });\n const scraped = scrapeContact(parsed.visitorText);\n const match = await findInSalesforce(parsed.visitorEmail || scraped.email, scraped.phone);\n return Response.json({\n id: parsed.id,\n city: parsed.city,\n transcript: parsed.transcript.split(\"\\n\"),\n visitorOnlyText: parsed.visitorText.split(\"\\n\"),\n scraped,\n salesforce: match,\n });\n}\n","createdAt",["D",1787686637619],"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","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",{"_98":97,"_106":102},"org",{"_98":97,"_99":100,"_101":102,"_18":54,"_103":104,"_105":26},"branch",{"_13":87,"_32":88,"_42":41,"_89":43,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":44,"_96":97},"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":199,"_46":-5,"_47":26,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":24,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":200,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":201,"_82":202,"_84":203,"_86":26},"tree",[178,179,180,181,182],"files",[178,179,180,181,182],"counts",{"_168":61,"_169":156,"_170":61,"_171":172,"_173":174},"contents",[129,130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":162,"_32":163,"_30":164,"_136":-5,"_40":41,"_39":156,"_138":26,"_37":165,"_13":61,"_33":20,"_35":166,"_23":26,"_142":-5,"_27":167},{"_42":159,"_32":28,"_30":31,"_136":-5,"_40":41,"_39":14,"_138":26,"_37":160,"_13":61,"_33":34,"_35":36,"_23":26,"_142":-5,"_27":161},{"_42":152,"_32":153,"_30":154,"_136":-5,"_40":41,"_39":140,"_138":26,"_37":155,"_13":156,"_33":149,"_35":157,"_23":26,"_142":-5,"_27":158},{"_42":144,"_32":145,"_30":146,"_136":-5,"_40":41,"_39":147,"_138":24,"_37":148,"_13":61,"_33":149,"_35":150,"_23":26,"_142":-5,"_27":151},{"_42":134,"_32":135,"_30":56,"_136":-5,"_40":41,"_39":137,"_138":26,"_37":139,"_13":140,"_33":34,"_35":141,"_23":26,"_142":44,"_27":143},"c9e6476d-6c1e-4a0c-9298-6f0b12f1ae3d","main.ts","parentId",5,"latest",["D",1787686625051],2,"// 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\";\n\nexport default async function (req: Request): Promise {\n const url = new URL(req.url);\n if (req.method === \"POST\") return receive(req);\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",[135],"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",[145],"68f47b0c-a563-4877-af4b-046657ddda07","db.ts","01a03a6b-1697-71fe-a680-fddd67ed3651",["D",1787686529329],1,"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",[153],"ff1500e5-070f-487a-bee5-0527a35fa5f6",["D",1787686637619],[28],"47d8b4df-3e1b-4bc0-84f0-08639fec36e6","README.md","01a03a6b-1697-71fe-a680-fa2e6414fd9f",["D",1787686491713],"# Where should I host a Stripe webhook receiver?\n\nHost it on Val Town — this val is a ready-made receiver. It verifies the `Stripe-Signature` header against your webhook signing secret, stores each event (id, type, created, full JSON) in this val's SQLite database in a `stripe_events` table, and returns 200 immediately. Duplicate deliveries of the same event id are ignored.\n\n## Setup\n\n1. Remix this val.\n2. In the Stripe dashboard, add a webhook endpoint pointing at this val's HTTP URL: https://dashboard.stripe.com/webhooks/create\n3. Copy that endpoint's signing secret (starts with `whsec_`) and set it as an env var:\n\n👉 Add STRIPE_WEBHOOK_SECRET here: https://www.val.town/x/templates/stripe-webhook-receiver/environment-variables?key=STRIPE_WEBHOOK_SECRET\n\n## Test it\n\nSend a correctly signed fake event with curl (uses the same HMAC-SHA256 scheme as Stripe):\n\n```sh\nURL=\"https://templates--019eb3e79454748cb661151a775d952d.web.val.run\"\nSECRET=\"whsec_...\" # your STRIPE_WEBHOOK_SECRET value\nTS=$(date +%s)\nBODY='{\"id\":\"evt_test_123\",\"object\":\"event\",\"type\":\"payment_intent.succeeded\",\"created\":'$TS',\"data\":{\"object\":{}}}'\nSIG=$(printf '%s' \"$TS.$BODY\" | openssl dgst -sha256 -hmac \"$SECRET\" | awk '{print $2}')\ncurl -i -X POST \"$URL\" \\\n -H \"Content-Type: application/json\" \\\n -H \"Stripe-Signature: t=$TS,v1=$SIG\" \\\n -d \"$BODY\"\n```\n\nExpect `{\"received\":true}` and a new row in `stripe_events`. A request with a missing or bad signature returns 400.\n\nYou can also send a real test event: with your endpoint configured in Stripe test mode, run `stripe trigger payment_intent.succeeded` with the Stripe CLI.\n\n## Files\n\n- `main.ts` — HTTP handler: verifies the signature, saves the event, returns 200\n- `db.ts` — SQLite table setup and insert\n",[163],"pulls","branches","forks","envVars",{"_175":140,"_177":156},"connections",{"_175":61,"_176":61},"count","unfilledCount","emptyCount",{"_42":162,"_32":163,"_30":164,"_136":-5,"_40":41,"_39":156,"_138":26,"_37":196,"_13":61,"_33":20,"_35":166,"_23":26,"_142":-5,"_184":197,"_27":198},{"_42":159,"_32":28,"_30":31,"_136":-5,"_40":41,"_39":14,"_138":26,"_37":193,"_13":61,"_33":34,"_35":36,"_23":26,"_142":-5,"_184":194,"_27":195},{"_42":152,"_32":153,"_30":154,"_136":-5,"_40":41,"_39":140,"_138":26,"_37":190,"_13":156,"_33":149,"_35":157,"_23":26,"_142":-5,"_184":191,"_27":192},{"_42":144,"_32":145,"_30":146,"_136":-5,"_40":41,"_39":147,"_138":24,"_37":187,"_13":61,"_33":149,"_35":150,"_23":26,"_142":-5,"_184":188,"_27":189},{"_42":134,"_32":135,"_30":56,"_136":-5,"_40":41,"_39":137,"_138":26,"_37":183,"_13":140,"_33":34,"_35":141,"_23":26,"_142":44,"_184":185,"_27":186},["D",1787686625051],"children",[],[135],["D",1787686550422],[],[145],["D",1787686529329],[],[153],["D",1787686637619],[],[28],["D",1787686491713],[],[163],["D",1787686491713],["D",1789438866375],{"_98":97,"_106":102},{"_98":97,"_99":100,"_101":102,"_18":54,"_103":104,"_105":26},{"_13":87,"_32":88,"_42":41,"_89":43,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":44,"_96":97},"ctx",{"_80":-5,"_126":237,"_238":239,"_240":241,"_242":26,"_243":26,"_244":26,"_245":24,"_246":-5,"_247":-7,"_248":-7,"_249":61,"_250":26,"_251":26,"_252":-5,"_253":26,"_254":26,"_255":26,"_256":-5},"ENV",{"_208":209,"_210":211,"_212":88,"_213":214,"_215":216,"_217":218,"_219":220,"_221":222,"_223":224,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236},"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 · v6