[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_170":171,"_172":173},"routes/_app.x.$handle.$name",{"_105":104,"_38":50,"_114":95,"_33":115,"_13":14,"_116":-5,"_11":117,"_118":119,"_120":121,"_122":123,"_124":125,"_26":-5,"_126":-5,"_127":-5,"_128":54,"_129":130,"_131":31,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_48":49,"_38":50,"_43":51,"_52":-5,"_53":54,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":63,"_64":31,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":54},"version",25,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","06b86a9c-bc9e-4b54-971b-9228cdaa6883","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":40,"_41":42,"_43":44,"_45":14,"_46":47,"_30":31},"previous",{"_36":37,"_38":34,"_39":40,"_41":42},"deleted",true,"deletedHere","path","check_field.ts","latestPath","fileId","403b17f4-9d3d-11f1-9f71-1607ee4eb77e","name","fileType","script","content","// TEMP: inspect Jitbit custom fields, esp. 71440 (\"Formation\")\nconst JITBIT_URL = Deno.env.get(\"JITBIT_URL\") ?? \"\";\nconst TOKEN = Deno.env.get(\"JITBIT_TOKEN\") ?? \"\";\nconst headers = { Accept: \"application/json\", Authorization: `Bearer ${TOKEN}` };\n\n// types: 1=ticket? users=2, assets=4 ... fetch all and find 71440\nfor (const t of [1, 2, 3, 4]) {\n try {\n const r = await fetch(`${JITBIT_URL}/CustomFields?type=${t}`, { headers });\n const j = await r.json();\n const arr = Array.isArray(j) ? j : j?.items ?? j?.customFields ?? [];\n const found = arr.filter((f: any) => String(f.FieldID ?? f.id) === \"71440\");\n console.log(`type=${t} status=${r.status} count=${Array.isArray(arr) ? arr.length : \"?\"}`);\n if (found.length) {\n console.log(\"=== FIELD 71440 ===\", JSON.stringify(found, null, 2));\n console.log(\"=== ALL FIELDS sample ===\", JSON.stringify(arr.slice(0, 5), null, 2));\n }\n } catch (e) {\n console.log(`type=${t} error ${e}`);\n }\n}\n\n// Also fetch user's own custom fields to see shapes\ntry {\n const r = await fetch(`${JITBIT_URL}/UserCustomFields?id=16762023`, { headers });\n console.log(`UserCustomFields -> ${r.status}: ${await r.text()}`);\n} catch (e) {\n console.log(\"UserCustomFields error\", e);\n}\n","createdAt",["D",1787302232418],"branchVersion","branchId","0ef73d21-4b68-41b5-b73f-bcbf14e61c4a","id","b4f42f7a-6374-4579-848a-7b9645377530","jitbit-alumnforce-augment",["D",1787299615803],"deletedAt","legacyEnvVars",false,"privacy","public","httpPrivacy","description","Augment Jitbit user profiles from Alumnforce on new ticket","imageUrl","f333b48a-d1df-40f6-b81a-0a4eedb2118d","pinnedFileId","4d70be8e-9d37-11f1-9025-1607ee4eb77e","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a0235b-1cb1-7095-980f-faee7bf724ac","tursoName","b4f42f7a63744579848a7b9645377530","tursoHostname","b4f42f7a63744579848a7b9645377530-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789563628475],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_105":104,"_113":109},"org",{"_105":104,"_106":107,"_108":109,"_19":61,"_110":111,"_112":54},"branch",{"_13":94,"_38":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"isOwned",40,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","theophilec","handle","displayName","Théophile Cantelobre","avatar","https://avatars.githubusercontent.com/u/11165990?v=4","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_38":50,"_43":165,"_52":-5,"_53":54,"_55":56,"_57":56,"_58":59,"_60":-5,"_19":61,"_62":63,"_64":31,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":166,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":167,"_89":168,"_91":169,"_93":54},"tree",[160],"files",[160],"counts",{"_148":68,"_149":150,"_151":68,"_152":153,"_154":155},"contents",[136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_48":137,"_38":138,"_36":63,"_139":-5,"_46":47,"_45":140,"_141":54,"_43":142,"_13":143,"_39":144,"_41":145,"_30":54,"_146":-5,"_33":147},"3a024f3b-ad6b-492b-b881-195e96d47fcf","main.ts","parentId",22,"latest",["D",1787302229042],12,"http","/**\n * Jitbit -> Alumnforce personal-info augmenter.\n *\n * Triggered by a Jitbit webhook (Automation Rule) on new tickets in a category.\n * We rely ONLY on #ticketId#, and pull everything else from the Jitbit API.\n *\n * Flow:\n * 1. Jitbit POSTs { ticketId, category } to this val\n * 2. GET {JITBIT_URL}/ticket?id={ticketId}\n * -> requester email + user ID from SubmitterUserInfo\n * (optional) bail unless the ticket category matches JITBIT_CATEGORIES\n * 3. GET {AF}/api/v2/customer/profile/people/?search={email}\n * -> no match: stop here\n * -> match: take person id\n * 4. GET {AF}/api/v2/customer/profile/people/{id}\n * -> profile detail (civil.firstname/lastname, experience.mobile/phone)\n * 5. POST {JITBIT_URL}/UpdateUser?userId=... -> fill the MISSING personal fields:\n * firstName, lastName, phone (requester email is kept as-is)\n *\n * We deliberately map ONLY personal information (first name, last name, phone)\n * and never touch the requester's email or company/job fields.\n *\n * Env vars:\n * JITBIT_URL e.g. https://company.jitbit.com/helpdesk/api\n * JITBIT_USERNAME helpdesk admin account (read ticket + UpdateUser need admin)\n * JITBIT_PASSWORD its password\n * JITBIT_CATEGORIES optional comma-separated category names to process\n * ALUMNFORCE_URL e.g. https://mines-paris.org\n * ALUMNFORCE_ACCESS_ID Access id (Basic auth, with grant_type=client_credentials)\n * ALUMNFORCE_ACCESS_SECRET Access secret\n * ALUMNFORCE_API_KEY optional Bearer token; used if access id/secret absent\n *\n * Until JITBIT_PASSWORD and an Alumnforce credential are set, the val runs\n * against stub data so the pipeline is visible end-to-end in the logs.\n */\n\n// ---------------- Configuration ----------------\nconst JITBIT_URL = Deno.env.get(\"JITBIT_URL\") ?? \"https://your.jitbit.com/helpdesk/api\";\nconst JITBIT_TOKEN = Deno.env.get(\"JITBIT_TOKEN\") ?? \"\";\nconst JITBIT_USERNAME = Deno.env.get(\"JITBIT_USERNAME\") ?? \"\";\nconst JITBIT_PASSWORD = Deno.env.get(\"JITBIT_PASSWORD\") ?? \"\";\nconst JITBIT_CATEGORIES = Deno.env.get(\"JITBIT_CATEGORIES\") ?? \"\";\n\nconst AF_URL = (Deno.env.get(\"ALUMNFORCE_URL\") ?? \"https://mines-paris.org\").replace(/\\/$/, \"\");\nconst AF_ACCESS_ID = Deno.env.get(\"ALUMNFORCE_ACCESS_ID\") ?? \"\";\nconst AF_ACCESS_SECRET = Deno.env.get(\"ALUMNFORCE_ACCESS_SECRET\") ?? \"\";\nconst AF_BEARER = Deno.env.get(\"ALUMNFORCE_API_KEY\") ?? \"\";\n\nconst PEOPLE = \"/api/v2/customer/profile/people\";\n\nexport default async function handler(req: Request): Promise {\n if (req.method === \"GET\") {\n return json({ ok: true, hint: \"POST { ticketId, category }. Only #ticketId# is needed — email is resolved from the Jitbit API.\" });\n }\n\n // ----- 1. Parse the webhook payload (form-encoded or JSON) -----\n const body = await parseBody(req);\n const ticketId = body.ticketId ?? body.ticket_id ?? body.id;\n const category = body.category ?? body.categoryName;\n if (!ticketId) return json({ ok: false, error: \"Missing ticketId\" }, 400);\n console.log(`Hook received: ticket #${ticketId}${category ? ` (${category})` : \"\"}`);\n\n // Optional category filter\n const allowed = JITBIT_CATEGORIES.split(\",\").map((s) => s.trim()).filter(Boolean);\n if (allowed.length && (!category || !allowed.includes(category))) {\n console.log(`Skipping: category \"${category}\" not in allowed list`);\n return json({ ok: true, augmented: false, reason: \"category_not_allowed\" });\n }\n\n try {\n // ----- 2. Resolve requester email/user from the Jitbit ticket -----\n const ticket = await jitbitTicket(ticketId);\n const userInfo = ticket.SubmitterUserInfo ?? {};\n const email = ticket.Email ?? userInfo.Email ?? userInfo.username;\n const userId = ticket.UserID ?? userInfo.UserID;\n if (!email) return json({ ok: false, error: \"Could not determine requester email for ticket\" }, 500);\n console.log(`Ticket #${ticketId}: user #${userId}, email ${email} (kept as-is)`);\n\n // ----- 3+4. Look up the alumnus in Alumnforce and fetch profile detail -----\n const person = await alumnforcePerson(email);\n if (!person) {\n console.log(`No Alumnforce match for ${email} — stopping`);\n return json({ ok: true, augmented: false, reason: \"no_alumnforce_match\", email });\n }\n\n // ----- 5. Fill missing personal fields (name + phone) in Jitbit -----\n const result = await augmentJitbitUser(userId, person);\n return json({ ok: true, augmented: true, email, person, result });\n } catch (err) {\n console.error(\"Augment failed:\", String(err));\n return json({ ok: false, error: String(err) }, 500);\n }\n}\n\n// ---------------- Jitbit ----------------\n\nfunction jitbitConfigured(): boolean {\n return Boolean(JITBIT_TOKEN || (JITBIT_USERNAME && JITBIT_PASSWORD));\n}\n\nfunction jitbitHeaders(): Record {\n const h: Record = { \"Content-Type\": \"application/x-www-form-urlencoded\" };\n h.Authorization = JITBIT_TOKEN\n ? `Bearer ${JITBIT_TOKEN}`\n : \"Basic \" + btoa(`${JITBIT_USERNAME}:${JITBIT_PASSWORD}`);\n return h;\n}\n\n/** GET {JITBIT_URL}/ticket?id=... -> ticket with SubmitterUserInfo. */\nasync function jitbitTicket(ticketId: string) {\n if (!jitbitConfigured()) {\n return {\n TicketID: Number(ticketId),\n Email: \"stub@example.com\",\n UserID: 7,\n SubmitterUserInfo: { UserID: 7, Email: \"stub@example.com\" },\n };\n }\n const res = await fetch(`${JITBIT_URL}/ticket?id=${encodeURIComponent(String(ticketId))}`, { headers: jitbitHeaders() });\n if (!res.ok) throw new Error(`Jitbit ticket ${res.status}: ${await res.text()}`);\n return (await res.json()) as any;\n}\n\n/** GET {JITBIT_URL}/User?userId=... -> current Jitbit user profile. */\nasync function jitbitUser(userId: string) {\n const res = await fetch(`${JITBIT_URL}/User?userId=${encodeURIComponent(String(userId))}`, { headers: jitbitHeaders() });\n if (!res.ok) throw new Error(`Jitbit user ${res.status}: ${await res.text()}`);\n return (await res.json()) as any;\n}\n\n/**\n * Fill only the MISSING personal fields from the Alumnforce profile detail.\n * firstName / lastName / phone. Requester email is never overwritten.\n * POST {JITBIT_URL}/UpdateUser?userId=... (form fields, requires admin).\n */\nasync function augmentJitbitUser(userId: string, person: any) {\n if (!jitbitConfigured()) {\n console.log(\"Jitbit creds not set — simulating update for user\", userId, \"with\", person);\n return { skipped: true, fields: person };\n }\n\n const current = await jitbitUser(String(userId));\n\n // Values to fill; \"\" means \"no value from Alumnforce\"\n const map: Record = {\n firstName: { value: person.firstName ?? \"\", currentKey: \"FirstName\" },\n lastName: { value: person.lastName ?? \"\", currentKey: \"LastName\" },\n phone: { value: person.phone ?? \"\", currentKey: \"Phone\" },\n };\n\n const fields: Record = { userId: String(userId) };\n for (const [key, { value, currentKey }] of Object.entries(map)) {\n const v = String(value ?? \"\").trim();\n const cur = current?.[currentKey];\n if (v && !cur) fields[key] = v; // only fill empty Jitbit fields\n }\n\n // ----- Custom fields -----\n // \"Formation\" (field 71440, text) gets the promo, formatted as \"P YYYY\".\n const FORMATION_FIELD_ID = 71440;\n let customFields: Record = {};\n if (person?.promo) {\n customFields = await setUserCustomField(String(userId), FORMATION_FIELD_ID, `P ${person.promo}`);\n }\n\n const hasNameFields = Object.keys(fields).length > 1;\n if (!hasNameFields && Object.keys(customFields).length === 0) {\n console.log(`User ${userId}: nothing to fill`);\n return { skipped: true, reason: \"nothing_to_fill\" };\n }\n\n let result: { skipped: boolean; fields: Record; customFields: Record };\n if (hasNameFields) {\n const res = await fetch(`${JITBIT_URL}/UpdateUser`, {\n method: \"POST\",\n headers: jitbitHeaders(),\n body: new URLSearchParams(fields).toString(),\n });\n if (!res.ok) throw new Error(`Jitbit UpdateUser ${res.status}: ${await res.text()}`);\n console.log(`Updated user ${userId} with`, fields);\n result = { skipped: false, fields, customFields };\n } else {\n result = { skipped: false, fields, customFields };\n }\n return result;\n}\n\n/** POST {JITBIT_URL}/SetCustomFieldForUser?id=...&fieldId=...&value=... */\nasync function setUserCustomField(userId: string, fieldId: number, value: string): Promise> {\n const res = await fetch(`${JITBIT_URL}/SetCustomFieldForUser`, {\n method: \"POST\",\n headers: { ...jitbitHeaders(), Accept: \"application/json\" },\n body: `id=${encodeURIComponent(userId)}&fieldId=${fieldId}&value=${encodeURIComponent(value)}`,\n });\n if (!res.ok) throw new Error(`SetCustomFieldForUser ${res.status}: ${await res.text()}`);\n console.log(`Set user ${userId} custom field ${fieldId} = \"${value}\"`);\n return { [`field_${fieldId}`]: value };\n}\n\n// ---------------- Alumnforce ----------------\n\nfunction afConfigured(): boolean {\n return Boolean(AF_BEARER || (AF_ACCESS_ID && AF_ACCESS_SECRET));\n}\n\nfunction afHeaders(): Record {\n const h: Record = { Accept: \"application/json\" };\n if (AF_BEARER) h.Authorization = `Bearer ${AF_BEARER}`;\n else h.Authorization = \"Basic \" + btoa(`${AF_ACCESS_ID}:${AF_ACCESS_SECRET}`);\n return h;\n}\n\nasync function afGet(path: string) {\n if (!afConfigured()) return null; // signal \"use stub\"\n const grant = AF_BEARER ? \"\" : \"&grant_type=client_credentials\";\n const res = await fetch(`${AF_URL}${path}${grant}`, { headers: afHeaders() });\n if (res.status === 404) return null;\n if (!res.ok) {\n const txt = await res.text().catch(() => \"\");\n throw new Error(`Alumnforce ${res.status}: ${txt.slice(0, 300)}`);\n }\n return await res.json();\n}\n\n/**\n * Search Alumnforce by email, then fetch the full profile detail for the match.\n * Returns { id, firstName, lastName, phone } or null when there's no match.\n */\nasync function alumnforcePerson(email: string) {\n if (!afConfigured()) {\n // Stub so the flow is visible end-to-end before a real credential is set.\n return { id: \"999\", firstName: \"Ada\", lastName: \"Lovelace\", phone: \"+33 6 00 00 00 00\" };\n }\n\n // 3. Search by email\n const list = await afGet(`${PEOPLE}/?search=${encodeURIComponent(email)}`);\n const items = list?._embedded?.items ?? [];\n if (!items.length) return null;\n const personId = items[0].id;\n if (!personId) return null;\n\n // 4. Full profile detail\n const p = await afGet(`${PEOPLE}/${encodeURIComponent(String(personId))}`);\n if (!p) return null;\n\n // Name lives under _embedded.civil; phone under _embedded.address[] (primary).\n const civil = p?._embedded?.civil ?? {};\n const addr = (p?._embedded?.address ?? []).find((a: any) => a.type === \"primary\") ?? {};\n // Promo / graduation year from the latest diploma, e.g. \"2005-01-01\" -> \"2005\"\n const grad = firstReal(p?._embedded?.latest_diploma?.graduation);\n const promo = /^(\\d{4})/.exec(grad)?.[1] ?? \"\";\n\n return {\n id: personId,\n firstName: firstReal(civil.firstname),\n lastName: firstReal(civil.lastname),\n phone: firstReal(\n joinPhone(addr.mobile_prefix, addr.mobile),\n joinPhone(addr.phone_prefix, addr.phone),\n firstReal(addr.landline),\n ),\n promo,\n };\n}\n\n/** Join a prefix like \"+33\" with a number like \"6 86 14 26 31\" => \"+33 6 86 14 26 31\". */\nfunction joinPhone(prefix: any, number: any): string {\n const p = String(prefix ?? \"\").trim();\n const n = String(number ?? \"\").trim();\n if (!n) return \"\";\n return p && !n.startsWith(p) ? `${p} ${n}` : n;\n}\n\nfunction firstReal(...vals: any[]): string {\n for (const v of vals) {\n if (v === null || v === undefined) continue;\n if (typeof v === \"number\" && Number.isNaN(v)) continue;\n const s = String(v).trim();\n if (s && s.toLowerCase() !== \"null\" && s !== \"0\" && s.toLowerCase() !== \"nan\") return s;\n }\n return \"\";\n}\n\n// ---------------- helpers ----------------\n\nasync function parseBody(req: Request): Promise> {\n try {\n const ct = (req.headers.get(\"content-type\") ?? \"\").toLowerCase();\n if (ct.includes(\"application/json\")) return (await req.json()) ?? {};\n const text = await req.text();\n if (!text) return {};\n const trimmed = text.trimStart();\n if (trimmed.startsWith(\"{\")) return JSON.parse(trimmed);\n const params = new URLSearchParams(text);\n const out: Record = {};\n for (const [k, v] of params.entries()) out[k] = v;\n return out;\n } catch {\n return {};\n }\n}\n\nfunction json(data: any, status = 200) {\n return new Response(JSON.stringify(data, null, 2), { status, headers: { \"Content-Type\": \"application/json\" } });\n}\n","label",[138],"pulls","branches",1,"forks","envVars",{"_156":158,"_159":68},"connections",{"_156":68,"_157":68},"count","unfilledCount",5,"emptyCount",{"_48":137,"_38":138,"_36":63,"_139":-5,"_46":47,"_45":140,"_141":54,"_43":161,"_13":143,"_39":144,"_41":145,"_30":54,"_146":-5,"_162":163,"_33":164},["D",1787302229042],"children",[],[138],["D",1787299615803],["D",1789563628475],{"_105":104,"_113":109},{"_105":104,"_106":107,"_108":109,"_19":61,"_110":111,"_112":54},{"_13":94,"_38":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"ctx",{"_87":-5,"_133":203,"_204":205,"_206":207,"_208":54,"_209":54,"_210":54,"_211":31,"_212":-5,"_213":-7,"_214":-7,"_215":68,"_216":54,"_217":54,"_218":-5,"_219":54,"_220":54,"_221":54,"_222":-5},"ENV",{"_174":175,"_176":177,"_178":95,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202},"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 · v25