I am trying the Devart Excel Add-In and when I get to 1000 rows, I get an error saying: "Invalid Search: Requested response size was greater than Search Response Limits. Inner error: The remote server returned an error (422) Unprocessable Entity."
I am using a trial installation but I have successfully retrieved all 100,000 rows in the past so I don't think that's the issue. Any ideas?
The SQL code used in the request is
FROM Ticket AS t"