[{"_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,"_38":51,"_109":90,"_33":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_26":-5,"_121":-5,"_122":-5,"_123":31,"_124":125,"_126":127,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_49":50,"_38":51,"_44":52,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":-5,"_59":-5,"_19":60,"_61":-5,"_62":31,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":31},"version",7,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","a62195b4-c95d-4163-8031-71255ec96360","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":29,"_30":31,"_32":31,"_33":34,"_35":34},"file",{"_36":37,"_38":34,"_39":40,"_41":43,"_44":45,"_46":14,"_47":48,"_30":31},"previous",{"_36":37,"_38":34,"_39":40,"_41":42},"deleted",false,"deletedHere","path","gorgiashttp.ts","latestPath","fileId","c235bb54-44e8-11f1-84e5-42b51c65c3df","name","fileType","http","content","export default async function (req: Request): Promise {\n const url = new URL(req.url);\n const email = url.searchParams.get(\"email\");\n\n // ── Validate input ──\n if (!email) {\n return Response.json({\n status: \"error\",\n message: \"Missing ?email= parameter\",\n }, { status: 400 });\n }\n\n const apiKey = Deno.env.get(\"KLAVIYO_API_KEY\");\n if (!apiKey) {\n return Response.json({\n status: \"error\",\n message: \"KLAVIYO_API_KEY not set in environment variables\",\n }, { status: 500 });\n }\n\n const REVISION = \"2024-10-15\";\n const headers = {\n \"Authorization\": `Klaviyo-API-Key ${apiKey}`,\n \"Accept\": \"application/json\",\n \"revision\": REVISION,\n };\n\n try {\n // ── STEP 1: Look up the Klaviyo profile by email ──\n const profileUrl = `https://a.klaviyo.com/api/profiles?filter=equals(email,\"${email}\")`;\n console.log(\"Fetching profile:\", profileUrl);\n const profileRes = await fetch(profileUrl, { headers });\n const profileData = await profileRes.json();\n console.log(\"Klaviyo response status:\", profileRes.status);\n console.log(\"Klaviyo response:\", JSON.stringify(profileData).slice(0, 500));\n\n if (!profileData.data || profileData.data.length === 0) {\n return Response.json({\n status: \"not_found\",\n profile_name: \"Unknown\",\n profile_email: email,\n total_emails: 0,\n message: `No Klaviyo profile found for ${email}`,\n klaviyo_status: profileRes.status,\n klaviyo_response: profileData,\n emails: [],\n });\n }\n\n const profile = profileData.data[0];\n const profileId = profile.id;\n const profileName = [\n profile.attributes.first_name,\n profile.attributes.last_name,\n ].filter(Boolean).join(\" \") || email;\n\n // ── STEP 2: Get metric IDs for email events ──\n const metricNames = [\"Received Email\", \"Opened Email\", \"Clicked Email\"];\n const metricMap: Record = {};\n\n for (const name of metricNames) {\n const res = await fetch(\n `https://a.klaviyo.com/api/metrics?filter=equals(name,\"${\n encodeURIComponent(name)\n }\")`,\n { headers },\n );\n const data = await res.json();\n if (data.data && data.data.length > 0) {\n metricMap[name] = data.data[0].id;\n }\n }\n\n // ── STEP 3: Fetch events for each metric ──\n async function getEvents(metricId: string): Promise {\n const res = await fetch(\n `https://a.klaviyo.com/api/events?filter=equals(profile_id,\"${profileId}\"),equals(metric_id,\"${metricId}\")&sort=-datetime&page[size]=50`,\n { headers },\n );\n const data = await res.json();\n return data.data || [];\n }\n\n const receivedEvents = metricMap[\"Received Email\"]\n ? await getEvents(metricMap[\"Received Email\"])\n : [];\n const openedEvents = metricMap[\"Opened Email\"]\n ? await getEvents(metricMap[\"Opened Email\"])\n : [];\n const clickedEvents = metricMap[\"Clicked Email\"]\n ? await getEvents(metricMap[\"Clicked Email\"])\n : [];\n\n // ── STEP 4: Build lookup sets by message ID ──\n const openedMessages = new Set();\n for (const ev of openedEvents) {\n const msgId = ev.attributes?.event_properties?.$message ||\n ev.attributes?.event_properties?.[\"$message\"] || \"\";\n if (msgId) openedMessages.add(msgId);\n }\n\n const clickedMessages = new Set();\n for (const ev of clickedEvents) {\n const msgId = ev.attributes?.event_properties?.$message ||\n ev.attributes?.event_properties?.[\"$message\"] || \"\";\n if (msgId) clickedMessages.add(msgId);\n }\n\n // ── STEP 5: Format the response ──\n const emails = receivedEvents.slice(0, 25).map((ev: any) => {\n const props = ev.attributes?.event_properties || {};\n const messageId = props.$message || props[\"$message\"] || \"\";\n const subject = props.Subject || props[\"Subject\"] || props.$subject ||\n \"(no subject)\";\n const campaignName = props.campaign_name || props[\"Campaign Name\"] || \"\";\n const flowName = props.$flow || props[\"$flow\"] || \"\";\n\n // Format date nicely\n let sentDate = ev.attributes?.datetime || \"\";\n try {\n const d = new Date(sentDate);\n sentDate = d.toLocaleDateString(\"en-US\", {\n month: \"short\",\n day: \"numeric\",\n year: \"numeric\",\n }) + \" \" + d.toLocaleTimeString(\"en-US\", {\n hour: \"numeric\",\n minute: \"2-digit\",\n });\n } catch (_) { /* keep raw */ }\n\n return {\n subject,\n source: flowName ? flowName : (campaignName || \"—\"),\n type: flowName ? \"Flow\" : \"Campaign\",\n sent_at: sentDate,\n opened: openedMessages.has(messageId) ? \"✅ Yes\" : \"❌ No\",\n clicked: clickedMessages.has(messageId) ? \"✅ Yes\" : \"❌ No\",\n };\n });\n\n return Response.json({\n status: \"ok\",\n profile_name: profileName,\n profile_email: email,\n total_emails: emails.length,\n emails,\n });\n } catch (err: any) {\n return Response.json({\n status: \"error\",\n message: `Error: ${err.message}`,\n emails: [],\n }, { status: 500 });\n }\n}","export default async function (req: Request): Promise {\n const url = new URL(req.url);\n const email = url.searchParams.get(\"email\");\n\n // ── Validate input ──\n if (!email) {\n return Response.json({\n status: \"error\",\n message: \"Missing ?email= parameter\",\n }, { status: 400 });\n }\n\n const apiKey = Deno.env.get(\"KLAVIYO_API_KEY\");\n if (!apiKey) {\n return Response.json({\n status: \"error\",\n message: \"KLAVIYO_API_KEY not set in environment variables\",\n }, { status: 500 });\n }\n\n const REVISION = \"2024-10-15\";\n const headers = {\n \"Authorization\": `Klaviyo-API-Key ${apiKey}`,\n \"Accept\": \"application/json\",\n \"revision\": REVISION,\n };\n\n try {\n // ── STEP 1: Look up the Klaviyo profile by email ──\n const profileUrl = `https://a.klaviyo.com/api/profiles?filter=equals(email,\"${email}\")`;\n console.log(\"Fetching profile:\", profileUrl);\n const profileRes = await fetch(profileUrl, { headers });\n const profileData = await profileRes.json();\n console.log(\"Klaviyo response status:\", profileRes.status);\n console.log(\"Klaviyo response:\", JSON.stringify(profileData).slice(0, 500));\n\n if (!profileData.data || profileData.data.length === 0) {\n return Response.json({\n status: \"not_found\",\n profile_name: \"Unknown\",\n profile_email: email,\n total_emails: 0,\n message: `No Klaviyo profile found for ${email}`,\n klaviyo_status: profileRes.status,\n klaviyo_response: profileData,\n emails: [],\n });\n }\n\n const profile = profileData.data[0];\n const profileId = profile.id;\n const profileName = [\n profile.attributes.first_name,\n profile.attributes.last_name,\n ].filter(Boolean).join(\" \") || email;\n\n // ── STEP 2: Get metric IDs for email events ──\n const metricNames = [\"Received Email\", \"Opened Email\", \"Clicked Email\"];\n const metricMap: Record = {};\n\n for (const name of metricNames) {\n const metricUrl = `https://a.klaviyo.com/api/metrics?filter=equals(name,\"${encodeURIComponent(name)}\")`;\n console.log(\"Fetching metric:\", metricUrl);\n const res = await fetch(metricUrl, { headers });\n const data = await res.json();\n console.log(`Metric \"${name}\" response status:`, res.status, \"found:\", data.data?.length || 0);\n if (data.errors) console.log(`Metric \"${name}\" errors:`, JSON.stringify(data.errors));\n if (data.data && data.data.length > 0) {\n metricMap[name] = data.data[0].id;\n }\n }\n console.log(\"Metric map:\", JSON.stringify(metricMap));\n\n // ── STEP 3: Fetch events for each metric ──\n async function getEvents(metricId: string): Promise {\n const res = await fetch(\n `https://a.klaviyo.com/api/events?filter=equals(profile_id,\"${profileId}\"),equals(metric_id,\"${metricId}\")&sort=-datetime&page[size]=50`,\n { headers },\n );\n const data = await res.json();\n return data.data || [];\n }\n\n const receivedEvents = metricMap[\"Received Email\"]\n ? await getEvents(metricMap[\"Received Email\"])\n : [];\n const openedEvents = metricMap[\"Opened Email\"]\n ? await getEvents(metricMap[\"Opened Email\"])\n : [];\n const clickedEvents = metricMap[\"Clicked Email\"]\n ? await getEvents(metricMap[\"Clicked Email\"])\n : [];\n\n // ── STEP 4: Build lookup sets by message ID ──\n const openedMessages = new Set();\n for (const ev of openedEvents) {\n const msgId = ev.attributes?.event_properties?.$message ||\n ev.attributes?.event_properties?.[\"$message\"] || \"\";\n if (msgId) openedMessages.add(msgId);\n }\n\n const clickedMessages = new Set();\n for (const ev of clickedEvents) {\n const msgId = ev.attributes?.event_properties?.$message ||\n ev.attributes?.event_properties?.[\"$message\"] || \"\";\n if (msgId) clickedMessages.add(msgId);\n }\n\n // ── STEP 5: Format the response ──\n const emails = receivedEvents.slice(0, 25).map((ev: any) => {\n const props = ev.attributes?.event_properties || {};\n const messageId = props.$message || props[\"$message\"] || \"\";\n const subject = props.Subject || props[\"Subject\"] || props.$subject ||\n \"(no subject)\";\n const campaignName = props.campaign_name || props[\"Campaign Name\"] || \"\";\n const flowName = props.$flow || props[\"$flow\"] || \"\";\n\n // Format date nicely\n let sentDate = ev.attributes?.datetime || \"\";\n try {\n const d = new Date(sentDate);\n sentDate = d.toLocaleDateString(\"en-US\", {\n month: \"short\",\n day: \"numeric\",\n year: \"numeric\",\n }) + \" \" + d.toLocaleTimeString(\"en-US\", {\n hour: \"numeric\",\n minute: \"2-digit\",\n });\n } catch (_) { /* keep raw */ }\n\n return {\n subject,\n source: flowName ? flowName : (campaignName || \"—\"),\n type: flowName ? \"Flow\" : \"Campaign\",\n sent_at: sentDate,\n opened: openedMessages.has(messageId) ? \"✅ Yes\" : \"❌ No\",\n clicked: clickedMessages.has(messageId) ? \"✅ Yes\" : \"❌ No\",\n };\n });\n\n return Response.json({\n status: \"ok\",\n profile_name: profileName,\n profile_email: email,\n total_emails: emails.length,\n emails,\n });\n } catch (err: any) {\n return Response.json({\n status: \"error\",\n message: `Error: ${err.message}`,\n emails: [],\n }, { status: 500 });\n }\n}","createdAt",["D",1777591118259],"branchVersion","branchId","c2331cb4-44e8-11f1-84e5-42b51c65c3df","id","c232677e-44e8-11f1-84e5-42b51c65c3df","klaviyoGorgiasProxy",["D",1777590190637],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","e7a73181-36c9-47a0-a92e-af7ca5e84ec2","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019de0a0-5e7f-727b-81a3-b98d2db13d65","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_108":104},"org",{"_100":99,"_101":102,"_103":104,"_19":60,"_105":106,"_107":31},"branch",{"_13":89,"_38":90,"_49":48,"_91":50,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":51,"_98":99},"isOwned",12,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","gorgiasimplementationteam","handle","displayName","Implementation Testing","avatar","https://lh3.googleusercontent.com/a/ACg8ocLjpqlIsN1HpJdrVajpvMPoi8Wgk6wuRtGfm91CmnXnvQr4AQ=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_49":50,"_38":51,"_44":156,"_53":-5,"_54":31,"_55":56,"_57":56,"_58":-5,"_59":-5,"_19":60,"_61":-5,"_62":31,"_63":-5,"_64":-5,"_65":66,"_67":68,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":157,"_84":158,"_86":159,"_88":31},"tree",[151],"files",[151],"counts",{"_140":66,"_141":142,"_143":66,"_144":145,"_146":147},"contents",[132],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_49":133,"_38":34,"_36":37,"_134":-5,"_47":48,"_46":14,"_135":31,"_44":136,"_13":137,"_39":40,"_41":43,"_30":31,"_138":-5,"_33":139},"eb1daf3e-44ea-11f1-b101-42b51c65c3df","parentId","latest",["D",1777591118259],6,"label",[34],"pulls","branches",1,"forks","envVars",{"_148":142,"_150":66},"connections",{"_148":66,"_149":66},"count","unfilledCount","emptyCount",{"_49":133,"_38":34,"_36":37,"_134":-5,"_47":48,"_46":14,"_135":31,"_44":152,"_13":137,"_39":40,"_41":43,"_30":31,"_138":-5,"_153":154,"_33":155},["D",1777591118259],"children",[],[34],["D",1777590190637],{"_100":99,"_108":104},{"_100":99,"_101":102,"_103":104,"_19":60,"_105":106,"_107":31},{"_13":89,"_38":90,"_49":48,"_91":50,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":51,"_98":99},"ctx",{"_82":-5,"_129":193,"_194":195,"_196":197,"_198":31,"_199":31,"_200":31,"_201":127,"_202":-5,"_203":-7,"_204":-7,"_205":66,"_206":31,"_207":31,"_208":-5,"_209":31,"_210":31,"_211":31,"_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","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 · v7