[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_211":212,"_213":214},"routes/_app.x.$handle.$name",{"_99":98,"_32":45,"_107":86,"_27":108,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":120,"_121":122,"_123":25,"_124":125,"_126":58,"_127":-5,"_128":-5,"_129":130},"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":-5,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":79,"_80":81,"_82":83,"_84":25},"version",2,"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","github.ts","latestPath","fileId","0198c2c6-788a-735b-b574-6002934c8dae","name","fileType","script","content","interface Issue {\n title: string;\n body: string;\n author_username: string;\n created_at: string;\n updated_at: string;\n state: 'open' | 'closed';\n labels: string[];\n html_url: string;\n}\n\nexport async function fetchAllIssues(owner: string, repo: string, githubToken: string, limit?: number): Promise {\n const issues: Issue[] = [];\n let page = 1;\n const perPage = limit && limit < 100 ? limit : 100;\n \n while (true) {\n const remainder = limit ? Math.min(perPage, limit - issues.length) : perPage;\n \n if (remainder <= 0) break;\n \n const response = await fetch(\n `https://api.github.com/repos/${owner}/${repo}/issues?page=${page}&per_page=${remainder}&state=all`,\n { \n headers: {\n Authorization: `Bearer ${githubToken}`\n }\n }\n );\n \n if (!response.ok) {\n throw new Error(`GitHub API error: ${response.status} ${response.statusText}`);\n }\n \n const data = await response.json();\n \n const filteredIssues = data\n .filter(item => !item.pull_request)\n .map(item => ({\n title: item.title,\n body: item.body || \"\",\n author_username: item.user.login,\n created_at: item.created_at,\n updated_at: item.updated_at,\n state: item.state,\n labels: item.labels.map((label) => label.name),\n html_url: item.html_url\n }));\n \n issues.push(...filteredIssues);\n \n if (data.length < remainder) break;\n \n page++;\n }\n \n return issues;\n}","interface Issue {\n title: string;\n body: string;\n author_username: string;\n created_at: string;\n updated_at: string;\n state: 'open' | 'closed';\n labels: string[];\n html_url: string;\n}\n\nexport async function fetchAllIssues(owner: string, repo: string, githubToken: string, limit?: number): Promise {\n const issues: Issue[] = [];\n let page = 1;\n const perPage = limit && limit < 100 ? limit : 100;\n \n while (true) {\n const remainder = limit ? Math.min(perPage, limit - issues.length) : perPage;\n \n if (remainder <= 0) break;\n \n const response = await fetch(\n `https://api.github.com/repos/${owner}/${repo}/issues?page=${page}&per_page=${remainder}&state=all`,\n );\n \n if (!response.ok) {\n throw new Error(`GitHub API error: ${response.status} ${response.statusText}`);\n }\n \n const data = await response.json();\n \n const filteredIssues = data\n .filter(item => !item.pull_request)\n .map(item => ({\n title: item.title,\n body: item.body || \"\",\n author_username: item.user.login,\n created_at: item.created_at,\n updated_at: item.updated_at,\n state: item.state,\n labels: item.labels.map((label) => label.name),\n html_url: item.html_url\n }));\n \n issues.push(...filteredIssues);\n \n if (data.length < remainder) break;\n \n page++;\n }\n \n return issues;\n}","createdAt",["D",1755614542733],"branchVersion","branchId","7c3fa958-7d0a-11f0-8502-0224a6c84d84","id","7c3a6542-7d0a-11f0-8502-0224a6c84d84","GitHubIssuesToClayTEST",["D",1755614443545],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","c156eb0e-8b9d-4104-a055-502e9a0eb441","pinnedFileId","0198c2c6-788a-735b-b574-6688e2edfb62","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","2019e55b-c541-4c51-bef0-008eef10ef88","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_106":102},"org",{"_99":98,"_100":-5,"_101":102,"_18":54,"_103":104,"_105":25},"branch",{"_13":85,"_32":86,"_43":42,"_87":44,"_88":89,"_90":91,"_92":50,"_93":94,"_95":64,"_96":45,"_97":98},"isOwned",15,"main","projectId","forkedBranchId","6619bb2c-79eb-11f0-8710-0224a6c84d84","forkedBranchVersion",143,"forkedProjectPrivacy","forkedProjectId","661909d4-79eb-11f0-8710-0224a6c84d84","forkedProjectOrgId","projectName","userHandle","charmaine","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ4cFpFME5pSXNZamJNd296dlZSYVJ0OVF1RSJ9","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":207,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":58,"_60":-5,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":70,"_71":70,"_72":73,"_74":73,"_75":73,"_76":70,"_77":70,"_78":208,"_80":209,"_82":210,"_84":25},"tree",[186,187,188,189,190],"files",[186,187,188,189,190],"counts",{"_176":62,"_177":149,"_178":62,"_179":180,"_181":182},"contents",[140,141,142,143,144],"upstreamProject",{"_43":94,"_32":137,"_52":138,"_53":108,"_49":50,"_78":139},"upstreamBranch",{"_43":89,"_38":131,"_132":133,"_32":86,"_87":94,"_13":134,"_88":-5,"_90":-5,"_135":136,"_47":-5,"_84":25,"_49":50,"_97":98,"_63":64,"_96":137},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1755271238559],"updatedAt",["D",1759328122346],153,"lockfileKey","1759328208785-esm.town_v_charmaine_GitHubIssuesToClay@153-main","GitHubIssuesToClay","Grab issues from GitHub repo, send them to Clay",{"_99":98,"_106":102},{"_43":170,"_32":171,"_30":172,"_148":-5,"_41":42,"_40":149,"_150":25,"_38":173,"_13":62,"_33":20,"_35":174,"_24":25,"_153":-5,"_27":175},{"_43":164,"_32":165,"_30":166,"_148":-5,"_41":42,"_40":149,"_150":58,"_38":167,"_13":62,"_33":34,"_35":168,"_24":25,"_153":-5,"_27":169},{"_43":161,"_32":28,"_30":31,"_148":-5,"_41":42,"_40":14,"_150":25,"_38":162,"_13":149,"_33":34,"_35":37,"_24":25,"_153":-5,"_27":163},{"_43":155,"_32":156,"_30":56,"_148":-5,"_41":42,"_40":149,"_150":25,"_38":157,"_13":62,"_33":158,"_35":159,"_24":25,"_153":-5,"_27":160},{"_43":145,"_32":146,"_30":147,"_148":-5,"_41":42,"_40":149,"_150":58,"_38":151,"_13":62,"_33":34,"_35":152,"_24":25,"_153":-5,"_27":154},"7c4836c2-7d0a-11f0-8502-0224a6c84d84","test.ts","0198c2c6-788a-735b-b574-6b3d110887c9","parentId",1,"latest",["D",1755614443545],"import { listFiles } from \"https://esm.town/v/std/utils/index.ts\";\n\nlet httpURL: string | undefined;\n\n// Test call\nconst url = await getHttpURL();\nconst response = await fetch(url, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n limit: 10 // Optional: GitHub API defaults to 100 if not specified\n })\n});\n\nconsole.log(await response.json());\n\n//\n// -----------------------------------------------------------\n//\n// Helper functions to get the HTTP endpoint URL for main.ts\n// This avoids hardcoding the URL which changes when the val is remixed\n// You could skip this lookup by hardcoding url to the your endpoint.\nasync function getHttpURL() {\n if (httpURL) return removeTrailingSlash(httpURL);\n const files = await listFiles(import.meta.url);\n // Look for main.ts with an HTTP endpoint\n let endpoint = files.find(\n (file) => file.path === \"main.ts\" && file.links.endpoint,\n )?.links.endpoint;\n // Fallback to any HTTP file\n endpoint ||= files.find(\n (file) => file.links.endpoint,\n )?.links.endpoint;\n httpURL = endpoint;\n return removeTrailingSlash(httpURL);\n}\n\nfunction removeTrailingSlash(url: string) {\n return url.endsWith(\"/\") ? url.slice(0, -1) : url;\n}","label",[146],"7c483118-7d0a-11f0-8502-0224a6c84d84","main.ts",["D",1755614443545],"http","import { Hono } from \"https://esm.sh/hono@4.3.11\";\nimport { fetchAllIssues } from \"./github.ts\";\nimport { sendToClay } from \"./clay.ts\";\nimport { emailsFromGitHubUsername } from \"https://esm.town/v/stevekrouse/github-user-email/index.ts\";\n\nconst app = new Hono();\n\napp.get(\"/\", (c) => {\n return c.text(\n \"GitHub Issues to Clay webhook - see README.md for details\",\n );\n});\n\napp.post(\"/\", async (c) => {\n const body = await c.req.json().catch(() => ({}));\n const limit = body.limit; // Optional limit from request body\n\n // Change this to the repo you want to track!\n const githubRepo = \"sourcebot-dev/sourcebot\"\n \n const clayWebhookUrl = Deno.env.get(\"CLAY_WEBHOOK_URL\");\n const githubToken = Deno.env.get(\"GITHUB_TOKEN\");\n\n if (!clayWebhookUrl) return c.json({ error: \"CLAY_WEBHOOK_URL environment variable is required\" }, 400);\n if (!githubToken) return c.json({ error: \"GITHUB_TOKEN environment variable is required\" }, 400);\n\n const [owner, repo] = String(githubRepo).split(\"/\");\n\n const issues = await fetchAllIssues(owner, repo, githubToken, limit);\n\n const uniqueAuthors = [...new Set(issues.map((issue) => issue.author_username))];\n\n // You could do this with Clay but preprocesisng it saves a few requests\n const authorEmails = new Map();\n for (const username of uniqueAuthors) {\n try {\n const emails = await emailsFromGitHubUsername(username);\n authorEmails.set(username, emails ?? []);\n } catch {\n authorEmails.set(username, []);\n }\n }\n\n const emailData = [...authorEmails.entries()].flatMap(([username, emails]) =>\n emails.map((email) => ({ github_username: username, email, source_repo: githubRepo }))\n );\n\n if (emailData.length) {\n await sendToClay(clayWebhookUrl, emailData);\n }\n\n return c.json({ success: true, processed: emailData.length, authors: uniqueAuthors.length });\n});\n\n// Unwrap and rethrow Hono errors as the original error\n// If you delete this, all errors will be \"Internal Server Error\"\napp.onError((err, c) => {\n throw err;\n});\n\nexport default app.fetch;",[156],"b755957a-7d0a-11f0-b6c9-0224a6c84d84",["D",1755614542733],[28],"7c482d8a-7d0a-11f0-8502-0224a6c84d84","clay.ts","0198c2c6-788a-735b-b574-5ed315099acb",["D",1755614443545],"export async function sendToClay(webhookUrl: string, data: any[]): Promise {\n for (const record of data) {\n const response = await fetch(webhookUrl, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(record),\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n throw new Error(`Clay request failed: ${response.status} ${errorText}`);\n }\n }\n}",[165],"7c4823a8-7d0a-11f0-8502-0224a6c84d84","README.md","0198c2c6-788a-735b-b574-588f54182943",["D",1755614443545],"# GitHub Issues to Clay\n\nExtract GitHub issue authors' emails and send them to Clay for enrichment.\n\n# Setup\n\n1. Remix this val\n\n### [GitHub](./github.ts)\n\n2. Set `GITHUB_TOKEN` in this val's `Environment variables` on the left sidebar\n\n - `GITHUB_TOKEN` = [GitHub personal access token (classic)](https://github.com/settings/tokens) with `repo` access\n\n### [Clay](./clay.ts)\n3. Set up a Clay workbook with a `Webhook` column\n (or use\n [this template](https://app.clay.com/shared-workbook/share_0t0oqpwRR8KDw4RRQnZ))\n\n4. Copy your Clay workbook's `Webhook` URL\n\n ![CleanShot 2025-08-08 at 13.23.47@2x.png](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/48cd9c4d-2990-480f-9d07-fb09e2282500/public)\n\n5. Set that as `CLAY_WEBHOOK_URL` in this val's `Environment variables` on the left sidebar\n\n### [Main](main.ts)\n\n6. You can change `githubRepo` to whichever repo you are tracking in [main.ts](./main.ts)\n\n### [Test](test.ts)\n7. Try it out: click Run in [test.ts](./test.ts)",[171],"pulls","branches","forks","envVars",{"_183":149,"_185":62},"connections",{"_183":62,"_184":62},"count","unfilledCount","emptyCount",{"_43":170,"_32":171,"_30":172,"_148":-5,"_41":42,"_40":149,"_150":25,"_38":204,"_13":62,"_33":20,"_35":174,"_24":25,"_153":-5,"_192":205,"_27":206},{"_43":164,"_32":165,"_30":166,"_148":-5,"_41":42,"_40":149,"_150":58,"_38":201,"_13":62,"_33":34,"_35":168,"_24":25,"_153":-5,"_192":202,"_27":203},{"_43":161,"_32":28,"_30":31,"_148":-5,"_41":42,"_40":14,"_150":25,"_38":198,"_13":149,"_33":34,"_35":37,"_24":25,"_153":-5,"_192":199,"_27":200},{"_43":155,"_32":156,"_30":56,"_148":-5,"_41":42,"_40":149,"_150":25,"_38":195,"_13":62,"_33":158,"_35":159,"_24":25,"_153":-5,"_192":196,"_27":197},{"_43":145,"_32":146,"_30":147,"_148":-5,"_41":42,"_40":149,"_150":58,"_38":191,"_13":62,"_33":34,"_35":152,"_24":25,"_153":-5,"_192":193,"_27":194},["D",1755614443545],"children",[],[146],["D",1755614443545],[],[156],["D",1755614542733],[],[28],["D",1755614443545],[],[165],["D",1755614443545],[],[171],["D",1755614443545],{"_99":98,"_106":102},{"_99":98,"_100":-5,"_101":102,"_18":54,"_103":104,"_105":25},{"_13":85,"_32":86,"_43":42,"_87":44,"_88":89,"_90":91,"_92":50,"_93":94,"_95":64,"_96":45,"_97":98},"ctx",{"_78":-5,"_128":244,"_245":246,"_247":248,"_249":25,"_250":25,"_251":25,"_252":58,"_253":-5,"_254":-7,"_255":-7,"_256":62,"_257":25,"_258":25,"_259":-5,"_260":25,"_261":25,"_262":25,"_263":-5},"ENV",{"_215":216,"_217":218,"_219":86,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229,"_230":231,"_232":233,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243},"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 · v2