100 Rows seems pretty low for an enterprise product.
I would like support for at least 50,000 rows.
This would allow me to simplify an integration that requires results of a query be sent to an sftp server as a single file.
To workaround it, we run an on-prem process that runs a sql server stored procedure and writes the results to a .csv file.
The Workato recipe downloads the on-prem .csv file and uploads to the sftp server.
I would like to eliminate the on-prem component of this integration.
Send us a ticket, we will try our best to assist you with your problem
Vivek
Increase Search Row limit for SQL Server
Would be good if this can be increased to 200 rows similar to Salesforce Search Objects
2 people like this idea