My apologies if you are confused about the REST services so let me try to fix that by giving you a fly over. It’s pretty long and many Geek areas dropped into. If you want something written for normal human being and not geeks, please check out the documentation in the online help. I spent significa…

Apologies, I hit delete a bit hastily. I’m hoping to expose only a select few services over REST to limit the business impact, and sort of ‘pilot’ the new REST interface (over the WCF foundation). With that, I don’t want to go exposing all the business objects, just a few (for example, only Customer…

[image] David: limit the business impact As far as I know you can only enable all or nothing, but there is no business impact to doing so. The REST interface is merely a facade to the existing WCF Services. There is no downside to exposing them all

Ahh awesome, thank you for clarifying that Jose. I thought as such, and this was actually going to be my next question but you’ve read my mind in regards to it being a facade for the WCF.

Jose is correct on implementation. The Method Security is probably the way to go. That is done at the BO level so will cover you no matter which way someone accesses the BO. If we locked down just the REST endpoints, you are just making the minimum code to do damage two lines of code instead of an H…

Has anyone been able to figure out how to get odata to return the list of all BAQ’s? Not in the browser, but to an application like Excel so you can choose. If you connect to a SQL data source in Excel, you can pick the table(s) you want. It seems with odata and epicor, you have to explicitly kno…

If you take that address from the swagger page, and use that to in the from web section in excel, it will walk you through loading a file that will list all of the BAQ’s. It looks like you can refresh that list too. It’s not Odata, it’s XML, but if I could figure it out, it must not be too hard. Not…

Thanks. I probably worded that poorly. I’m not looking for the list of BAQ’s to show up in the excel grid. Rather the Import data screen, when connected to an ODBC or SQL data source will show you the list of ‘tables’ in your database, and then you can select one or more to pull into either excel …

Correct, the scenario you are describing is more of a data mining type scenario. You may want to look at the EDD product to see what I mean. That gives you the flexibility you mention but with a level of security in mind. Excel or any product going directly to the db is not encouraged. Not banned, …

My ultimate problem is that I’m using a Data Warehouse automation product (TimeXtender) that lets you pull in SQL tables and it builds the data warehouse and the SSAS Cubes. However, if I want to build this to work with Epicor SaaS that allows no direct access to SQL but does allow Odata access, I …

REST Overview Novel

Experts' Corner

NickTu (Nick Tu) February 3, 2020, 6:45pm 150

It’s been a while, I think it’s the url referenced by Jose:

Nick

Topic		Replies	Views
Integration Doc - Beta testers needed Experts' Corner	30	7711	November 8, 2017
TechRef WCF Services Guide Epicor ERP 10	25	8386	May 30, 2017
REST installation Epicor ERP 10 rest	26	3086	March 31, 2021
Rest API for Epicor Cloud Epicor ERP 10 api-management	21	14672	October 16, 2019
Does anyone use Excel? Epicor ERP 10	10	1780	November 12, 2016

REST Overview Novel

Related topics