Hi, I would like to know Question 1: what are the limitations of the BAQ in the UI of the Epicor when we execute the Query ? How many rows we can retrieve the BAQ Query? [image] Question 2: what are the limitations of the BAQSvc with REST APi the Epicor? when we call GET Api? How many rows …

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.

How many rows we can retrieve the BAQ Query? How many rows we can retrieve with Childs using REST API using BAQSvc? Are there other limitations should I know when I’m using BAQ with REST API? @Mark_Wonsil Thank you!

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.

@Mark_Wonsil Thank you for your response! BAQSvc it’s fine, Do you know what is the Limitation of the BAQ Query limit how many records it can return in a single Execution of Query?

[image] vinodkumarkaluva: o you know what is the Limitation of the BAQ Query limit how many records it can return in a single Execution of Query? The designer has a limit, that can be overridden. The service itself, as far as I know, has no limit. The app/web server, does have a max, that c…

This is the post I was referring to: [image] REST API for JobEntrySvc/JobEntries only returns 100 results ERP 10 To change/remove the limit use <add key="DefaultMaxRowCount" value="<number or 0 to remove the limit>" /> into web.config section.

@klincecum I know this one This one is normal REST API Standard Points Limit. But My Question is very clear I want to know What is BAQ Query limit and BAQ if I use REST API how many Max records I can get it? NOTE: Yes we are on a Cloud environment.

[image] vinodkumarkaluva: What is BAQ Query limit [image] klincecum: The service itself, as far as I know, has no limit. [image] vinodkumarkaluva: If I use REST API how many Max records I can get it? I just check my cloud web config, and I see no limit set, except for max allowe…

[image] vinodkumarkaluva: But My Question is very clear I want to know What is BAQ Query limit and BAQ if I use REST API how many Max records I can get 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 ge…

@Mark_Wonsil Thank you for your responses! We trying to do some new implementations or new projects We would like to see all kinds of limitations so that’s why I’m putting all these kinds of questions For me to test I don’t have as of now lot of data in my Cloud env so just asked the community wh…

BAQ UI & BAQSvc REST API Limitations

Kinetic ERP

klincecum (Kevin Lincecum) September 15, 2023, 2:47pm 7

This is the post I was referring to:

Topic		Replies	Views
BAQ as a Data Source Kinetic ERP baq	19	1892	April 22, 2024
Rest API Kinetic ERP	9	932	November 8, 2023
Download to Excel Row Limit in KInetic Kinetic ERP epicor	5	919	September 5, 2022
BAQ - 10,000 record limit Epicor ERP 10 e10 , epicor , baq	12	2625	October 20, 2023
What do people really think about BAQ's? Kinetic ERP baq	41	8964	July 5, 2023

BAQ UI & BAQSvc REST API Limitations

Related topics