Global Entry Appointment Checker

\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}","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}",[72],"4dd05e84-287b-11f0-841f-569c3dd06744","cleanup.tsx","4a18880c-287b-11f0-a180-569c3dd06744",["D",1746317049998],1,[81],"dafd1fa8-2877-11f0-ae7d-569c3dd06744","README.md","8222e19c-275a-11f0-bd43-569c3dd06744",45,["D",1746315568845],3,"# 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\nVisit and fill in the details. You can sign up multiple times.\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.",[87],{"_38":86,"_13":87,"_41":88,"_43":-5,"_44":45,"_46":89,"_48":58,"_50":112,"_17":91,"_53":25,"_55":92,"_57":58,"_59":-5,"_100":113,"_19":114},{"_38":80,"_13":81,"_41":82,"_43":-5,"_44":45,"_46":18,"_48":58,"_50":109,"_17":84,"_53":54,"_55":20,"_57":58,"_59":-5,"_100":110,"_19":111},{"_38":71,"_13":72,"_41":73,"_43":-5,"_44":45,"_46":74,"_48":58,"_50":106,"_17":76,"_53":77,"_55":78,"_57":58,"_59":-5,"_100":107,"_19":108},{"_38":61,"_13":62,"_41":63,"_43":-5,"_44":45,"_46":64,"_48":58,"_50":103,"_17":66,"_53":67,"_55":68,"_57":58,"_59":69,"_100":104,"_19":105},{"_38":39,"_13":40,"_41":42,"_43":-5,"_44":45,"_46":47,"_48":49,"_50":99,"_17":52,"_53":54,"_55":56,"_57":58,"_59":-5,"_100":101,"_19":102},["D",1746314269252],"children",[],[40],["D",1746315598490],[],[62],["D",1746317027277],[],[72],["D",1746317049998],[],[81],["D",1746315568845],[],[87],"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,"_168":165},"org",{"_11":12,"_164":165,"_125":126,"_166":167},"branch",{"_17":131,"_13":16,"_38":45,"_156":115,"_157":-5,"_158":-5,"_159":-5,"_160":-5,"_161":-5,"_162":14,"_163":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yd1hma3ZiSng2WWxGZm43QW1GSGFWQW5DNVEifQ","tier","free","profileImageUrl",{"_38":115,"_13":14,"_50":216,"_117":-5,"_118":58,"_119":120,"_121":122,"_123":124,"_125":126,"_127":63,"_128":49,"_129":-5,"_130":131,"_132":133,"_134":135,"_136":-5,"_137":-5,"_138":-5,"_139":-5,"_140":141,"_142":141,"_143":144,"_145":144,"_146":144,"_147":141,"_148":141,"_149":217,"_151":218,"_153":219,"_155":58},[201,202,203,204,205],"files",[201,202,203,204,205],"counts",{"_192":133,"_193":84,"_194":133,"_32":195,"_196":197},[182,183,184,185,186],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"navCollapsed",{"_38":86,"_13":87,"_41":88,"_43":-5,"_44":45,"_46":89,"_48":58,"_50":90,"_17":91,"_53":25,"_55":92,"_57":58,"_59":-5,"_19":191},{"_38":80,"_13":81,"_41":82,"_43":-5,"_44":45,"_46":18,"_48":58,"_50":83,"_17":84,"_53":54,"_55":20,"_57":58,"_59":-5,"_19":190},{"_38":71,"_13":72,"_41":73,"_43":-5,"_44":45,"_46":74,"_48":58,"_50":75,"_17":76,"_53":77,"_55":78,"_57":58,"_59":-5,"_19":189},{"_38":61,"_13":62,"_41":63,"_43":-5,"_44":45,"_46":64,"_48":58,"_50":65,"_17":66,"_53":67,"_55":68,"_57":58,"_59":69,"_19":188},{"_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":187},[40],[62],[72],[81],[87],"pulls","branches","forks",{"_198":133,"_200":133},"connections",{"_198":133,"_199":133},"count","unfilledCount","emptyCount",{"_38":86,"_13":87,"_41":88,"_43":-5,"_44":45,"_46":89,"_48":58,"_50":112,"_17":91,"_53":25,"_55":92,"_57":58,"_59":-5,"_100":214,"_19":215},{"_38":80,"_13":81,"_41":82,"_43":-5,"_44":45,"_46":18,"_48":58,"_50":109,"_17":84,"_53":54,"_55":20,"_57":58,"_59":-5,"_100":212,"_19":213},{"_38":71,"_13":72,"_41":73,"_43":-5,"_44":45,"_46":74,"_48":58,"_50":106,"_17":76,"_53":77,"_55":78,"_57":58,"_59":-5,"_100":210,"_19":211},{"_38":61,"_13":62,"_41":63,"_43":-5,"_44":45,"_46":64,"_48":58,"_50":103,"_17":66,"_53":67,"_55":68,"_57":58,"_59":69,"_100":208,"_19":209},{"_38":39,"_13":40,"_41":42,"_43":-5,"_44":45,"_46":47,"_48":49,"_50":99,"_17":52,"_53":54,"_55":56,"_57":58,"_59":-5,"_100":206,"_19":207},[],[40],[],[62],[],[72],[],[81],[],[87],["D",1746193013221],{"_11":12,"_168":165},{"_11":12,"_164":165,"_125":126,"_166":167},{"_17":131,"_13":16,"_38":45,"_156":115,"_157":-5,"_158":-5,"_159":-5,"_160":-5,"_161":-5,"_162":14,"_163":12},"ctx",{"_149":-5,"_253":254,"_255":256,"_257":58,"_258":58,"_259":58,"_260":-5,"_261":-7,"_262":-7,"_263":133,"_264":58,"_265":58,"_266":-5,"_267":58,"_268":58},"ENV",{"_224":225,"_226":227,"_228":229,"_230":16,"_231":232,"_233":234,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252},"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