[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_160":161,"_162":163},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_109":90,"_27":104,"_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":59,"_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",{"_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",9,"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","main.tsx","latestPath","fileId","6eac93de-5f84-11f1-8ea9-1607ee4eb77e","name","fileType","http","content","// Leangap — Tally → Notion arrivals & departures sync\n//\n// Flow: Tally webhook POST -> match student by email in Student List (SF)\n// -> pull source-of-truth name -> create Arrivals + Departures rows with\n// the Student relation set.\n//\n// No match -> rows are still created (without the relation) so nothing is\n// lost, AND a Slack DM is sent so you can fix the email / link manually.\n//\n// Uses Notion API 2025-09-03 (data sources).\n//\n// Env vars to set in Val Town -> Settings -> Environment Variables:\n// NOTION_TOKEN internal Notion integration secret (required)\n// SLACK_DM_CHANNEL your Slack member ID (U…) for the no-match DM (required)\n//\n// SLACK_TOKEN is injected automatically by Val Town's Slack connection — do not set it manually.\n\nimport { WebClient } from \"npm:@slack/web-api\";\n\nconst NOTION_TOKEN = Deno.env.get(\"NOTION_TOKEN\");\nconst SLACK_DM_CHANNEL = Deno.env.get(\"SLACK_DM_CHANNEL\");\nconst SLACK_TOKEN = Deno.env.get(\"SLACK_TOKEN\");\n\nconst NOTION_VERSION = \"2025-09-03\";\n\n// Data source IDs — required by Notion API 2025-09-03\nconst STUDENT_DS = \"3b9cd139-473f-4100-b5e2-e9aa69486832\";\nconst ARRIVALS_DS = \"0c73e5f4-9e2f-4e52-90ce-c5a86ab57c64\";\nconst DEPARTURES_DS = \"268eee30-2306-4f40-a54a-c2aeaad623ab\";\n\nfunction notion(path: string, method: string, body?: unknown) {\n return fetch(`https://api.notion.com/v1/${path}`, {\n method,\n headers: {\n Authorization: `Bearer ${NOTION_TOKEN}`,\n \"Notion-Version\": NOTION_VERSION,\n \"Content-Type\": \"application/json\",\n },\n body: body ? JSON.stringify(body) : undefined,\n });\n}\n\nasync function slackNotify(text: string) {\n if (!SLACK_TOKEN || !SLACK_DM_CHANNEL) {\n console.warn(\"Slack not configured; skipping alert:\", text);\n return;\n }\n try {\n const slack = new WebClient(SLACK_TOKEN);\n await slack.chat.postMessage({ channel: SLACK_DM_CHANNEL, text });\n } catch (e) {\n console.error(\"Slack notify failed\", e);\n }\n}\n\nfunction norm(s: string): string {\n return (s || \"\").replace(/&/g, \"&\").replace(/\\s+/g, \" \").trim().toLowerCase();\n}\n\nfunction buildFieldMap(fields: any[]): Record {\n const map: Record = {};\n for (const f of fields || []) {\n let value = f.value;\n if (Array.isArray(value) && Array.isArray(f.options)) {\n value = value\n .map((id: string) => f.options.find((o: any) => o.id === id)?.text ?? id)\n .join(\", \");\n } else if (Array.isArray(value)) {\n value = value.join(\", \");\n }\n map[norm(f.label)] = value == null ? \"\" : String(value);\n }\n return map;\n}\n\nconst title = (v: string) => ({ title: [{ text: { content: v || \"\" } }] });\nconst rich = (v: string) => (v ? { rich_text: [{ text: { content: v } }] } : { rich_text: [] });\nconst sel = (v: string) => (v ? { select: { name: v } } : { select: null });\nconst mail = (v: string) => (v ? { email: v } : { email: null });\n\nexport default async function (req: Request): Promise {\n if (req.method !== \"POST\") {\n return new Response(\"Leangap logistics sync — listener live\", { status: 200 });\n }\n if (!NOTION_TOKEN) {\n console.error(\"Missing NOTION_TOKEN env var\");\n return new Response(\"server not configured\", { status: 500 });\n }\n\n let payload: any;\n try {\n payload = await req.json();\n } catch {\n return new Response(\"bad json\", { status: 400 });\n }\n\n const data = payload?.data ?? {};\n const m = buildFieldMap(data.fields);\n\n const email = (m[\"student email\"] || \"\").trim();\n const tallyFirst = (m[\"student first name\"] || \"\").trim();\n const tallyLast = (m[\"student last name\"] || \"\").trim();\n\n const arriveMethod = m[\"how will the student arrive?\"] || \"\";\n const arriveAirport = m[\"arrival airport\"] || \"\";\n const arriveFlight = m[\"arrival airline & flight number\"] || \"\";\n const arriveTime = m[\"arrival time (24-hour format)\"] || \"\";\n\n const departMethod = m[\"how will the student depart?\"] || \"\";\n const departAirport = m[\"departure airport\"] || \"\";\n const departFlight = m[\"departure airline & flight number\"] || \"\";\n const departTime = m[\"departure time (24-hour format)\"] || \"\";\n\n if (!email) {\n console.warn(\"Submission has no email; skipping\", data?.submissionId);\n return new Response(JSON.stringify({ ok: false, reason: \"no email\" }), {\n status: 200,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // 1) Match student by email\n const q = await notion(`data_sources/${STUDENT_DS}/query`, \"POST\", {\n filter: { property: \"Email\", email: { equals: email } },\n page_size: 1,\n });\n const qj = await q.json();\n if (!q.ok) {\n console.error(\"Notion student query failed\", qj);\n return new Response(\"notion query error\", { status: 502 });\n }\n\n const student = qj.results?.[0];\n const tallyFull = `${tallyFirst} ${tallyLast}`.trim();\n let fullName = tallyFull;\n let studentRelation: { id: string }[] = [];\n\n if (student) {\n studentRelation = [{ id: student.id }];\n const p = student.properties || {};\n fullName = p[\"Name\"]?.title?.[0]?.plain_text || tallyFull;\n } else {\n await slackNotify(\n `:warning: *Leangap logistics — no match found*\\n` +\n `Student: *${tallyFirst} ${tallyLast}*\\n` +\n `Email submitted: \\`${email}\\`\\n` +\n `Unlinked Arrival + Departure rows were created. Fix the email on the student record or link them manually in Notion.`,\n );\n }\n\n // 2) Create Arrivals row\n const arrivalProps: Record = {\n \"Name\": title(fullName),\n \"Email\": mail(email),\n \"Method\": sel(arriveMethod),\n \"Airport\": sel(arriveAirport),\n \"Airline/Flight\": rich(arriveFlight),\n \"Date/Time\": rich(arriveTime),\n };\n if (studentRelation.length) arrivalProps[\"Student\"] = { relation: studentRelation };\n\n const aRes = await notion(\"pages\", \"POST\", {\n parent: { type: \"data_source_id\", data_source_id: ARRIVALS_DS },\n properties: arrivalProps,\n });\n if (!aRes.ok) console.error(\"Arrival create failed\", await aRes.json());\n\n // 3) Create Departures row\n const departureProps: Record = {\n \"First Name\": title(firstName),\n \"Method\": sel(departMethod),\n \"Airport\": sel(departAirport),\n \"Airline/Flight\": rich(departFlight),\n \"Date/Time\": rich(departTime),\n };\n if (studentRelation.length) departureProps[\"Student\"] = { relation: studentRelation };\n\n const dRes = await notion(\"pages\", \"POST\", {\n parent: { type: \"data_source_id\", data_source_id: DEPARTURES_DS },\n properties: departureProps,\n });\n if (!dRes.ok) console.error(\"Departure create failed\", await dRes.json());\n\n return new Response(\n JSON.stringify({\n ok: true,\n matched: !!student,\n email,\n arrivalCreated: aRes.ok,\n departureCreated: dRes.ok,\n }),\n { status: 200, headers: { \"Content-Type\": \"application/json\" } },\n );\n}\n","// Leangap — Tally → Notion arrivals & departures sync\n//\n// Flow: Tally webhook POST -> match student by email in Student List (SF)\n// -> pull source-of-truth name -> create Arrivals + Departures rows with\n// the Student relation set.\n//\n// No match -> rows are still created (without the relation) so nothing is\n// lost, AND a Slack DM is sent so you can fix the email / link manually.\n//\n// Uses Notion API 2025-09-03 (data sources).\n//\n// Env vars to set in Val Town -> Settings -> Environment Variables:\n// NOTION_TOKEN internal Notion integration secret (required)\n// SLACK_DM_CHANNEL your Slack member ID (U…) for the no-match DM (required)\n//\n// SLACK_TOKEN is injected automatically by Val Town's Slack connection — do not set it manually.\n\nimport { WebClient } from \"npm:@slack/web-api\";\n\nconst NOTION_TOKEN = Deno.env.get(\"NOTION_TOKEN\");\nconst SLACK_DM_CHANNEL = Deno.env.get(\"SLACK_DM_CHANNEL\");\nconst SLACK_TOKEN = Deno.env.get(\"SLACK_TOKEN\");\n\nconst NOTION_VERSION = \"2025-09-03\";\n\n// Data source IDs — required by Notion API 2025-09-03\nconst STUDENT_DS = \"3b9cd139-473f-4100-b5e2-e9aa69486832\";\nconst ARRIVALS_DS = \"0c73e5f4-9e2f-4e52-90ce-c5a86ab57c64\";\nconst DEPARTURES_DS = \"268eee30-2306-4f40-a54a-c2aeaad623ab\";\n\nfunction notion(path: string, method: string, body?: unknown) {\n return fetch(`https://api.notion.com/v1/${path}`, {\n method,\n headers: {\n Authorization: `Bearer ${NOTION_TOKEN}`,\n \"Notion-Version\": NOTION_VERSION,\n \"Content-Type\": \"application/json\",\n },\n body: body ? JSON.stringify(body) : undefined,\n });\n}\n\nasync function slackNotify(text: string) {\n if (!SLACK_TOKEN || !SLACK_DM_CHANNEL) {\n console.warn(\"Slack not configured; skipping alert:\", text);\n return;\n }\n try {\n const slack = new WebClient(SLACK_TOKEN);\n await slack.chat.postMessage({ channel: SLACK_DM_CHANNEL, text });\n } catch (e) {\n console.error(\"Slack notify failed\", e);\n }\n}\n\nfunction norm(s: string): string {\n return (s || \"\").replace(/&/g, \"&\").replace(/\\s+/g, \" \").trim().toLowerCase();\n}\n\nfunction buildFieldMap(fields: any[]): Record {\n const map: Record = {};\n for (const f of fields || []) {\n let value = f.value;\n if (Array.isArray(value) && Array.isArray(f.options)) {\n value = value\n .map((id: string) => f.options.find((o: any) => o.id === id)?.text ?? id)\n .join(\", \");\n } else if (Array.isArray(value)) {\n value = value.join(\", \");\n }\n map[norm(f.label)] = value == null ? \"\" : String(value);\n }\n return map;\n}\n\nconst title = (v: string) => ({ title: [{ text: { content: v || \"\" } }] });\nconst rich = (v: string) => (v ? { rich_text: [{ text: { content: v } }] } : { rich_text: [] });\nconst sel = (v: string) => (v ? { select: { name: v } } : { select: null });\nconst mail = (v: string) => (v ? { email: v } : { email: null });\n\nexport default async function (req: Request): Promise {\n if (req.method !== \"POST\") {\n return new Response(\"Leangap logistics sync — listener live\", { status: 200 });\n }\n if (!NOTION_TOKEN) {\n console.error(\"Missing NOTION_TOKEN env var\");\n return new Response(\"server not configured\", { status: 500 });\n }\n\n let payload: any;\n try {\n payload = await req.json();\n } catch {\n return new Response(\"bad json\", { status: 400 });\n }\n\n const data = payload?.data ?? {};\n const m = buildFieldMap(data.fields);\n\n const email = (m[\"student email\"] || \"\").trim();\n const tallyFirst = (m[\"student first name\"] || \"\").trim();\n const tallyLast = (m[\"student last name\"] || \"\").trim();\n\n const arriveMethod = m[\"how will the student arrive?\"] || \"\";\n const arriveAirport = m[\"arrival airport\"] || \"\";\n const arriveFlight = m[\"arrival airline & flight number\"] || \"\";\n const arriveTime = m[\"arrival time (24-hour format)\"] || \"\";\n\n const departMethod = m[\"how will the student depart?\"] || \"\";\n const departAirport = m[\"departure airport\"] || \"\";\n const departFlight = m[\"departure airline & flight number\"] || \"\";\n const departTime = m[\"departure time (24-hour format)\"] || \"\";\n\n if (!email) {\n console.warn(\"Submission has no email; skipping\", data?.submissionId);\n return new Response(JSON.stringify({ ok: false, reason: \"no email\" }), {\n status: 200,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n // 1) Match student by email\n const q = await notion(`data_sources/${STUDENT_DS}/query`, \"POST\", {\n filter: { property: \"Email\", email: { equals: email } },\n page_size: 1,\n });\n const qj = await q.json();\n if (!q.ok) {\n console.error(\"Notion student query failed\", qj);\n return new Response(\"notion query error\", { status: 502 });\n }\n\n const student = qj.results?.[0];\n const tallyFull = `${tallyFirst} ${tallyLast}`.trim();\n let fullName = tallyFull;\n let studentRelation: { id: string }[] = [];\n\n if (student) {\n studentRelation = [{ id: student.id }];\n const p = student.properties || {};\n fullName = p[\"Name\"]?.title?.[0]?.plain_text || tallyFull;\n } else {\n await slackNotify(\n `:warning: *Leangap logistics — no match found*\\n` +\n `Student: *${tallyFirst} ${tallyLast}*\\n` +\n `Email submitted: \\`${email}\\`\\n` +\n `Unlinked Arrival + Departure rows were created. Fix the email on the student record or link them manually in Notion.`,\n );\n }\n\n // 2) Create Arrivals row\n const arrivalProps: Record = {\n \"Name\": title(fullName),\n \"Email\": mail(email),\n \"Method\": sel(arriveMethod),\n \"Airport\": sel(arriveAirport),\n \"Airline/Flight\": rich(arriveFlight),\n \"Date/Time\": rich(arriveTime),\n };\n if (studentRelation.length) arrivalProps[\"Student Relation\"] = { relation: studentRelation };\n\n const aRes = await notion(\"pages\", \"POST\", {\n parent: { type: \"data_source_id\", data_source_id: ARRIVALS_DS },\n properties: arrivalProps,\n });\n if (!aRes.ok) console.error(\"Arrival create failed\", await aRes.json());\n\n // 3) Create Departures row\n const departureProps: Record = {\n \"First Name\": title(firstName),\n \"Method\": sel(departMethod),\n \"Airport\": sel(departAirport),\n \"Airline/Flight\": rich(departFlight),\n \"Date/Time\": rich(departTime),\n };\n if (studentRelation.length) departureProps[\"Student\"] = { relation: studentRelation };\n\n const dRes = await notion(\"pages\", \"POST\", {\n parent: { type: \"data_source_id\", data_source_id: DEPARTURES_DS },\n properties: departureProps,\n });\n if (!dRes.ok) console.error(\"Departure create failed\", await dRes.json());\n\n return new Response(\n JSON.stringify({\n ok: true,\n matched: !!student,\n email,\n arrivalCreated: aRes.ok,\n departureCreated: dRes.ok,\n }),\n { status: 200, headers: { \"Content-Type\": \"application/json\" } },\n );\n}\n","createdAt",["D",1780551172023],"branchVersion","branchId","6ea9e81e-5f84-11f1-8ea9-1607ee4eb77e","id","6ea94daa-5f84-11f1-8ea9-1607ee4eb77e","logistics-sync",["D",1780515782210],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Form to Notion sync","imageUrl","57b8f323-328a-47b3-86c3-c762ebff5f42","pinnedFileId","10db2ebc-692c-11f1-8ac0-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019e8ef8-82d4-720f-b07f-808c7f165c8a","tursoName","6ea94daa5f8411f18ea91607ee4eb77e","tursoHostname","6ea94daa5f8411f18ea91607ee4eb77e-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789512647429],"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",67,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","sadok","handle","displayName","Sadok Cervantes","avatar","","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":155,"_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":156,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":157,"_84":158,"_86":159,"_88":25},"tree",[150],"files",[150],"counts",{"_138":63,"_139":140,"_141":63,"_142":143,"_144":145},"contents",[130],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":131,"_32":28,"_30":31,"_132":-5,"_41":42,"_40":14,"_133":25,"_38":134,"_13":135,"_33":34,"_35":37,"_24":25,"_136":-5,"_27":137},"d0974562-36c5-4c84-a5a7-48bd2a46a099","parentId","latest",["D",1780551172023],8,"label",[28],"pulls","branches",1,"forks","envVars",{"_146":148,"_149":63},"connections",{"_146":140,"_147":63},"count","unfilledCount",7,"emptyCount",{"_43":131,"_32":28,"_30":31,"_132":-5,"_41":42,"_40":14,"_133":25,"_38":151,"_13":135,"_33":34,"_35":37,"_24":25,"_136":-5,"_152":153,"_27":154},["D",1780551172023],"children",[],[28],["D",1780515782210],["D",1789512647429],{"_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,"_127":193,"_194":195,"_196":197,"_198":25,"_199":25,"_200":25,"_201":59,"_202":-5,"_203":-7,"_204":-7,"_205":63,"_206":25,"_207":25,"_208":-5,"_209":25,"_210":25,"_211":25,"_212":-5},"ENV",{"_164":165,"_166":167,"_168":90,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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 · v9