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	2834	May 16, 2024
Insert into database using retool SQL mode - bulk insert 💬 Queries and Resources	2	1045	June 21, 2024
SQL Server, not able to use GUI bulk insert 💬 App Building sql	13	535	April 26, 2025
Workflow SQL INSERT INTO error: syntax error at or near "$1" 💬 Queries and Resources sql , easter-egg-hunt	4	2666	May 14, 2024
Can't query table in Retool DB 💬 Queries and Resources bug , sql , table	6	588	December 6, 2023

Mssql insert failing

Related topics