[{"_1":2,"_271":-5,"_272":-5},"loaderData",{"_3":4,"_94":95,"_254":255,"_270":-5},"root",{"_5":6,"_31":32,"_63":64},"ctx",{"_7":8,"_19":-5,"_20":21,"_22":23,"_24":25,"_26":25,"_27":25,"_28":29,"_30":25},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers",false,"preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","ENV",{"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58,"_59":60,"_61":62},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","021fc0ad7dc0804a597ded53023b2f830958d870","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","WORKER_FINGERPRINT","963e45ace5b0a45db0aea6fd292ac66b","clerkState",{"_65":66},"__internal_clerk_state",{"_67":68,"_69":42,"_70":71,"_72":71,"_73":25,"_74":71,"_75":71,"_76":71,"_77":71,"_78":71,"_79":71,"_80":71,"_81":71,"_82":83,"_92":25,"_93":25},"__clerk_ssr_state",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__signInForceRedirectUrl","__signUpForceRedirectUrl","__signInFallbackRedirectUrl","__signUpFallbackRedirectUrl","__clerk_debug",{"_84":25,"_85":71,"_86":87,"_88":71,"_89":42,"_90":25,"_91":71},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_96":97,"_98":99,"_100":-7,"_101":71,"_102":-7,"_103":104,"_145":146,"_219":220,"_221":222,"_230":231,"_161":-5,"_250":-5,"_251":-5,"_252":25,"_253":25},"handle","stevekrouse","name","glide_omni","branchName","path","version","project",{"_105":106,"_98":99,"_107":108,"_109":-5,"_110":25,"_111":112,"_113":-5,"_114":-5,"_12":115,"_116":-5,"_117":25,"_118":-5,"_119":29,"_14":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_19":130,"_133":134,"_144":25},"id","ea83c714-d1e8-11ef-a0f6-e6cdfca9ef9f","createdAt",["D",1736798376888],"deletedAt","legacyEnvVars","privacy","unlisted","description","imageUrl","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","pinnedFileId","pinPreview","screenshotVersion","likeCount","e81e7335-6d4c-4764-a902-d0962bbfa9f7","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_96":97,"_131":132},"profileImageUrl","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg","branch",{"_102":135,"_98":40,"_105":136,"_137":106,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":99,"_143":97},92,"2832bb2c-d452-11ef-a9e9-e6cdfca9ef9f","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectUserId","projectName","userHandle","isOwned","tree",[147,169,180,191,199,209],{"_105":148,"_98":149,"_150":151,"_152":-5,"_153":136,"_154":155,"_156":157,"_107":158,"_102":159,"_160":161,"_162":163,"_164":25,"_165":-5,"_166":167,"_101":168},"b66da780-d1eb-11ef-a50b-e6cdfca9ef9f","README.md","fileId","03463a02-d1e9-11ef-bd4d-e6cdfca9ef9f","parentId","branchId","branchVersion",5,"latest",true,["D",1736799577983],4,"fileType","file","content","# glide_omni\n\nThis is an 'Omni API' that generates itself just in time. \n\n## Context\n\nThe intended users of this API are Glide customers, \nwho want to do relatively simple data transformations. For example:\n\n1. Create a new text file in my google cloud storage bucket\n2. Wrap a weather lookup API in a try/catch and return \"Weather not available\" on any errors\n3. Get me the day of the week for tomorrow, ie \"Monday\"\n4. Make an Asana task\n5. Send a newsletter\n6. Parse an ical feed and get today’s events and return them as JSON\n\n## What it does\n\nYou supply a prompt and inputs to the desired API. On the first occurance of\nthat prompt:\n\n1. We ask an LLM to generate the code for endpoint to the prompt's specifications\n2. We create an HTTP val with that code\n3. We call that HTTP val, passing along the inputs\n4. We return the response to the original requester\n\nOn future occurances of the exact same prompt, we lookup the val that corresponds\nto that prompt, pass along the inputs, and the resulting response.\n\n## Architecture & Security\n\n### LLM-generated vals in another account\n\nThis Val Town project is responsible for the top-level API. \nWe create the new llm-generated vals in a _brand new Val Town account_.\nThis adds an extra layer of sandboxing, so that\nthe llm-generated vals cannot access our environment variables or other\nprivate resources. Importantly, the llm-generated vals cannot edit\nthis meta val that is creating them.\n\n### Secrets & env variables\n\nIf the code requires third-party API tokens, those will need to be supplied\non every request to the code that requires them. An issue here is that \ncurrently all request headers and the request body are stored in Val Town logs\nfor at least 10 days. If neccesary, we could build something to disable this.\n\n### LLM-generated vals' API Scopes\n\nThere is a known security issue with this architecture though: \nthe llm-generated vals will have the API scope to edit themselves,\nand other vals in that account. In order to prevent this, we at Val Town\nwill need to add the ability to configure Val API scopes in the Val Town API.\n(Potentially we can hack it with our trpc API?) Either way, before this API is\nused with untrusted users, this vulnerability should be addressed.\nOtherwise user-supplied inputs (which can include secret api tokens\nto third-party services) are at risk of being man-in-the-middle leaked.","deleted","label","children",[],[149],{"_105":170,"_98":171,"_150":172,"_152":-5,"_153":136,"_154":173,"_156":157,"_107":174,"_102":175,"_160":176,"_162":177,"_164":25,"_165":-5,"_166":178,"_101":179},"b71fe766-d299-11ef-9df3-e6cdfca9ef9f","generateCode","4eba0ac2-d1ee-11ef-a0f1-e6cdfca9ef9f",90,["D",1736874311584],19,"script","import { Anthropic } from \"npm:@anthropic-ai/sdk\";\n\nfunction getInputTypes(input: Record): string {\n return Object.entries(input)\n .map(([key, value]) => `${key}: ${typeof value}`)\n .join(\", \");\n}\n\nexport default function parseTypescriptCode(input: string): string {\n // Get code between typescript code fences\n const typescriptRegex = /```typescript\\n([\\s\\S]*?)\\n```/g;\n const matches = Array.from(input.matchAll(typescriptRegex));\n\n // If no typescript blocks found, return empty string\n if (matches.length === 0) {\n throw new Error(\"No typescript blocks found\");\n }\n\n // Get just the code from inside the fence\n const code = matches[0][1];\n\n return code;\n}\nconst system = await (await fetch(`${import.meta.url.split(\"/\").slice(0, -1).join(\"/\")}/system_prompt.txt`)).text();\n\nexport function makeFullPrompt(prompt: string, params: Record): string {\n return `Endpoint description: ${prompt}\nInput types: ${getInputTypes(params)}`;\n}\n\nexport async function generateCode(prompt: string, params: Record): string {\n const anthropic = new Anthropic();\n const response = await anthropic.messages.create({\n model: \"claude-3-5-sonnet-20241022\",\n max_tokens: 1000,\n temperature: 0,\n system,\n messages: [\n {\n role: \"user\",\n content: makeFullPrompt(prompt, params),\n },\n ],\n });\n // console.log(response.content[0].text);\n return parseTypescriptCode(response.content[0].text);\n}",[],[171],{"_105":181,"_98":182,"_150":183,"_152":-5,"_153":136,"_154":184,"_156":157,"_107":185,"_102":186,"_160":187,"_162":188,"_164":25,"_165":-5,"_166":189,"_101":190},"25f51590-d1f9-11ef-ac50-e6cdfca9ef9f","index","0b11a16a-d1f1-11ef-8b45-e6cdfca9ef9f",69,["D",1736805348554],24,"http","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport ValTown from \"npm:@valtown/sdk\";\nimport { generateCode, makeFullPrompt } from \"./generateCode\";\n\nconst vt = new ValTown({\n bearerToken: Deno.env.get(\"GENERATED_VALS_API_KEY\"),\n});\n\nexport const tableName = \"glide_omni_prompts_1\";\nasync function createDatabase() {\n await sqlite.execute(`CREATE TABLE if not exists ${tableName} (\n http_endpoint text,\n prompt text, \n code text\n )`);\n}\n// createDatabase();\n\nexport async function lookupPromptHTTPEndpoint(prompt: string) {\n const results = await sqlite.execute(`SELECT http_endpoint FROM ${tableName} WHERE prompt = ?`, [prompt]);\n return results.rows?.[0]?.[0] as string | undefined;\n}\n\nexport default async function(req: Request): Promise {\n if (req.method !== \"POST\") {\n return Response.json(\"Method not allowed\", { status: 405 });\n }\n const { prompt, ephemeral, ...inputs } = await req.json();\n if (!prompt) {\n return Response.json(\"Please provide `prompt` in the request body\", { status: 400 });\n }\n\n const fullPrompt = makeFullPrompt(prompt, inputs);\n console.log(\"Request with prompt: \", fullPrompt);\n let httpEndpoint = await lookupPromptHTTPEndpoint(fullPrompt);\n\n // create val if it doesn't exist\n if (!httpEndpoint) {\n console.log(\"Creating new val...\");\n const code = await generateCode(prompt, inputs);\n console.log(\"Generated code: \", code);\n const valCreationResponse = await vt.vals.create({\n code,\n type: \"http\",\n privacy: \"unlisted\",\n });\n httpEndpoint = valCreationResponse.links.endpoint as string;\n console.log(\"Created val: \", httpEndpoint);\n\n if (!ephemeral) {\n await sqlite.execute(`INSERT INTO ${tableName} (http_endpoint, prompt, code) VALUES (?, ?, ?)`, [\n httpEndpoint,\n fullPrompt,\n code,\n ]);\n }\n }\n\n // run the val endpoint with the inputs\n const response = await fetch(httpEndpoint, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(inputs),\n });\n const data = await response.json();\n console.log(\"Response data: \", data);\n\n return Response.json(data);\n}",[],[182],{"_105":192,"_98":193,"_150":194,"_152":-5,"_153":136,"_154":135,"_156":157,"_107":195,"_102":159,"_160":176,"_162":196,"_164":25,"_165":-5,"_166":197,"_101":198},"6a2dac6a-d29c-11ef-a965-e6cdfca9ef9f","scratch","04f77132-d297-11ef-9b8a-e6cdfca9ef9f",["D",1736875470978],"console.log(\"asdf\");",[],[193],{"_105":200,"_98":201,"_150":202,"_152":-5,"_153":136,"_154":203,"_156":157,"_107":204,"_102":205,"_160":161,"_162":206,"_164":25,"_165":-5,"_166":207,"_101":208},"be2706de-d299-11ef-9df3-e6cdfca9ef9f","system_prompt.txt","289962cc-d1ec-11ef-af0c-e6cdfca9ef9f",91,["D",1736874323374],13,"You are an expert TypeScript code generator for TypeScript programs\nthat are written for Deno's runtime environment on Val Town's platform.\n\n\n * Response.redirect is broken. Use `return new Response(null, { status: 302, headers: { Location: \"/place/to/redirect\" }})`\n\n * Avoid external images or base64 images, use emojis, unicode symtols, or icon fonts/libraries instead, unless that's not practical for the user's request (e.g. if they ask for a particular animated gif).\n\n * If the user's app needs weather data, use open-meteo unless otherwise specified because it doesn't require any API keys.\n\n * Only use try...catch statements if there's a clear and local resolution to the error.\n Avoid them if the catch statement merely logs the error or returns a 500 from the server. Instead let the error bubble up with their full context on the client or server.\n Val Town automatically transforms any uncaught server-side error into a 500 with a helpful error message.\n\n * You can use Deno-style imports like `npm:luxon` if neccesary.\n\n * Add comments to the code as you write it. Do not add any comments that are not part of the function.\n\n * Do not instruct the user to save the val. Do not instruct the user to deploy the val.\n\n * Output only a valid typescript function – no other explanations or comments.\n\n * All inputs will be provided as JSON-encoded POST bodies\n\n * Prefer returning bare responses if possible, ie Response.json(value), instead of returning a JSON object\n\n * Prefer using JSON-compatible types. Avoid BigInt\n\n * Export the handler as default\n\n\nImmediately before generating code, think step-by-step in a ```thinking code fence about how to respond based on the existing code and the prompt:\n\nReturn the code in a typescript code fence of this format.\n\n\n \n Request with prompt: Endpoint description: Get tomorrow's day of the week, (e.g. 'Monday')\n Input types: today: string\n \n \n ```thinking\n 1. Need to create an endpoint that accepts a date string and returns tomorrow's day name\n 2. Will need to:\n - Parse the JSON body to get the 'today' string\n - Convert string to Date object\n - Add 1 day to get tomorrow\n - Extract the weekday name using toLocaleDateString\n - Return as JSON response\n 3. No external libraries needed, can use built-in Date methods\n ```\n\n ```typescript\n exort default async function(req: Request): Promise {\n // Get input date string from request body\n const { today } = await req.json();\n\n // Parse input date and add 1 day\n const todayDate = new Date(today);\n const tomorrow = new Date(todayDate);\n tomorrow.setDate(tomorrow.getDate() + 1);\n\n // Get day name using toLocaleDateString\n const dayName = tomorrow.toLocaleDateString(\"en-US\", { weekday: \"long\" });\n\n return Response.json(dayName);\n }\n ```\n \n",[],[201],{"_105":210,"_98":211,"_150":212,"_152":-5,"_153":136,"_154":213,"_156":157,"_107":214,"_102":215,"_160":176,"_162":216,"_164":25,"_165":-5,"_166":217,"_101":218},"46e483aa-d297-11ef-b4fc-e6cdfca9ef9f","test","b98e7cc6-d1ed-11ef-a58c-e6cdfca9ef9f",87,["D",1736873264294],22,"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { expect } from \"jsr:@std/expect\";\nimport { makeFullPrompt } from \"./generateCode\";\nimport handler, { lookupPromptHTTPEndpoint, tableName } from \"./index\";\n\ninterface TestCase {\n prompt: string;\n inputs: Record;\n expectedHandler: (...args: unknown[]) => unknown;\n}\n\nconst tests = [\n {\n prompt: \"calculate the nth fibonacci number\",\n inputs: { n: 10 },\n expectedHandler: async (req: Request): Promise => {\n const { n } = await req.json();\n function fib(n: number): number {\n if (n <= 1) return n;\n return fib(n - 1) + fib(n - 2);\n }\n return Response.json(fib(n));\n },\n },\n {\n prompt: \"Get tomorrow's day of the week, (e.g. 'Monday')\",\n inputs: { today: new Date() },\n expectedHandler: async function(req: Request): Promise {\n // Get input date string from request body\n const { today } = await req.json();\n\n // Parse input date and add 1 day\n const todayDate = new Date(today);\n const tomorrow = new Date(todayDate);\n tomorrow.setDate(tomorrow.getDate() + 1);\n\n // Get day name using toLocaleDateString\n const dayName = tomorrow.toLocaleDateString(\"en-US\", { weekday: \"long\" });\n\n return Response.json(dayName);\n },\n },\n {\n prompt: \"Get today's date, formatted like 'Monday, April 1'\",\n inputs: {},\n expectedHandler: () =>\n Response.json(new Date().toLocaleDateString(\"en-US\", {\n weekday: \"long\",\n month: \"long\",\n day: \"numeric\",\n })),\n },\n] as TestCase[];\n\nasync function invokeAPI(input_handler: Function, prompt: string, inputs: Record) {\n const response = await input_handler(\n new Request(\"/\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify({ prompt, ephemeral: true, ...inputs }),\n }),\n );\n const data = await response.json();\n return data;\n}\n\nfunction deletePromptByHTTPEndpoint(endpoint: string) {\n sqlite.execute(`DELETE FROM ${tableName} WHERE http_endpoint = ?`, [endpoint]);\n}\n\nfor (const { prompt, inputs, expectedHandler } of tests) {\n const result = await invokeAPI(handler, prompt, inputs);\n const expectedResult = await invokeAPI(expectedHandler, prompt, inputs);\n expect(result).toEqual(expectedResult);\n}",[],[211],"files",[147,169,180,191,199,209],"counts",{"_223":29,"_224":225,"_226":227,"_228":229},"pulls","branches",3,"forks",1,"envVars",2,"contents",[232,235,238,241,244,247],{"_105":148,"_98":149,"_150":151,"_152":-5,"_153":136,"_154":155,"_156":157,"_107":233,"_102":159,"_160":161,"_162":163,"_164":25,"_165":-5,"_101":234},["D",1736799577983],[149],{"_105":170,"_98":171,"_150":172,"_152":-5,"_153":136,"_154":173,"_156":157,"_107":236,"_102":175,"_160":176,"_162":177,"_164":25,"_165":-5,"_101":237},["D",1736874311584],[171],{"_105":181,"_98":182,"_150":183,"_152":-5,"_153":136,"_154":184,"_156":157,"_107":239,"_102":186,"_160":187,"_162":188,"_164":25,"_165":-5,"_101":240},["D",1736805348554],[182],{"_105":192,"_98":193,"_150":194,"_152":-5,"_153":136,"_154":135,"_156":157,"_107":242,"_102":159,"_160":176,"_162":196,"_164":25,"_165":-5,"_101":243},["D",1736875470978],[193],{"_105":200,"_98":201,"_150":202,"_152":-5,"_153":136,"_154":203,"_156":157,"_107":245,"_102":205,"_160":161,"_162":206,"_164":25,"_165":-5,"_101":246},["D",1736874323374],[201],{"_105":210,"_98":211,"_150":212,"_152":-5,"_153":136,"_154":213,"_156":157,"_107":248,"_102":215,"_160":176,"_162":216,"_164":25,"_165":-5,"_101":249},["D",1736873264294],[211],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","routes/_app.x.$handle.$name.remixes",{"_96":97,"_98":99,"_103":256,"_226":260,"_269":-5},{"_105":106,"_98":99,"_107":257,"_109":-5,"_110":25,"_111":112,"_113":-5,"_114":-5,"_12":115,"_116":-5,"_117":25,"_118":-5,"_119":29,"_14":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_19":258,"_133":259,"_144":25},["D",1736798376888],{"_96":97,"_131":132},{"_102":135,"_98":40,"_105":136,"_137":106,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":99,"_143":97},[261],{"_105":262,"_98":99,"_113":-5,"_114":-5,"_111":263,"_12":264,"_144":25,"_19":265,"_116":-5,"_117":25,"_107":268,"_119":29},"c3017cd4-d9bf-11ef-a255-e6cdfca9ef9f","public","e5615e9f-07dd-4d28-aaa1-9ee23a41135a",{"_96":266,"_131":267},"willthereader","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJObXZ0bE1rbVBEMkhHNzR3SmVmMHc3eldBQiJ9",["D",1737660310535],"upstream","routes/_app","actionData","errors"]