REST / Odata Compatibility issue

[mchinsky (Mark F Chinsky)]

So my ongoing challenges with Odata continue.
You may not be aware, but Excel has 2 oData drivers, a legacy and a new one. The new one is the same as used in power bi.

https://ausmtssc001.epicorsaas.com/SaaS205sc/api/v1/BaqSvc

Should result in a catalog with a schema of BAQ’s under proper REST guidelines.

If you put this in the legacy driver, excel will return a list of BAQ’s and you can select one OR MORE and pull them into a data model.

If you use the newer driver, you get a 404 Error. I tried it with a datawarehouse tool that used the cData driver and get the same 404 error. Their analysts looked at it and said Epicor isn’t properly supporting the $metadata tag on the service.

IE something like this should work but doesn’t: https://ausmtssc001.epicorsaas.com/SaaS205sc/api/v1/BaqSvc/$metadata

When you access a BO with odata, you are properly getting the schema of all the available tables, but NOT when you use the baq service.

I’ve testing this on 10.2.300 and 10.2.400 with the same results.

Anybody else able to, in excel (o365 version), go to Data>New Query>From Other Sources>from OData feed and put in something like this:https://ausmtssc001.epicorsaas.com/SaaS205sc/api/v1/BaqSvc

And NOT get an error??

[hkeric.wci (Haso Keric)]

@mchinsky

If you use the newer driver, you get a 404 Error.

New Driver Requires API v2

https://epiusers.help/t/whats-new-in-epicor-10-2-400/54686/4

[Mark_Wonsil]

We use office 2016 with REST consumed by OData in Excel every single day - and most of that is the BAQSvc. We are SaaS too but Public Cloud.

[Olga (Olga Klimova)]

I don’t think
https://ausmtssc001.epicorsaas.com/SaaS205sc/api/v1/BaqSvc/$metadata ever worked, we only show metadata for 1 BAQ or service. Otherwise, no Excel will survive huge amount of data…

[mchinsky (Mark F Chinsky)]

Do you have an example of the v2 syntax. Is that available in 10.2.300?

The Rest help page built into epicor only shows V1

[mchinsky (Mark F Chinsky)]

But you can’t do one Rest call and pull in multiple BAQ’s into excel like you can with, for say, a business object which has multiple tables

[mchinsky (Mark F Chinsky)]

Why can the legacy excel driver show you the list of all baq’s and you can select 1 or more and they come in as separate tables?

The new driver throws in an error

[hkeric.wci (Haso Keric)]

1. REST Service Root URL has changed the format to include the current Company. The /api/v1/ segment of the request URL has been replaced with /api/v2/odata/.
2. The format of Business Activity Queries (BAQs) data requests has changed to include /Data in the request URL. This is critical for enabling REST API compatibility with Microsoft® Excel® 2016/365. Refer to the BAQ Feeds topic of this guide for detailed information and examples (Display Data in OData Applications Display in Excel Table).

https://[EpicorServer]/[ERPInstance]/api/v2/odata/[Company]/BaqSvc/[BaqName]/Data?[baqParam1]=x&[baqParam2]=y

For the URL, enter the resource you wish to display in this Excel spreadsheet.

https://EpicorServer/ERP102400/api/v2/odata/EPIC06/Erp.Bo.CustomerSvc/Customers

The following URL can be used to display data from the Customer Contacts Business Activity Query:

https://EpicorServer/ERP102400/api/v2/odata/EPIC06/BaqSvc/COM-CustContacts/Data

Example $metadata

https://EpicorServer/ERP102400/api/v2/odata/EPIC06/Erp.Bo.CustomerSvc/$metadata

[mchinsky (Mark F Chinsky)]

It says to refer to the baq feeds section of ‘this guide’. Do you have a link to where you got this or can you tell me where to locate it? Epicor has a built in web page for the rest stuff, but it all relates to v1.

Thanks a million

[Olga (Olga Klimova)]

Probably old driver did not check for metadata and new one does?

[mchinsky (Mark F Chinsky)]

So trying all these V2 links throws an internal server error (i.e. V2 isn’t running). I’m running 10.2.300.

Does something need to be done to enable version 2?

See attached screenshot

[hkeric.wci (Haso Keric)]

v2 is for 10.2.400 - Since you mentioned it on top I assumed you were on 10.2.400.

v1 does not work with the New Adapter to my understanding or atleast doesnt for me anymore since a Office 365 Update I get a 404 - but Legacy is fine.

[mchinsky (Mark F Chinsky)]

V1 seems to work fine to bring a single BAQ in and it works fine to bring in a BO with the new excel adapter

[GTI07094 (John Dillon)]

Any updates on this thread? Yesterday I was able to connect but today I can not. Trying to show how we can use this.

[A.Baeisa (Al)]

have you read this thread ?

E10.2.400 + REST + Excel 2016 - Not working for me

@richardh working for you?

[mchinsky (Mark F Chinsky)]

Just remember that this web.config fix is not available to those on SaaS because Epicor won’t make a config change as it applies to multiple customers in this multi-tenant hybrid hosting arrangement they have.

[GTI07094 (John Dillon)]

This worked on Monday but not since. I had the screens pop up as in the example.

[GTI07094 (John Dillon)]

I have attached the error I get. This is within Production or Pilot and as MArk mentioned we are a SaaS

[mchinsky (Mark F Chinsky)]

Did you try that legacy driver option?

[GTI07094 (John Dillon)]

Yes Mark and says its trying to pull a list of tables