I’m having an issue adding parameters for API calls only on some tables/services, hoping someone here can give me a clue of what’s going on, my problem is: I can do this command and it works fine: https://myServer/api/v2/odata/myCompany/Erp.Bo.QuoteSvc/Quotes?$select=QuoteNum&$orderby=QuoteNum des…

[custommethods2] Edit: Removed my company info lol.

[welcome jurassic park GIF] Ok, question time :rofl: Is there a particular reason you are using the straight odata calls? What business problem are you trying to solve. Many ways to get data in Epicor, let’s find you the right one.

Hi there, thanks for answering. I’m building a custom application within our CAD system that generates quotes for our projects. I want to push the quote and quote lines into Epicor. I’ve done simpler ones so far and it works great, the issue came about when accessing the QuoteDtls and QuoteQties t…

Well my default answer is always going to be call a function or a baq instead, but failing that, use the custom methods, not the odata. The odata has some quirks.

Thanks this definitely gives me something to think about, as far as I understood this was the way to call the actual methods just from reading the docs on the API help website: [image] I feel like I’m missing something, what is it? Yeah about the BAQ, I can also use that if needed, but I would t…

100% best way to learn how to do something in Epicor, is first search here. 99.99175% next best way is to learn how to do tracing, in both the classic and web clients.

Lol why would they make the other one not the default. Also custom methods sounds a lot more well… “custom” than “data” and “getrows”. Thanks this does help a lot, I’m going to play around with it for a bit.

[image] rmerlob: Thanks this does help a lot, No problem bud. Hang out. This place is great in general, and a massive resource.

[image] rmerlob: Yeah about the BAQ, I can also use that if needed, but I would think that for something simple like this a “standard” service was the best option. The BAQ is far more powerful than the standard services. You can reduce the number of columns returned, reduce the number of rows…

Yeah BAQs do have some nice things, but for something like quote creation, just sending a POST to the QuotesSvc/Quotes did seem like a nice choice, I was then able to add anything else I needed through a similar service. Now I’m looking at those Custom methods @klincecum suggested, the GetRows seem…

[image] rmerlob: What is the “standard” way to GET and POST data to/from Epicor? Write that crap in a function using the business objects and call that from your app. [bam yes GIF]

Rest API $orderby error in some services

Kinetic ERP

klincecum (Kevin Lincecum) May 31, 2024, 5:15pm 15

Understandable. But learning the tooling will make your life MUCH easier.

In this thread here, I link a couple threads, plan to do a new write-up, but life ya know?

The threads in there are these:

And in this thread, we share them: (Plenty of examples.)

https://www.epiusers.help/t/lets-share-useful-functions-sharing-is-caring/100371

Topic		Replies	Views
Filters not working on some BO's when called through API, or inconsistent Kinetic ERP	14	788	October 8, 2024
REST Api - QuoteSvc - Not consistently return results Epicor ERP 10 rest	17	3430	November 29, 2018
REST url sorting works in browser, not in excel Epicor ERP 10 rest	5	626	January 6, 2023
Issues with REST BAQ Experts' Corner rest	43	13381	October 21, 2019
REST Question Epicor ERP 10	29	1851	July 3, 2018

Rest API $orderby error in some services

Related topics