[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_249":250,"_251":252},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_187":-5,"_20":188,"_22":189,"_190":191,"_192":193,"_26":194,"_24":195,"_196":-5,"_197":-5,"_198":55,"_199":200,"_201":46,"_202":-5,"_203":-5,"_204":205},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","glance","name","Team","branchName","main","version","path","controllers","project",{"_34":133,"_13":14,"_47":134,"_135":-5,"_136":55,"_137":138,"_139":138,"_140":-5,"_141":-5,"_142":143,"_144":71,"_145":46,"_146":46,"_147":-5,"_148":149,"_150":151,"_152":-5,"_153":-5,"_154":-5,"_155":-5,"_156":157,"_158":157,"_159":160,"_161":160,"_162":160,"_163":157,"_164":157,"_165":166,"_167":168,"_169":170,"_171":55},"tree",[64,65,66,67,68],"file",{"_34":58,"_41":42,"_37":40,"_13":19,"_52":-5,"_50":59,"_17":60,"_39":-5,"_47":61,"_43":62,"_56":-5,"_18":63},"contents",[33],"upstream","pull","ahead","behind","envVars",{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":57},"id","9e802e60-3363-11f1-80a2-42b51c65c3df","controllers.ts","fileId","0d70d486-4252-11f0-ae33-76b3cceeab13","parentId","0384f04c-4252-11f0-8453-76b3cceeab13","branchId","a9c56d24-4243-11f0-a40a-76b3cceeab13","branchVersion",289,"latest",true,"createdAt",["D",1775663837902],59,"fileType","script","content","import { Client } from \"npm:@notionhq/client@^5\";\nimport ValTown from \"npm:@valtown/sdk\";\n\n// initialize the val.town client\nconst vt = new ValTown();\n\n// Lazily create the Notion client so it's initialized on each request\n// Pin to 2022-06-28 API version to keep databases.query working with regular database IDs\nfunction getNotion() {\n return new Client({\n auth: Deno.env.get(\"NOTION_API_KEY\"),\n notionVersion: \"2022-06-28\",\n });\n}\n\nexport async function getValsForUser(id: string) {\n try {\n const vals = await vt.vals.list({ user_id: id });\n return vals;\n } catch {\n return [];\n }\n}\n\nexport async function getDatabasePageIds() {\n try {\n const response = await getNotion().databases.query({\n database_id: Deno.env.get(\"GLANCE_TEAM_DB_ID\")!,\n });\n return response;\n } catch (err) {\n console.error(\"getDatabasePageIds error:\", err);\n return null;\n }\n}\n\nexport async function getTeam() {\n try {\n const response = await getNotion().databases.query({\n database_id: Deno.env.get(\"GLANCE_TEAM_DB_ID\")!,\n });\n const team = await Promise.all(response.results.map(async (page: any) => {\n const vals = await getValsForUser(page.properties.Id?.rich_text?.[0]?.plain_text);\n return {\n id: page.properties.Id?.rich_text?.[0]?.plain_text,\n username: page.properties.Username.title[0].plain_text,\n url: page.properties.URL.url,\n bio: (page.properties.Bio?.rich_text?.[0]) ? page.properties.Bio.rich_text[0].plain_text : \"\",\n profileImageUrl: (page.properties.Avatar?.files?.[0]) ? page.properties.Avatar.files[0].external.url : \"\",\n vals,\n };\n }));\n return team;\n } catch (err) {\n console.error(\"getTeam error:\", err);\n return null;\n }\n}\n\nexport async function getValTownUser(username: string) {\n try {\n return await vt.alias.username.retrieve(username);\n } catch {\n return null;\n }\n}\n\nexport async function getNotionPage(id: string) {\n try {\n return await getNotion().pages.retrieve({\n page_id: id,\n });\n } catch {\n return null;\n }\n}\n\nexport async function setNotionPage(id: string, data: any) {\n const bio = data.bio\n ? [{ text: { content: data.bio } }]\n : [];\n\n try {\n return await getNotion().pages.update({\n page_id: id,\n properties: {\n URL: { url: data.url },\n Username: { title: [{ text: { content: data.username } }] },\n Id: { rich_text: [{ text: { content: data.id } }] },\n Bio: { rich_text: bio },\n Avatar: {\n files: [{\n name: \"Profile Image\",\n external: { url: data.profileImageUrl },\n }],\n },\n },\n });\n } catch (err) {\n console.error(\"setNotionPage error:\", err);\n return null;\n }\n}\n","deleted",false,"label",[19,36],"0516daa6-4252-11f0-8ec6-76b3cceeab13","directory",1,["D",1749158048852],84,[19],{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":62,"_45":46,"_47":126,"_17":60,"_50":59,"_52":-5,"_54":55,"_56":-5,"_78":127,"_18":128},{"_34":99,"_13":100,"_37":101,"_39":-5,"_41":42,"_43":102,"_45":46,"_47":103,"_17":60,"_50":59,"_52":-5,"_54":55,"_56":-5,"_78":104,"_18":105},{"_34":90,"_13":91,"_37":92,"_39":-5,"_41":42,"_43":93,"_45":46,"_47":94,"_17":95,"_50":24,"_52":96,"_54":55,"_56":-5,"_78":97,"_18":98},{"_34":81,"_13":82,"_37":83,"_39":-5,"_41":42,"_43":84,"_45":46,"_47":85,"_17":86,"_50":51,"_52":87,"_54":55,"_56":-5,"_78":88,"_18":89},{"_34":69,"_13":70,"_37":71,"_39":-5,"_41":42,"_43":72,"_45":46,"_47":73,"_17":74,"_50":75,"_52":76,"_54":55,"_56":77,"_78":79,"_18":80},"e2dcaf6a-430f-11f0-9e5e-76b3cceeab13","main.tsx","a9c7a33c-4243-11f0-a40a-76b3cceeab13",217,["D",1749239595807],86,"http","/** @jsxImportSource https://esm.sh/react@18.2.0 */\n\nimport { Hono } from \"npm:hono\";\n\n// import routes\nimport api from \"./routes/api.ts\";\nimport views from \"./routes/api.ts\";\nimport tasks from \"./routes/tasks.ts\";\n\n// initialize Hono API\nconst app = new Hono();\n\n// Mount routes\napp.route(\"/tasks\", tasks);\napp.route(\"/api\", api);\napp.route(\"/team\", views);\n\napp.get(\"/\", (c) => {\n return c.text(\"Hello, Team!\");\n});\n\nexport default app.fetch;","glance-team","children",[],[70],"e1a5cb78-3363-11f1-acd6-42b51c65c3df","cron.ts","1a62e1fc-4315-11f0-a37e-76b3cceeab13",290,["D",1775663950548],55,"import { getDatabasePageIds, getValTownUser, setNotionPage } from \"./controllers/controllers.ts\";\n\nexport default async function(interval: Interval) {\n const pages = await getDatabasePageIds();\n\n // guard: if the Notion query failed, bail out early\n if (!pages) {\n console.error(\"getDatabasePageIds returned null — skipping cron run\");\n return;\n }\n\n // loop through the database, awaiting all updates\n await Promise.all(pages.results.map(async (page) => {\n // get username from Notion page data\n const username = page.properties.Username.title[0].plain_text;\n\n // get fresh user info from val.town with that username\n const user = await getValTownUser(username);\n if (!user) {\n console.error(\"getValTownUser returned null for: \" + username);\n return;\n }\n\n // if the val.town profileImageUrl is the same as the notion url, do nothing\n const notionAvatarUrl = page.properties.Avatar?.files?.[0]?.external?.url;\n if (user.profileImageUrl === notionAvatarUrl) {\n console.log(\"Skipping \" + username + \" because the profile pic isn't updated.\");\n return;\n }\n\n // update the page with fresh user info\n await setNotionPage(page.id, user);\n console.log(username + \" has been updated\");\n }));\n}\n",[],[82],"0184ebac-4285-11f0-a952-76b3cceeab13","README.md","75ed7e84-4283-11f0-aafc-76b3cceeab13",202,["D",1749179947196],6,"# Team - Notion & Val Town Integration\n\nA simple integration that automatically enriches a Notion database of team members with their Val Town account information. When a new team member is added to your Notion database, this Val automatically fetches their Val Town profile data and populates the relevant fields.\n\n## Features\n\n- **Automatic Profile Enrichment**: Fetches Val Town user data when triggered by Notion webhooks\n- **Flexible Username Detection**: Supports both URL-based and direct username input\n- **RESTful API**: Provides endpoints to manually query Val Town user information\n- **Error Handling**: Graceful handling of missing users or API failures\n\n## Project Structure\n\n```\n├── main.tsx # Main Hono app with route mounting\n├── routes/\n│ ├── api.ts # API endpoints for manual user queries\n│ └── tasks.ts # Webhook handler for Notion integration\n├── controllers/\n│ └── controllers.ts # Business logic for Notion and Val Town operations\n└── README.md\n```\n\n## API Endpoints\n\n### Webhook Endpoint\n- **POST** `/tasks` - Notion webhook handler that enriches team member data\n\n### Manual API Endpoints\nNote: these are not used in this demo but are included for demonstration purposes later.\n- **GET** `/api/:username` - Returns JSON data for a Val Town user\n- **GET** `/api/:username/html` - Returns HTML-formatted user data\n- **GET** `/api` - API information endpoint\n\n## Setup Instructions\n\n### 1. Environment Variables\n\nSet the following environment variable in your Val Town settings:\n\n```\nNOTION_API_KEY=your_notion_integration_token\nGLANCE_TEAM_DB_ID=your_database_id\n```\n\n### 2. Notion Database Schema\n\nYour Notion database should have the following properties:\n\n| Property Name | Type | Description |\n|---------------|------|-------------|\n| `Username` | Title | Val Town username (auto-populated) |\n| `URL` | URL | Val Town profile URL (can be input or auto-populated) |\n| `Id` | Rich Text | Val Town user ID (auto-populated) |\n| `Bio` | Rich Text | User bio from Val Town (auto-populated) |\n\n### 3. Notion Integration Setup\n\n1. Create a new integration in your Notion workspace\n2. Add the integration to your team database\n3. Create a webhook that points to `https://your-val-url.web.val.run/tasks`\n4. Configure the webhook to trigger on database item creation/updates\n\n## How It Works\n\n1. **Trigger**: When a team member is added/updated in Notion, a webhook is sent to `/tasks`\n2. **Data Retrieval**: The system fetches the full page data from Notion to get the username\n3. **Username Extraction**: Extracts username from either:\n - The `URL` field (extracts from `https://val.town/u/username`)\n - The `Username` field directly\n4. **Profile Fetch**: Queries the Val Town API for user profile data\n5. **Database Update**: Updates the Notion page with the retrieved information\n\n## Usage Examples\n\n### Notion Workflow\n\n1. Add a new team member to your Notion database\n2. Fill in either the `Username` field or paste their Val Town profile URL in the `URL` field\n3. The webhook will automatically trigger and populate the remaining fields\n\n## Val Town Profile Data\n\nThe integration fetches and stores the following data from Val Town:\n\n- **Username**: Val Town handle\n- **ID**: Unique user identifier\n- **Bio**: User's profile bio (if available)\n- **URL**: Direct link to their Val Town profile\n- **Profile Image URL**: Link to their profile picture\n\n## Error Handling\n\n- **Missing Users**: If a Val Town user doesn't exist, the system gracefully handles the error\n- **API Failures**: Network issues or API errors are logged and return appropriate error responses\n- **Invalid Data**: Malformed webhook data is handled with proper error messages\n\n## Development\n\nThe project uses:\n- **Hono**: Fast web framework for the API\n- **Val Town SDK**: Official SDK for Val Town API interactions\n- **Notion SDK**: Official SDK for Notion API operations\n- **TypeScript**: For type safety and better development experience\n\n## Contributing\n\nWhen modifying the Notion database schema, ensure you update the `setPage` function in `controllers/controllers.ts` to match your new property structure.",[],[91],"fd29d758-4251-11f0-98ea-76b3cceeab13","routes","fb471806-4251-11f0-a9e0-76b3cceeab13",80,["D",1749158035551],[106,107],[100],{"_34":117,"_13":118,"_37":119,"_39":101,"_41":42,"_43":120,"_45":46,"_47":121,"_17":122,"_50":51,"_52":123,"_54":55,"_56":-5,"_78":124,"_18":125},{"_34":108,"_13":109,"_37":110,"_39":101,"_41":42,"_43":111,"_45":46,"_47":112,"_17":113,"_50":51,"_52":114,"_54":55,"_56":-5,"_78":115,"_18":116},"aabaece0-42e3-11f0-99cd-76b3cceeab13","tasks.ts","929a8622-4250-11f0-966c-76b3cceeab13",216,["D",1749220603779],51,"import { Hono } from \"npm:hono\";\nimport { getNotionPage, getValTownUser, setNotionPage } from \"../controllers/controllers.ts\";\n\n// Initialize Hono\nconst app = new Hono();\n\n// get the user object and save it to Notion\n// note that this is a POST, which is the only type of request Notion sends\napp.post(\"/\", async (c) => {\n try {\n // get the Notion webhook payload\n const { data } = await c.req.json();\n // we can't be sure what data we'll get from the Notion payload\n // so we need to call Notion and get all the data from the page that sent the POST\n const page = await getNotionPage(data.id);\n // depending on what's in the Notion data, find the username\n const username = (page.properties?.URL?.url)\n ? page.properties?.URL?.url.split(\"/\").pop()\n : page.properties?.Username?.title?.[0]?.plain_text;\n // hit val.town for the the user object with that username\n const user = await getValTownUser(username);\n // fill in Notion with the data from the val.town user object\n await setNotionPage(data.id, user);\n // return a simple success message (Notion discards details anyway)\n return c.json({ ok: true });\n } catch (error: any) {\n console.log(error.body);\n return c.json(\n {\n status: \"error\",\n message: error.message,\n },\n 500,\n );\n }\n});\n\nexport default app;",[],[100,109],"f306e498-3362-11f1-aad2-42b51c65c3df","api.ts","090d0c1c-4256-11f0-b8fc-76b3cceeab13",282,["D",1775663550144],25,"import ValTown from \"npm:@valtown/sdk\";\nimport { Hono } from \"npm:hono\";\nimport { getTeam, getValTownUser } from \"../controllers/controllers.ts\";\n\n// Initialize Hono\nconst app = new Hono();\n// Initialize the val.town client\nconst vt = new ValTown();\n\napp.get(\"/team\", async (c) => {\n // get all pages from the team database\n const team = await getTeam();\n // console.log(team);\n return c.json(team);\n});\n\napp.get(\"/team/showcase/html\", async (c) => {\n // get all pages from the team database\n const team = await getTeam();\n if (!team) {\n return c.html(`

Error: could not load team data from Notion.

`, 500);\n }\n const html = team.map((user) => {\n const valsList = Array.isArray(user.vals?.data) ? user.vals.data : [];\n return `\n

${user.username}

\n $\"${user.username}\"$ \n

${user.bio || \"\"}

\n \n

Vals

${val.name}

\n `;\n }).join(\"\");\n return c.html(`\n

Glance on val.town

If you're a Glance team member and you have a val.town account, add your username to the Team sandbox on Notion and your val.town profile will appear here.

If you don't yet have a val.town account, sign up!

\n ${html}\n

\n `);\n});\n\napp.get(\"/team/showcase/json\", async (c) => {\n // get all pages from the team database\n const team = await getTeam();\n // console.log(team);\n return c.html(`\n

${JSON.stringify(team, null, 2)}

\n `);\n});\n\napp.get(\"/:username\", async (c) => {\n const username = c.req.param(\"username\");\n try {\n // in this example endpoint, we use the vt methods\n const user = await vt.alias.username.retrieve(username);\n return c.json(\n user,\n );\n } catch (error) {\n console.log(error);\n return c.json(error, 400);\n }\n});\n\napp.get(\"/:username/html\", async (c) => {\n const username = c.req.param(\"username\");\n try {\n // in this example endpoint, we use the controller that uses the vt methods\n const user = await getValTownUser(username);\n return c.html(`\n

${JSON.stringify(user, null, 2)}

\n `);\n } catch (error) {\n console.log(error);\n return c.json(error, 400);\n }\n});\n\napp.get(\"/\", async (c) => {\n return c.json({ message: \"/api is for GETs\" });\n});\n\nexport default app;",[],[100,118],["D",1749158048852],[129],[19],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":130,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_78":131,"_18":132},["D",1775663837902],[],[19,36],"a9c50758-4243-11f0-a40a-76b3cceeab13",["D",1749151882696],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","4f241590-30c9-11f0-a8af-d78f9b7cc3ba","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","1076c769-1d44-453a-ba61-890670db7b70","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_186":182},"org",{"_11":12,"_180":-5,"_181":182,"_142":143,"_183":184,"_185":55},"branch",{"_17":84,"_13":16,"_34":42,"_172":133,"_173":-5,"_174":-5,"_175":-5,"_176":-5,"_177":-5,"_178":14,"_179":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ4Z0tGaEdPSVVibDJHOVVJdncyM0ZWUnBleiJ9","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":133,"_13":14,"_47":245,"_135":-5,"_136":55,"_137":138,"_139":138,"_140":-5,"_141":-5,"_142":143,"_144":71,"_145":46,"_146":46,"_147":-5,"_148":149,"_150":151,"_152":-5,"_153":-5,"_154":-5,"_155":-5,"_156":157,"_158":157,"_159":160,"_161":160,"_162":160,"_163":157,"_164":157,"_165":246,"_167":247,"_169":248,"_171":55},[221,223,226,227,228],"files",[221,222,223,224,225,226,227,228],"counts",{"_210":149,"_211":212,"_213":60,"_32":214,"_215":216},[208],{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":62,"_45":46,"_47":206,"_17":60,"_50":59,"_52":-5,"_54":55,"_56":-5,"_18":207},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1749158048852],[19],{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_18":209},[19,36],"pulls","branches",3,"forks",{"_217":219,"_220":149},"connections",{"_217":149,"_218":149},"count","unfilledCount",2,"emptyCount",{"_34":58,"_13":19,"_37":40,"_39":-5,"_41":42,"_43":62,"_45":46,"_47":126,"_17":60,"_50":59,"_52":-5,"_54":55,"_56":-5,"_78":243,"_18":244},{"_34":35,"_13":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":130,"_17":49,"_50":51,"_52":53,"_54":55,"_56":-5,"_78":241,"_18":242},{"_34":99,"_13":100,"_37":101,"_39":-5,"_41":42,"_43":102,"_45":46,"_47":103,"_17":60,"_50":59,"_52":-5,"_54":55,"_56":-5,"_78":239,"_18":240},{"_34":117,"_13":118,"_37":119,"_39":101,"_41":42,"_43":120,"_45":46,"_47":121,"_17":122,"_50":51,"_52":123,"_54":55,"_56":-5,"_78":237,"_18":238},{"_34":108,"_13":109,"_37":110,"_39":101,"_41":42,"_43":111,"_45":46,"_47":112,"_17":113,"_50":51,"_52":114,"_54":55,"_56":-5,"_78":235,"_18":236},{"_34":90,"_13":91,"_37":92,"_39":-5,"_41":42,"_43":93,"_45":46,"_47":94,"_17":95,"_50":24,"_52":96,"_54":55,"_56":-5,"_78":233,"_18":234},{"_34":81,"_13":82,"_37":83,"_39":-5,"_41":42,"_43":84,"_45":46,"_47":85,"_17":86,"_50":51,"_52":87,"_54":55,"_56":-5,"_78":231,"_18":232},{"_34":69,"_13":70,"_37":71,"_39":-5,"_41":42,"_43":72,"_45":46,"_47":73,"_17":74,"_50":75,"_52":76,"_54":55,"_56":77,"_78":229,"_18":230},[],[70],[],[82],[],[91],[],[100,109],[],[100,118],[224,225],[100],[],[19,36],[222],[19],["D",1749151882696],{"_11":12,"_186":182},{"_11":12,"_180":-5,"_181":182,"_142":143,"_183":184,"_185":55},{"_17":84,"_13":16,"_34":42,"_172":133,"_173":-5,"_174":-5,"_175":-5,"_176":-5,"_177":-5,"_178":14,"_179":12},"ctx",{"_165":-5,"_203":282,"_283":284,"_285":286,"_287":55,"_288":55,"_289":55,"_290":46,"_291":-5,"_292":-7,"_293":-7,"_294":149,"_295":55,"_296":55,"_297":-5,"_298":55,"_299":55,"_300":55,"_301":-5},"ENV",{"_253":254,"_255":256,"_257":16,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271,"_272":273,"_274":275,"_276":277,"_278":279,"_280":281},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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"]