Would be good if this can be increased to 200 rows similar to Salesforce Search Objects
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