Command error - cursor.executemany(comandoSQL,valoresInserir)

[TecInfo]

Good morning,
I'm developing a program that records data coming from JSON in the MySQL database, but it's generating the following error.

Error:
Traceback (most recent call last): File "c:\Projetos\api\getCliente\getClienteMySQL.py", line 58, in <module> cursor.executemany(comandoSQL,valoresInserir) File "C:\Python310\lib\site-packages\mysql\connector\cursor_cext.py", line 375, in executemany self.execute(operation, params) File "C:\Python310\lib\site-packages\mysql\connector\cursor_cext.py", line 271, in execute raise ProgrammingError( mysql.connector.errors.ProgrammingError: Not all parameters were used in the SQL statement [Done] exited with code=1 in 2.222 seconds

Code snippet.

while cliente['hasNext'] == True: valoresInserir = [] nPage = nPage + 1 request = requests.get('http://srv009:8080/api/cdp/v1/getCliente?page=' + str(nPage) + '&pageSize=100', auth=('userapi', '1q2w!Q@WAPIpw')) cliente = request.json() for clientes in cliente['items']: valoresInserir.append((clientes['clienteId'], clientes['nomeAbrev'], clientes['nome'])) comandoSQL = f'INSERT INTO cliente (clienteID, nomeAbrev, nome) VALUES (?, UPPER(?), UPPER(?))' cursor.executemany(comandoSQL,valoresInserir) conexao.commit()

Yoriz write Nov-18-2022, 01:44 PM:
Please post all code, output and errors (in their entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to make sure the code is presented as you expect before hitting the "Post Reply/Thread" button.

[buran]

Did you try to add some debug print calls to see what valoresInserir looks like when error happens?

[TecInfo]

Hello,
Problem solved.

while cliente['hasNext'] == True: valoresInserir = [] nPage = nPage + 1 request = requests.get('http://srv009:8080/api/cdp/v1/getCliente?page=' + str(nPage) + '&pageSize=100', auth=('userapi', 'xxxx')) cliente = request.json() comandoSQL = 'INSERT INTO cliente (clienteID, nomeAbrev, nome) VALUES (%s, UPPER(%s), UPPER(%s))' for clientes in cliente['items']: valoresInserir.append((clientes['clienteId'], clientes['nomeAbrev'], clientes['nome'])) cursor.executemany(comandoSQL,valoresInserir) conexao.commit()

buran write Nov-18-2022, 02:26 PM:
Please, use proper tags when post code, traceback, output, etc. This time I have added tags for you.
See BBcode help for more info.