Hi @geisbelly! Posts usually get more attention if translated into a language the majority of community members have in common. I translated your post to English so more people can find and understand your issue.

Hello, I'm trying to add a dynamic parameter to my API. It works on localhost, but in production, it receives the parameter but doesn't execute as it should and returns all the data and the filtered data in the parameter.

1
import { NextResponse } from ‘next/server’;
2
import { getDbConnection } from ‘…/…/…/config/dbConfig’;
3

4
export async function GET(req: Request) {
5
  try {
6
    const url = new URL(req.url);
7
    const nome = url.searchParams.get(‘NOME’);
8
    console.log(‘Parametro NOME:’, nome);
9
    
10
    const pool = await getDbConnection();
11
    const query = 'SELECT * FROM PERSONAGENS WHERE NOME = @nome';
12
    
13
    const result = await pool.request()
14
    .input('NOME', nome)
15
    .query(query);
16
    
17
    // Process the results
18
    return NextResponse.json(result.recordset.map(item => ({
19
    ...item,
20
    IMGS: JSON.parse(item.IMGS.replace(/\\/g, '')) // Processing images in JSON
21
    }))); // Returns the data
22
  
23
  } catch (error) {
24
    console.error(‘Error fetching data:’, error);
25
    return NextResponse.json({ error: ‘Error fetching data’ }, { status: 500 });
26
  }
27
}

It doesn't show any type of error.