Sorry, I don’t understand the question. What limitations are concerning you? What are you trying to do that you fear you won’t be able to do? The BAQ ecosystem is foundational to much of Kinetic and is used by Epicor in its own development.
I have never run into a row limit with BAQSvc personally. I believe the OData methods do have row limits. There is one sure fire way to find out: Try it! Create a BAQ with the table with the most records, go to Postman and run it.
The service itself, as far as I know, has no limit.
The app/web server, does have a max, that can be overridden I believe, unless you are cloud,
but you can probably ask for that to be removed if there is a good enough reason.
@Olga, could you elaborate, I believe you had a post on it.
My answer is clear. I never ran into a limit with the BAQSvc. I downloaded thousands of records without issue. I tried not to since it generally has been for supporting Excel '97 old-school users. (Coming from me, that’s saying something.) There may be a time limit to an API call, however.
As was I.
What is stopping you from testing it out? In the end, I wouldn’t believe what people tell me on a forum. It works or it doesn’t and there’s only one way to know for sure.
BTW, as a cloud user I might take a different approach for downloading larger files. I would create the file in the EpicorData folder (company or user) and use the Server File Download endpoint to retrieve the file. It’s a cloudier approach.
No, I understand. Sometimes we want answers to solutions that may not be appropriate for the scenario. Give this group your business problem and scenario, and you will find some amazingly smart people (way smarter than I am) with fantastic, clever, and creative ideas.