Global Entry Appointment Checker

\n Sorry, this only works on the Val Town Pro plan. As is, it will only email the user who owns the val. Fork\n this repo to use it.\n

\n Enter an email address, pick your location(s), and select a date range. Every 20 minutes we will check for\n available appts and send you an email if any are available.\n

\n\n {errors?.map((error) =>

{error}

)}\n \n \n ,\n );\n}\n\nfunction getSubmittedFormHtml(): string {\n return renderToString(\n \n \n \n \n \n Global Entry Appointment Checker\n \n \n

Global Entry Appointment Checker

\n Your request was submitted. Unfortunately, because I'm not on the Val Town Pro plan, all emails are sent to\n me.\n

\n Back\n

\n \n ,\n );\n}","globalentryapptchecker",[62],"4048b0a4-287b-11f0-9147-569c3dd06744","cron.tsx","822cd9ea-275a-11f0-bd43-569c3dd06744",51,["D",1746317027277],20,"interval","import { email } from \"https://esm.town/v/std/email?v=13\";\nimport { fetch } from \"https://esm.town/v/std/fetch\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nexport async function scheduledHandler() {\n // first clean up any old appointments\n await sqlite.execute(`delete from appointments where end_date < date() OR location is null`);\n\n // then check for new appointments\n const result = await sqlite.execute(\n `select email, location, start_date, end_date from appointments where end_date > date() and location is not null`,\n );\n const rows: { email: string; location: number; start_date: string; end_date: string }[] = result.rows.map(row =>\n Object.fromEntries(row.map((value, index) => [result.columns[index], value])) as any\n );\n\n const locationsResult = await sqlite.execute(`select id, name from locations ORDER BY name`);\n\n const locations: { id: number; name: string }[] = locationsResult.rows.map(row =>\n Object.fromEntries(row.map((value, index) => [locationsResult.columns[index], value])) as any\n );\n\n const formatter = new Intl.DateTimeFormat(\"en-US\", {\n dateStyle: \"full\",\n timeStyle: \"short\",\n });\n\n // console.log(rows);\n for (const row of rows) {\n // if start date is before today, use today as start date\n if (new Date(row.start_date) < new Date()) {\n row.start_date = new Date().toISOString().split(\"T\")[0];\n }\n // console.log(\"checking for appointments in \" + row.location + \" between \" + row.start_date + \" and \" + row.end_date);\n\n let result = await fetch(\n `https://ttp.cbp.dhs.gov/schedulerapi/locations/${row.location}/slots?startTimestamp=${row.start_date}T00:00:00&endTimestamp=${row.end_date}T00:00:00`,\n );\n let json = await result.json();\n const activeSlots = json.filter((slot: any) => slot.active === 1);\n\n const locationName = locations.find(location => location.id === row.location)?.name ?? \"unknown\";\n\n // console.log(json);\n if (activeSlots.length > 0) {\n console.log(\"sending email to \" + row.email);\n const body = `Global Entry Appointments Available at ${locationName} at the following times:\\n ${\n activeSlots.map((slot: any) => formatter.format(new Date(slot.timestamp))).join(\",\\n \")\n }`;\n\n await email({\n // to: row.email,\n subject: `Global Entry Appointments available at ${locationName}`,\n text: body,\n });\n } else {\n console.log(`no appointments available for ${locationName} during ${row.start_date} to ${row.end_date}`);\n }\n }\n console.log(\"done\");\n}",[71],"7a30f8b2-287b-11f0-a766-569c3dd06744","cleanup.tsx","4a18880c-287b-11f0-a180-569c3dd06744",55,["D",1746317124451],3,"import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// delete all appointments\nawait sqlite.execute(`delete from appointments`);",[80],"ccb5c7b8-287e-11f0-97d8-569c3dd06744","README.md","8222e19c-275a-11f0-bd43-569c3dd06744",58,["D",1746318551382],5,"# Global Entry Appointment Checker\n\nGlobal Entry doesn't have many appointments available these days, and it's a pain to check constantly to see if any have opened up. \n\nThis script lets you sign up to receive an email if any slots open up at locations you are interested. It will check the location you pick every twenty seconds.\n\nInspired by https://github.com/TobiKr/GlobalEntryAppointmentChecker\n\n## Usage\n\n~~Visit https://globalentryapptchecker.val.run/ and fill in the details. You can sign up multiple times.~~\n\nUntil I pony up for Val Town Pro, this can only send emails to me. So to use, fork this project and run webpage in your own fork.\n\n## Development\n\n`http` contains the logic for the website. `cron` contains the job that sends the emails. `locations` generates the locations table data. Use `cleanup` to erase all submitted appointments.",[88],{"_38":87,"_13":88,"_41":89,"_43":-5,"_44":45,"_46":90,"_48":58,"_50":113,"_17":92,"_53":25,"_55":93,"_57":58,"_59":-5,"_101":114,"_19":115},{"_38":79,"_13":80,"_41":81,"_43":-5,"_44":45,"_46":82,"_48":49,"_50":110,"_17":84,"_53":54,"_55":85,"_57":58,"_59":-5,"_101":111,"_19":112},{"_38":70,"_13":71,"_41":72,"_43":-5,"_44":45,"_46":73,"_48":58,"_50":107,"_17":75,"_53":76,"_55":77,"_57":58,"_59":-5,"_101":108,"_19":109},{"_38":61,"_13":62,"_41":63,"_43":-5,"_44":45,"_46":18,"_48":58,"_50":104,"_17":65,"_53":66,"_55":67,"_57":58,"_59":68,"_101":105,"_19":106},{"_38":39,"_13":40,"_41":42,"_43":-5,"_44":45,"_46":47,"_48":49,"_50":100,"_17":52,"_53":54,"_55":56,"_57":58,"_59":-5,"_101":102,"_19":103},["D",1746314269252],"children",[],[40],["D",1746319019576],[],[62],["D",1746317027277],[],[71],["D",1746317124451],[],[80],["D",1746318551382],[],[88],"82211e7a-275a-11f0-bd43-569c3dd06744",["D",1746193013221],"deletedAt","legacyEnvVars","privacy","public","description","Emails you when global entry appointments are available","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/4a63de04-28fb-4622-0bde-4e35c5069d00/square512","userId","7cda5a30-275a-11f0-a049-f3a9b7a94124","pinnedFileId","pinPreview","pinMigrated","screenshotVersion",82,"likeCount",0,"orgId","c37a85fe-8e69-4626-880f-8320700f0b43","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_169":166},"org",{"_11":12,"_165":166,"_126":127,"_167":168},"branch",{"_17":132,"_13":16,"_38":45,"_157":116,"_158":-5,"_159":-5,"_160":-5,"_161":-5,"_162":-5,"_163":14,"_164":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yd1hma3ZiSng2WWxGZm43QW1GSGFWQW5DNVEifQ","tier","free","profileImageUrl",{"_38":116,"_13":14,"_50":218,"_118":-5,"_119":58,"_120":121,"_122":123,"_124":125,"_126":127,"_128":63,"_129":49,"_130":-5,"_131":132,"_133":134,"_135":136,"_137":-5,"_138":-5,"_139":-5,"_140":-5,"_141":142,"_143":142,"_144":145,"_146":145,"_147":145,"_148":142,"_149":142,"_150":219,"_152":220,"_154":221,"_156":58},[203,204,205,206,207],"files",[203,204,205,206,207],"counts",{"_193":134,"_194":195,"_196":134,"_32":197,"_198":199},[183,184,185,186,187],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"navCollapsed",{"_38":87,"_13":88,"_41":89,"_43":-5,"_44":45,"_46":90,"_48":58,"_50":91,"_17":92,"_53":25,"_55":93,"_57":58,"_59":-5,"_19":192},{"_38":79,"_13":80,"_41":81,"_43":-5,"_44":45,"_46":82,"_48":49,"_50":83,"_17":84,"_53":54,"_55":85,"_57":58,"_59":-5,"_19":191},{"_38":70,"_13":71,"_41":72,"_43":-5,"_44":45,"_46":73,"_48":58,"_50":74,"_17":75,"_53":76,"_55":77,"_57":58,"_59":-5,"_19":190},{"_38":61,"_13":62,"_41":63,"_43":-5,"_44":45,"_46":18,"_48":58,"_50":64,"_17":65,"_53":66,"_55":67,"_57":58,"_59":68,"_19":189},{"_38":39,"_13":40,"_41":42,"_43":-5,"_44":45,"_46":47,"_48":49,"_50":51,"_17":52,"_53":54,"_55":56,"_57":58,"_59":-5,"_19":188},[40],[62],[71],[80],[88],"pulls","branches",1,"forks",{"_200":134,"_202":134},"connections",{"_200":134,"_201":134},"count","unfilledCount","emptyCount",{"_38":87,"_13":88,"_41":89,"_43":-5,"_44":45,"_46":90,"_48":58,"_50":113,"_17":92,"_53":25,"_55":93,"_57":58,"_59":-5,"_101":216,"_19":217},{"_38":79,"_13":80,"_41":81,"_43":-5,"_44":45,"_46":82,"_48":49,"_50":110,"_17":84,"_53":54,"_55":85,"_57":58,"_59":-5,"_101":214,"_19":215},{"_38":70,"_13":71,"_41":72,"_43":-5,"_44":45,"_46":73,"_48":58,"_50":107,"_17":75,"_53":76,"_55":77,"_57":58,"_59":-5,"_101":212,"_19":213},{"_38":61,"_13":62,"_41":63,"_43":-5,"_44":45,"_46":18,"_48":58,"_50":104,"_17":65,"_53":66,"_55":67,"_57":58,"_59":68,"_101":210,"_19":211},{"_38":39,"_13":40,"_41":42,"_43":-5,"_44":45,"_46":47,"_48":49,"_50":100,"_17":52,"_53":54,"_55":56,"_57":58,"_59":-5,"_101":208,"_19":209},[],[40],[],[62],[],[71],[],[80],[],[88],["D",1746193013221],{"_11":12,"_169":166},{"_11":12,"_165":166,"_126":127,"_167":168},{"_17":132,"_13":16,"_38":45,"_157":116,"_158":-5,"_159":-5,"_160":-5,"_161":-5,"_162":-5,"_163":14,"_164":12},"ctx",{"_150":-5,"_255":256,"_257":258,"_259":58,"_260":58,"_261":58,"_262":-5,"_263":-7,"_264":-7,"_265":134,"_266":58,"_267":58,"_268":-5,"_269":58,"_270":58},"ENV",{"_226":227,"_228":229,"_230":231,"_232":16,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","f1316bb1ce3ad41ce227a17bcad7725ad044419f","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","API_URL","https://api.val.town","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier"]

Code