[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_105":106,"_107":108},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","theophilec","name","jitbit-alumnforce-augment","path","main.ts","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":53,"_54":-5,"_55":56,"_57":25,"_58":32,"_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":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/theophilec/jitbit-alumnforce-augment/code/main.ts","extension","id","32259c9f-31b7-487a-9f76-0efab0b42fab","fileId","4d70be8e-9d37-11f1-9025-1607ee4eb77e","parentId","branchId","0ef73d21-4b68-41b5-b73f-bcbf14e61c4a","branchVersion",40,"latest",true,"createdAt",["D",1787303351575],"version",20,"fileType","http","content","/**\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 * 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_TOKEN Jitbit Bearer token (Authorization: Bearer)\n * ALUMNFORCE_URL e.g. https://mines-paris.org\n * ALUMNFORCE_ACCESS_ID Alumnforce Access id\n * ALUMNFORCE_ACCESS_SECRET Alumnforce Access secret (Basic auth, grant_type=client_credentials)\n *\n * Until the Jitbit and Alumnforce credentials are set, the val runs against\n * 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\") ?? \"\";\n\nconst AF_URL = (Deno.env.get(\"ALUMNFORCE_URL\") ?? \"\").replace(/\\/$/, \"\");\nconst AF_ACCESS_ID = Deno.env.get(\"ALUMNFORCE_ACCESS_ID\") ?? \"\";\nconst AF_ACCESS_SECRET = Deno.env.get(\"ALUMNFORCE_ACCESS_SECRET\") ?? \"\";\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 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);\n}\n\nfunction jitbitHeaders(): Record {\n return { \"Content-Type\": \"application/x-www-form-urlencoded\", Authorization: `Bearer ${JITBIT_TOKEN}` };\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_ACCESS_ID && AF_ACCESS_SECRET);\n}\n\nfunction afHeaders(): Record {\n return { Accept: \"application/json\", Authorization: \"Basic \" + btoa(`${AF_ACCESS_ID}:${AF_ACCESS_SECRET}`) };\n}\n\nasync function afGet(path: string) {\n if (!afConfigured()) return null; // signal \"use stub\"\n const sep = path.includes(\"?\") ? \"&\" : \"?\";\n const res = await fetch(`${AF_URL}${path}${sep}grant_type=client_credentials`, { 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 comes from the \"extra\" attributes, key \"promo\" (value already like \"P 2005\").\n let promo = \"\";\n try {\n const extra = await afGet(`${PEOPLE}/${encodeURIComponent(String(personId))}/extra`);\n const fields = extra?._embedded?.fields ?? [];\n promo = firstReal(fields.find((f: any) => f?._embedded?.attribute?.key === \"promo\")?.value);\n if (promo) promo = promo.replace(/^P\\s+/i, \"\"); // normalize to just the year\n } catch {\n // best-effort; leave promo empty if the extra endpoint fails\n }\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","deleted",false,"label",[14],"b4f42f7a-6374-4579-848a-7b9645377530",["D",1787299615803],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Augment Jitbit user profiles from Alumnforce on new ticket","imageUrl","userId","f333b48a-d1df-40f6-b81a-0a4eedb2118d","pinnedFileId","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",{"_9":10,"_104":100},"org",{"_9":10,"_97":98,"_99":100,"_55":56,"_101":102,"_103":42},"branch",{"_35":30,"_11":88,"_22":28,"_89":45,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":12,"_96":10},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Théophile Cantelobre","avatar","https://avatars.githubusercontent.com/u/11165990?v=4","tier","free","canRestrictVals","profileImageUrl","ctx",{"_81":-5,"_138":139,"_140":141,"_142":143,"_144":42,"_145":42,"_146":42,"_147":32,"_148":-5,"_149":-7,"_150":-7,"_151":62,"_152":42,"_153":42,"_154":-5,"_155":42,"_156":42,"_157":42,"_158":-5},"ENV",{"_109":110,"_111":112,"_113":88,"_114":115,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135,"_136":137},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]