[{"_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",{"_114":113,"_34":62,"_122":104,"_29":72,"_13":14,"_123":-5,"_11":124,"_125":126,"_127":128,"_129":130,"_131":132,"_22":-5,"_133":-5,"_134":-5,"_135":27,"_136":137,"_138":76,"_139":-5,"_140":-5,"_141":142},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_60":61,"_34":62,"_39":63,"_64":-5,"_65":27,"_66":67,"_68":67,"_69":70,"_71":72,"_18":73,"_74":47,"_75":76,"_77":76,"_78":-5,"_79":80,"_81":82,"_83":-5,"_84":-5,"_85":-5,"_86":-5,"_87":88,"_89":88,"_90":91,"_92":91,"_93":91,"_94":88,"_95":88,"_96":97,"_98":99,"_100":101,"_102":27},"version",143,"changes",[19,20,21],"aiChatInfo","userId",{"_22":52,"_24":53,"_26":27,"_28":27,"_29":54,"_31":54},{"_22":44,"_24":45,"_26":27,"_28":27,"_29":46,"_31":46},{"_22":23,"_24":25,"_26":27,"_28":27,"_29":30,"_31":30},"file",{"_32":33,"_34":30,"_35":22,"_36":38,"_39":40,"_41":14,"_42":43,"_26":27},"previous",{"_32":33,"_34":30,"_35":22,"_36":37},"deleted",false,"deletedHere","path","README.md","latestPath","fileId","e0f74536-7a08-11f0-b95c-0224a6c84d84","name","fileType","content","# 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)","# 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**Note: You can ignore `WARNING: \"GITHUB_TOKEN\" is not set.` - you don't need it unless you are going over GitHub's ratelimit.**","createdAt",["D",1755614933120],"branchVersion","branchId","6619bb2c-79eb-11f0-8710-0224a6c84d84",{"_32":47,"_34":46,"_35":48,"_36":50,"_39":51,"_41":14,"_42":43,"_26":27},{"_32":47,"_34":46,"_35":48,"_36":49},"main.ts","ab9bb978-79ed-11f0-88b5-0224a6c84d84","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;","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 \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 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;",["D",1755614933120],{"_32":55,"_34":54,"_35":56,"_36":58,"_39":59,"_41":14,"_42":43,"_26":27},{"_32":55,"_34":54,"_35":56,"_36":57},"github.ts","ab96d32c-79ed-11f0-9f7c-0224a6c84d84","script","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}",["D",1755614933120],"id","661909d4-79eb-11f0-8710-0224a6c84d84","GitHubIssuesToClay",["D",1755271238559],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Grab issues from GitHub repo, send them to Clay","imageUrl","","c156eb0e-8b9d-4104-a055-502e9a0eb441","pinnedFileId","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",{"_114":113,"_121":117},"org",{"_114":113,"_115":-5,"_116":117,"_18":73,"_118":119,"_120":27},"branch",{"_13":103,"_34":104,"_60":43,"_105":61,"_106":-5,"_107":-5,"_108":-5,"_109":-5,"_110":-5,"_111":62,"_112":113},"isOwned",153,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","charmaine","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ4cFpFME5pSXNZamJNd296dlZSYVJ0OVF1RSJ9","tier","pro","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_60":61,"_34":62,"_39":212,"_64":-5,"_65":27,"_66":67,"_68":67,"_69":70,"_71":72,"_18":73,"_74":47,"_75":76,"_77":76,"_78":-5,"_79":80,"_81":82,"_83":-5,"_84":-5,"_85":-5,"_86":-5,"_87":88,"_89":88,"_90":91,"_92":91,"_93":91,"_94":88,"_95":88,"_96":213,"_98":214,"_100":215,"_102":27},"tree",[191,192,193,194,195],"files",[191,192,193,194,195],"counts",{"_179":80,"_180":181,"_182":183,"_184":185,"_186":187},"contents",[143,144,145,146,147],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_60":175,"_34":30,"_32":33,"_151":-5,"_42":43,"_41":14,"_153":27,"_39":176,"_13":177,"_35":22,"_36":38,"_26":27,"_157":-5,"_29":178},{"_60":167,"_34":168,"_32":169,"_151":-5,"_42":43,"_41":170,"_153":76,"_39":171,"_13":172,"_35":56,"_36":173,"_26":27,"_157":-5,"_29":174},{"_60":163,"_34":54,"_32":55,"_151":-5,"_42":43,"_41":14,"_153":76,"_39":164,"_13":165,"_35":56,"_36":58,"_26":27,"_157":-5,"_29":166},{"_60":159,"_34":46,"_32":47,"_151":-5,"_42":43,"_41":14,"_153":27,"_39":160,"_13":155,"_35":48,"_36":50,"_26":27,"_157":161,"_29":162},{"_60":148,"_34":149,"_32":150,"_151":-5,"_42":43,"_41":152,"_153":27,"_39":154,"_13":155,"_35":56,"_36":156,"_26":27,"_157":-5,"_29":158},"b17dcb3a-7d06-11f0-8008-0224a6c84d84","test.ts","736ecba2-79ee-11f0-bb2b-0224a6c84d84","parentId",121,"latest",["D",1755612814944],21,"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",[149],"a005f6ac-7d0b-11f0-b43b-0224a6c84d84",["D",1755614933120],"ghissuestoclay",[46],"a005f422-7d0b-11f0-b43b-0224a6c84d84",["D",1755614933120],15,[54],"dfcdfb46-7d05-11f0-954b-0224a6c84d84","clay.ts","aba88086-79ed-11f0-bb11-0224a6c84d84",106,["D",1755612462992],6,"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}",[168],"a005ede2-7d0b-11f0-b43b-0224a6c84d84",["D",1755614933120],34,[30],"pulls","branches",1,"forks",3,"envVars",{"_188":181,"_190":80},"connections",{"_188":80,"_189":80},"count","unfilledCount","emptyCount",{"_60":175,"_34":30,"_32":33,"_151":-5,"_42":43,"_41":14,"_153":27,"_39":209,"_13":177,"_35":22,"_36":38,"_26":27,"_157":-5,"_197":210,"_29":211},{"_60":167,"_34":168,"_32":169,"_151":-5,"_42":43,"_41":170,"_153":76,"_39":206,"_13":172,"_35":56,"_36":173,"_26":27,"_157":-5,"_197":207,"_29":208},{"_60":163,"_34":54,"_32":55,"_151":-5,"_42":43,"_41":14,"_153":76,"_39":203,"_13":165,"_35":56,"_36":58,"_26":27,"_157":-5,"_197":204,"_29":205},{"_60":159,"_34":46,"_32":47,"_151":-5,"_42":43,"_41":14,"_153":27,"_39":200,"_13":155,"_35":48,"_36":50,"_26":27,"_157":161,"_197":201,"_29":202},{"_60":148,"_34":149,"_32":150,"_151":-5,"_42":43,"_41":152,"_153":27,"_39":196,"_13":155,"_35":56,"_36":156,"_26":27,"_157":-5,"_197":198,"_29":199},["D",1755612814944],"children",[],[149],["D",1755614933120],[],[46],["D",1755614933120],[],[54],["D",1755612462992],[],[168],["D",1755614933120],[],[30],["D",1755271238559],{"_114":113,"_121":117},{"_114":113,"_115":-5,"_116":117,"_18":73,"_118":119,"_120":27},{"_13":103,"_34":104,"_60":43,"_105":61,"_106":-5,"_107":-5,"_108":-5,"_109":-5,"_110":-5,"_111":62,"_112":113},"ctx",{"_96":-5,"_140":249,"_250":251,"_252":253,"_254":27,"_255":27,"_256":27,"_257":76,"_258":-5,"_259":-7,"_260":-7,"_261":80,"_262":27,"_263":27,"_264":-5,"_265":27,"_266":27,"_267":27,"_268":-5},"ENV",{"_220":221,"_222":223,"_224":104,"_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 · v143