I’m using the /api/v1/Erp.BO.JobEntrySvc/JobEntries endpoint to try and query for all open jobs with $filter=JobComplete eq false . When I hit any endpoint in the JobEntrySvc really, it only returns 100 records. The real issue here is that when I use $inlinecount=allpages, it always says 100 (even…

Hi Jon ( @jgr3go ), You can use the $top parameter to change the number of rows returned in the single query. /api/v1/Erp.BO.JobEntrySvc/JobEntries?$top=1000 for example. I’m also seeing an empty result set when using $skip=100 alone. If I use $skip=100 AND $top=100 it returns the next 100 records.…

If you are not a cloud customer, you can switch that limit off in web.config

Hello Olga! Is this true for the BAQSvc too? I don’t remember seeing that behavior here in the class. Thanks, Mark

Hi Olga, Please specify the parameter.

It looks like using $top with $skip does work, I don’t think that’s expected behavior. It’s not the case in other services. That said, once you apply $inlinecount=allpages again it totally breaks. So it looks like there’s a bug in this service, at least. I’m a cloud customer, so there’s nothing i…

I think so, but it was long time ago when I looked

Sorry to Necro - but I have this same issue! Which section of the web.config gets this added key? Is it like this? <security> <requestFiltering> <requestLimits maxAllowedContentLength="4294967295" />  </requestFiltering> </security> `` edited to remove potentiall…

i don’t think so, it should be just in appSettings in Host.config (or web.config on pre .NET6)

Thank you! It didn’t crash my DEV setup, anyways - I’ve asked the integrating developers (ETQ) to confirm it works and I’ll report back here.

REST API for JobEntrySvc/JobEntries only returns 100 results

Epicor ERP 10

Olga (Olga Klimova) April 19, 2019, 3:35pm 7

To change/remove the limit use
<add key="DefaultMaxRowCount" value="<number or 0 to remove the limit>" /> into web.config section.

BAQ UI & BAQSvc REST API Limitations

Topic		Replies	Views
Epicor REST Pagination Epicor ERP 10 epicor , rest	11	4787	December 8, 2020
REST Api - QuoteSvc - Not consistently return results Epicor ERP 10 rest	17	3433	November 29, 2018
REST JobEntrySvc/JobOpers Epicor ERP 10 rest	18	1692	February 21, 2018
Rest Query Requires Top Function Epicor ERP 10 rest	6	1449	November 30, 2020
Excel Rest query with Odata returns first 100 lines of any given table Epicor ERP 10 rest	5	1899	September 28, 2020

REST API for JobEntrySvc/JobEntries only returns 100 results

Related topics