when trying to insert a record on mssql database I am getting this error: statusCode:422 error:"Unprocessable Entity" message:"insert into [dbo].[tableName] ([DESCATTIVITÀSVOLTA], [DURATAMINUTI], [FKEYATTIVITÀGIORNALIERA], [FKEYATTIVITÀMONITORATA], [FKEYCANTIERE], [ORAINSERIMENTO]) output inserted…

@mpmohi Yes, that error generally implies that the db user does not have the proper permissions to run insert queries on that table. You should be able to update the permissions on the db side.

Mssql insert failing

💬 Queries and Resources

joeBumbaca December 21, 2023, 5:39pm 2

Hey @mpmohi! Can you share the query that you are using in Retool? Is this a GUI mode query?

Query Table to rename fields and use in GUI Bulk Insert

Topic		Replies	Views
Error when writing to SQL db on Azure 💬 App Building bug , form	16	2772	May 16, 2024
Insert into database using retool SQL mode - bulk insert 💬 Queries and Resources	2	947	June 21, 2024
SQL Server, not able to use GUI bulk insert 💬 App Building sql	13	486	April 26, 2025
MySQL connection missing table 💬 Queries and Resources resource-connection , mysql	3	2108	May 26, 2023
Workflow SQL INSERT INTO error: syntax error at or near "$1" 💬 Queries and Resources sql , easter-egg-hunt	4	2539	May 14, 2024

Mssql insert failing

Related topics