Just starting to use REST V1 - found it works great for small BQAs - Tried to use it on a BAQ with about 7000 lines and when I try to load the ARL all I get is download not complete
How do I help unclog the system
thanks
We need a lot more context as to what / how you are accessing the REST API. Also you should probably use V2 at this point not V1.
It`s possibly an endpoint configuration issue, is this on-premise or SaaS? There are settings in the web.config that define the maximum length of requests…
I am trying to use it on a BQA and dump it to a excel spreadsheet using an odata feed.
It is Saas?
May sound like obvious but try to get the master and transactions in separate BAQs and combine them in Excel. You may not need to bring down everything every time.
Out of curiosity, is there a significant performance advantage to using v2?
I run into the same size limitations with either version
no, another URL and query result representation.
Internally they work the same.
1 Like
I’m assuming you’re running into “Maximum response size reached”?
You may be able to get a more accurate error message on Postman.
You can try adding a parameter or something to your BAQ. Then when you call your BAQ, you can split the data into multiple groups.
For example, with Invoices you can first get all the ones with the Closed field set to true and then with it set to false. This way you’re still getting all data, just into two different results.
Another thing you can try is getting rid of some fields from your data. Fields that you aren’t using in your code that can be trimmed.