SQL Server, not able to use GUI bulk insert

App Building
1

Hi Retool Team,

I'm tring to dump the result from the changeset to the SQL Server.

I have no issue reading the data from the SQL Server and can insert individual records using Insert in SQL mode. But if I want to use the GUI mode, it shows up this strange error

  • statusCode:422
  • error:"Unprocessable Entity"
  • message:"Login failed for user 'XXXX@XXXX.ORG'."

image
image592×754 28.8 KB

This is the same error I would encounter if I turn off the 'connect using Windows Auth' when setting up the SQL Server connection in Resource. So I wonder if the GUI mode is hornoring the 'Windows Auth' option.

Btw, i use the Retool self-host 3.58.0 and Windows Auth is the only way my organization allows to access the database.

What should I do to bulk insert Retool records to SQL?

2

I'm not strictly have to use GUI mode, but need a way to insert multiple records at a time.

Similar to:

insert into XXX
  select * from {{formatDataAsArray(YYYY.data)}}

But it seems Retool doesn't allow me to crossover the js data and the sql.