CSV URL Validator

\n \n

\n \n \n \n `;\n return new Response(html, {\n headers: { \"Content-Type\": \"text/html\" },\n });\n } else if (req.method === \"POST\") {\n const formData = await req.formData();\n const file = formData.get(\"file\") as File | null;\n\n if (!file) {\n return new Response(\"No file uploaded\", { status: 400 });\n }\n\n const csvContent = await file.text();\n const urls = parse(csvContent, { skipFirstRow: false }).flat();\n\n const results = await Promise.all(urls.map(async (url) => {\n try {\n new URL(url); // Basic URL validation\n const response = await fetch(url, { method: \"HEAD\" });\n return { url, valid: response.ok, status: response.status };\n } catch {\n return { url, valid: false, status: \"Invalid URL\" };\n }\n }));\n\n // Prepare CSV data\n const csvData = [\n [\"URL\", \"Valid\", \"Status\"],\n ...results.map(r => [r.url, r.valid.toString(), r.status.toString()]),\n ];\n\n const csvOutput = stringify(csvData);\n\n // Return CSV file for download\n return new Response(csvOutput, {\n headers: {\n \"Content-Type\": \"text/csv\",\n \"Content-Disposition\": \"attachment; filename=url_validation_results.csv\",\n },\n });\n } else {\n return new Response(\"Method not allowed\", { status: 405 });\n }\n}","deleted","label",[98],"permalink","https://www.val.town/x/alfred/validateUrlsInCsv/code/main.tsx","extension","actionData","errors"]