[{"_1":2,"_172":-5,"_173":-5},"loaderData",{"_3":4,"_92":93},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20,"_34":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_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,"_63":64},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","adff7c7aeabd218801703bcdcaac3a168cba1c7b","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","clerkState",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":20,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":20,"_91":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_82":20,"_19":20,"_83":73,"_84":85,"_86":73,"_87":46,"_88":20,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_94":95,"_96":97,"_98":99,"_100":101,"_150":151,"_169":170,"_171":-5},"handle","yz3440","name","html-energy-sh-2025","path","airtable-utils.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":-5,"_111":-5,"_12":112,"_113":114,"_115":116,"_117":116,"_118":-5,"_119":32,"_14":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":130,"_133":134,"_136":137,"_149":20},"id","de7059d4-5e73-11f0-bab1-0224a6c84d84","createdAt",["D",1752251219459],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","5f3dbe50-5e72-11f0-978d-1dc0803cb43c","pinnedFileId","de7308fa-5e73-11f0-bab1-0224a6c84d84","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","5f3dbe51-5e72-11f0-978d-1dc0803cb43c","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_131":132},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yempoZnAwc2VTRGtya3BkeW1SWTJVejVPZzkifQ","org",{"_94":95,"_135":132,"_12":112},"avatar","branch",{"_138":139,"_96":44,"_102":140,"_141":103,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":-5,"_147":97,"_148":95},"version",138,"de70d0d0-5e73-11f0-bab1-0224a6c84d84","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":152,"_96":99,"_153":154,"_155":-5,"_156":140,"_157":158,"_159":116,"_104":160,"_138":161,"_162":163,"_164":165,"_166":20,"_167":-5,"_98":168},"5296e378-64ff-11f0-84b2-0224a6c84d84","fileId","48b6c616-64ff-11f0-8465-0224a6c84d84","parentId","branchId","branchVersion",85,"latest",["D",1752970821343],3,"fileType","script","content","import Airtable from \"npm:airtable\";\nimport { RSVPFields, RSVPFieldsSchema } from \"./schema.tsx\";\n\nconst AIRTABLE_BASE_ID = Deno.env.get(\"AIRTABLE_BASE_ID\");\nconst AIRTABLE_ACCESS_TOKEN = Deno.env.get(\"AIRTABLE_ACCESS_TOKEN\");\n\n// Configure Airtable\nAirtable.configure({\n endpointUrl: \"https://api.airtable.com\",\n apiKey: AIRTABLE_ACCESS_TOKEN,\n});\n\nconst base = Airtable.base(AIRTABLE_BASE_ID);\n\nexport interface AirtableRecord {\n id: string;\n fields: RSVPFields;\n}\n\nexport class AirtableUtils {\n private tableName: string;\n\n constructor(tableName: string = \"RSVP\") {\n this.tableName = tableName;\n }\n\n /**\n * Get all records from the table\n */\n async getAllRecords(view: string = \"Table View\"): Promise {\n const allRecords: RSVPFields[] = [];\n\n await new Promise((resolve, reject) => {\n base(this.tableName)\n .select({ view })\n .eachPage(\n (records, fetchNextPage) => {\n for (const record of records) {\n const parsed = RSVPFieldsSchema.safeParse(record.fields);\n if (parsed.success) {\n allRecords.push(parsed.data);\n }\n }\n fetchNextPage();\n },\n (err) => (err ? reject(err) : resolve()),\n );\n });\n\n return allRecords;\n }\n\n /**\n * Get all records with their IDs\n */\n async getAllRecordsWithIds(\n view: string = \"Table View\",\n ): Promise {\n const allRecords: AirtableRecord[] = [];\n\n await new Promise((resolve, reject) => {\n base(this.tableName)\n .select({ view })\n .eachPage(\n (records, fetchNextPage) => {\n for (const record of records) {\n const parsed = RSVPFieldsSchema.safeParse(record.fields);\n if (parsed.success) {\n allRecords.push({\n id: record.id,\n fields: parsed.data,\n });\n }\n }\n fetchNextPage();\n },\n (err) => (err ? reject(err) : resolve()),\n );\n });\n\n return allRecords;\n }\n\n /**\n * Find records by email\n */\n async findRecordByEmail(email: string): Promise {\n let foundRecord: AirtableRecord | null = null;\n\n await new Promise((resolve, reject) => {\n base(this.tableName)\n .select({\n filterByFormula: `{Email} = '${email}'`,\n maxRecords: 1,\n })\n .eachPage(\n (records, fetchNextPage) => {\n if (records.length > 0) {\n const parsed = RSVPFieldsSchema.safeParse(records[0].fields);\n if (parsed.success) {\n foundRecord = {\n id: records[0].id,\n fields: parsed.data,\n };\n }\n }\n fetchNextPage();\n },\n (err) => (err ? reject(err) : resolve()),\n );\n });\n\n return foundRecord;\n }\n\n /**\n * Find records by any filter formula\n */\n async findRecords(\n filterByFormula: string,\n maxRecords?: number,\n ): Promise {\n const foundRecords: AirtableRecord[] = [];\n\n await new Promise((resolve, reject) => {\n base(this.tableName)\n .select({\n filterByFormula,\n ...(maxRecords && { maxRecords }),\n })\n .eachPage(\n (records, fetchNextPage) => {\n for (const record of records) {\n const parsed = RSVPFieldsSchema.safeParse(record.fields);\n if (parsed.success) {\n foundRecords.push({\n id: record.id,\n fields: parsed.data,\n });\n }\n }\n fetchNextPage();\n },\n (err) => (err ? reject(err) : resolve()),\n );\n });\n\n return foundRecords;\n }\n\n /**\n * Create a new record\n */\n async createRecord(fields: RSVPFields): Promise {\n const created = await base(this.tableName).create([{ fields }]);\n return {\n id: created[0].id,\n fields: created[0].fields as RSVPFields,\n };\n }\n\n /**\n * Update a record\n */\n async updateRecord(\n recordId: string,\n fields: Partial,\n ): Promise {\n const updated = await base(this.tableName).update([\n { id: recordId, fields },\n ]);\n return {\n id: updated[0].id,\n fields: updated[0].fields as RSVPFields,\n };\n }\n\n /**\n * Delete a record\n */\n async deleteRecord(recordId: string): Promise {\n await base(this.tableName).destroy([recordId]);\n }\n\n /**\n * Upsert a record by email (delete existing and create new)\n */\n async upsertRecordByEmail(fields: RSVPFields): Promise {\n // Find existing record\n const existingRecord = await this.findRecordByEmail(fields.Email);\n\n // Delete if exists\n if (existingRecord) {\n await this.deleteRecord(existingRecord.id);\n }\n\n // Create new record\n return await this.createRecord(fields);\n }\n}\n\n// Export a default instance\nexport const airtableUtils = new AirtableUtils();","deleted","label",[99],"permalink","https://www.val.town/x/yz3440/html-energy-sh-2025/code/airtable-utils.ts","extension","actionData","errors"]