Why would this not be catching data?

[Elindo586]

Summary

So I had this code working fine, but suddenly stopped? go figure.. and update?

The latest code which was working is this here:
https://github.com/Elindo586/contact/blob/main/app/api/sendgrid/route.js

^^^ from here I did a bunch of other test and changes from my localhost, and now that code doesn't work either..

It was actually loading info to the DB, now it doesn't even do that..

I just gives me a straight 502 Bad Gateway..

Wonderful ChatGPT tells me to run it on node.js run time?

Additional information

No response

Example

No response

[icyJoseph]

A couple of things to verify...

• DATABASE_URL is it still valid?
• SENDGRID_API_KEY

There must be some logs though...

What does this print?

  } catch (error) {
    console.error("❌ Error:", error);
    return NextResponse.json({ error: error.message }, { status: 500 });
  }

Also upgrade your Next.js version to 15.5.12

[Elindo586]

Database key was fine..
sendgrid key was not... what a pain
Thanks..

weird thing that it was recording on the database until I started changing things...

[Elindo586]

Well..

I uploaded the new file to github and the upload went through even if it doesn't work.

DATABASE_URL is it still valid? <--- even this morning I was logging into the database, but it didn't send mails.... now it doesn't log into the database.

SENDGRID_API_KEY <-- yes.. checked it.

I rant npm run built and got this:
D:\EdgarLindo\things\Stuff\Acode\contact> npm run build

build
next build

▲ Next.js 16.1.6 (Turbopack)

• Environments: .env.local

  Creating an optimized production build ...
  Turbopack build encountered 2 warnings:
  ./app/api/sendgrid-webhook-test/route.js:28:57
  Next.js can't recognize the exported config field in route. Page config in config is deprecated and ignored, use individual exports instead.
  26 | }
  27 | }const SENDGRID_SECRET = process.env.SENDGRID_SECRET.replace(/\n/g, '\n');

28 | const sql = neon(process.env.DATABASE_URL);export const config = {
| ^^^^^^
29 | api: {
30 | bodyParser: false,
31 | },

The exported configuration object in a source file needs to have a very specific format from which some properties can be statically parsed at compiled-time.

https://nextjs.org/docs/app/api-reference/file-conventions/route-segment-config

./app/api/sendgrid-webhook/route.js:44:14
Next.js can't recognize the exported config field in route. Page config in config is deprecated and ignored, use individual exports instead.
42 | const sql = neon(process.env.DATABASE_URL);
43 |

44 | export const config = {
| ^^^^^^
45 | api: {
46 | bodyParser: false,
47 | },

The exported configuration object in a source file needs to have a very specific format from which some properties can be statically parsed at compiled-time.

https://nextjs.org/docs/app/api-reference/file-conventions/route-segment-config

✓ Compiled successfully in 2.3s
✓ Finished TypeScript in 63.1ms
✓ Collecting page data using 31 workers in 1572.4ms
✓ Generating static pages using 31 workers (18/18) in 471.4ms
✓ Finalizing page optimization in 5.1ms

Route (app)
┌ ○ /
├ ○ /_not-found
├ ƒ /api/click/[product]
├ ƒ /api/sendgrid
├ ƒ /api/sendgrid-team05
├ ƒ /api/sendgrid-webhook
├ ƒ /api/sendgrid-webhook-test
├ ƒ /api/telnyx-webhook
├ ƒ /api/telnyx-webhook2
├ ƒ /api/un/[email]
├ ƒ /camp-host/12-11-25/[email]/[campid]/[title]/[name]
├ ○ /card
├ ○ /card1
├ ƒ /productsfor/[email]
├ ƒ /tables/alter-drop
├ ƒ /tables/create
├ ƒ /tables/create-short
├ ƒ /tables/delete-row
├ ƒ /tables/drop
├ ƒ /tables/table-copy
└ ƒ /tables/truncate

○ (Static) prerendered as static content
ƒ (Dynamic) server-rendered on demand

PS D:\EdgarLindo\things\Stuff\Acode\contact>

[Elindo586]

This is the current package.json

"scripts": {
"dev": "next dev",
"build": "next build",
"start": "next start",
"lint": "next lint"
},
"dependencies": {
"@neondatabase/serverless": "^1.0.1",
"@sendgrid/mail": "^8.1.6",
"bootstrap": "^5.3.7",
"file-saver": "^2.0.5",
"formidable": "^3.5.4",
"mailparser": "^2.3.0",
"mime": "^4.0.7",
"next": "^16.1.6",
"nodemailer": "^8.0.0",
"qrcode": "^1.5.4",
"querystring": "^0.2.1",
"react": "^19.2.4",
"react-dom": "^19.2.4",
"starkbank-ecdsa": "^1.1.5"
},
"devDependencies": {
"eslint": "9.32.0",
"eslint-config-next": "15.4.5"
}
}

[Elindo586]

BTW..

I did fix the | export const config = { error... at least it isn't giving me an error on build anyway..

The api/sendgird doesn't give me errors on build either, but it just doesn't work... just gives me bad Gateway..