[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_216":217,"_218":219},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_109":86,"_27":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_20":-5,"_121":122,"_123":124,"_125":25,"_126":127,"_128":58,"_129":-5,"_130":-5,"_131":132},"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",3,"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","0199b522-f6db-75c2-9354-efc1f2cf2b34","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(\n owner: string,\n repo: string,\n githubToken: string,\n limit?: number,\n): 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\n ? Math.min(perPage, limit - issues.length)\n : 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(\n `GitHub API error: ${response.status} ${response.statusText}`,\n );\n }\n\n const data = await response.json();\n\n console.log(data);\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(\n owner: string,\n repo: string,\n githubToken: string,\n limit?: number,\n): 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\n ? Math.min(perPage, limit - issues.length)\n : 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(\n `GitHub API error: ${response.status} ${response.statusText}`,\n );\n }\n\n const data = await response.json();\n\n console.log(\"hi\");\n console.log(data);\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",1759682249564],"branchVersion","branchId","b947c0ea-a205-11f0-b91e-0224a6c84d84","id","b943f596-a205-11f0-b91e-0224a6c84d84","GitHubIssuesToConsole",["D",1759680591492],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","019977b1-1bd1-730d-a575-2665305dd849","pinnedFileId","0199b522-f6db-75c2-9354-f3bf5e590772","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019977b1-1bd1-730d-a575-2afdc309b42c","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,"_18":54,"_105":106,"_107":25},"branch",{"_13":85,"_32":86,"_43":42,"_87":44,"_88":89,"_90":91,"_92":50,"_93":94,"_95":96,"_97":45,"_98":99},"isOwned",29,"main","projectId","forkedBranchId","6619bb2c-79eb-11f0-8710-0224a6c84d84","forkedBranchVersion",153,"forkedProjectPrivacy","forkedProjectId","661909d4-79eb-11f0-8710-0224a6c84d84","forkedProjectOrgId","2019e55b-c541-4c51-bef0-008eef10ef88","projectName","userHandle","willemhelmet","handle","displayName","WHP","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zMzZ1Q1ZnYnREY3RBMjh5TWtPbU5vS01MejYifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":212,"_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":213,"_80":214,"_82":215,"_84":25},"tree",[191,192,193,194,195],"files",[191,192,193,194,195],"counts",{"_181":62,"_182":167,"_183":62,"_184":185,"_186":187},"contents",[143,144,145,146,147],"upstreamProject",{"_43":94,"_32":139,"_52":140,"_53":110,"_49":50,"_78":141},"upstreamBranch",{"_43":89,"_38":133,"_134":135,"_32":86,"_87":94,"_13":91,"_88":-5,"_90":-5,"_136":137,"_47":-5,"_84":25,"_49":50,"_98":138,"_63":96,"_97":139},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1755271238559],"updatedAt",["D",1759328122346],"lockfileKey","1759328208785-esm.town_v_charmaine_GitHubIssuesToClay@153-main","charmaine","GitHubIssuesToClay","Grab issues from GitHub repo, send them to Clay",{"_100":138,"_108":142},"https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ4cFpFME5pSXNZamJNd296dlZSYVJ0OVF1RSJ9",{"_43":175,"_32":176,"_30":177,"_151":-5,"_41":42,"_40":152,"_153":25,"_38":178,"_13":62,"_33":20,"_35":179,"_24":25,"_156":-5,"_27":180},{"_43":169,"_32":170,"_30":171,"_151":-5,"_41":42,"_40":152,"_153":25,"_38":172,"_13":62,"_33":34,"_35":173,"_24":25,"_156":-5,"_27":174},{"_43":165,"_32":28,"_30":31,"_151":-5,"_41":42,"_40":14,"_153":25,"_38":166,"_13":167,"_33":34,"_35":37,"_24":25,"_156":-5,"_27":168},{"_43":158,"_32":159,"_30":56,"_151":-5,"_41":42,"_40":152,"_153":25,"_38":160,"_13":62,"_33":161,"_35":162,"_24":25,"_156":163,"_27":164},{"_43":148,"_32":149,"_30":150,"_151":-5,"_41":42,"_40":152,"_153":25,"_38":154,"_13":62,"_33":34,"_35":155,"_24":25,"_156":-5,"_27":157},"b94df4d8-a205-11f0-b91e-0224a6c84d84","test.ts","0199b522-f6db-75c2-9354-f51300dd25df","parentId",1,"latest",["D",1759680591492],"import fetch from './main.ts';\n\nconst response = await fetch(new Request('/', {\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());","label",[149],"b94df0b4-a205-11f0-b91e-0224a6c84d84","main.ts",["D",1759680591492],"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 for # of issues\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 \n if (!clayWebhookUrl) return c.json({ error: \"CLAY_WEBHOOK_URL environment variable is required\" }, 400);\n\n const [owner, repo] = String(githubRepo).split(\"/\");\n\n const issues = await fetchAllIssues(owner, repo, limit);\n\n const uniqueAuthors = [...new Set(issues.map((issue) => issue.author_username))];\n\n // You could do this with Clay but preprocessing 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;","github-engagement-to-console",[159],"958a32b0-a209-11f0-8ee8-0224a6c84d84",["D",1759682249564],2,[28],"b94dec90-a205-11f0-b91e-0224a6c84d84","clay.ts","0199b522-f6db-75c2-9354-ebc4f5fdb193",["D",1759680591492],"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}",[170],"b94de290-a205-11f0-b91e-0224a6c84d84","README.md","0199b522-f6c6-7673-98a0-80ba8bcd4bf6",["D",1759680591492],"# 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\n2. Set up a Clay workbook with a `Webhook` column\n (or use\n [this template](https://app.clay.com/shared-workbook/share_0t0oqpwRR8KDw4RRQnZ))\n\n3. 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\n4. Set that as `CLAY_WEBHOOK_URL` in this val's `Environment variables` on the left sidebar\n\n5. In [main.ts](./main.ts), change `githubRepo` to whichever repo you are scraping.\n\n6. Try it out: click Run in [test.ts](./test.ts)\n\n\nNote: You can ignore `WARNING: \"GITHUB_TOKEN\" is not set.` in logs - you don't need it unless you are going over GitHub's ratelimit.",[176],"pulls","branches","forks","envVars",{"_188":152,"_190":62},"connections",{"_188":62,"_189":62},"count","unfilledCount","emptyCount",{"_43":175,"_32":176,"_30":177,"_151":-5,"_41":42,"_40":152,"_153":25,"_38":209,"_13":62,"_33":20,"_35":179,"_24":25,"_156":-5,"_197":210,"_27":211},{"_43":169,"_32":170,"_30":171,"_151":-5,"_41":42,"_40":152,"_153":25,"_38":206,"_13":62,"_33":34,"_35":173,"_24":25,"_156":-5,"_197":207,"_27":208},{"_43":165,"_32":28,"_30":31,"_151":-5,"_41":42,"_40":14,"_153":25,"_38":203,"_13":167,"_33":34,"_35":37,"_24":25,"_156":-5,"_197":204,"_27":205},{"_43":158,"_32":159,"_30":56,"_151":-5,"_41":42,"_40":152,"_153":25,"_38":200,"_13":62,"_33":161,"_35":162,"_24":25,"_156":163,"_197":201,"_27":202},{"_43":148,"_32":149,"_30":150,"_151":-5,"_41":42,"_40":152,"_153":25,"_38":196,"_13":62,"_33":34,"_35":155,"_24":25,"_156":-5,"_197":198,"_27":199},["D",1759680591492],"children",[],[149],["D",1759680591492],[],[159],["D",1759682249564],[],[28],["D",1759680591492],[],[170],["D",1759680591492],[],[176],["D",1759680591492],{"_100":99,"_108":104},{"_100":99,"_101":102,"_103":104,"_18":54,"_105":106,"_107":25},{"_13":85,"_32":86,"_43":42,"_87":44,"_88":89,"_90":91,"_92":50,"_93":94,"_95":96,"_97":45,"_98":99},"ctx",{"_78":-5,"_130":249,"_250":251,"_252":253,"_254":25,"_255":25,"_256":25,"_257":58,"_258":-5,"_259":-7,"_260":-7,"_261":62,"_262":25,"_263":25,"_264":-5,"_265":25,"_266":25,"_267":25,"_268":-5},"ENV",{"_220":221,"_222":223,"_224":86,"_225":226,"_227":228,"_229":230,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248},"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 · v3