# REST / Odata Compatibility issue **URL:** \ **Category:** Epicor ERP 10\ **Tags:** odata\ **Created:** [May 3, 2019, 9:00pm UTC](https://www.epiusers.help/t/rest-odata-compatibility-issue/55344 "2019-05-03T21:00:48Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![mchinsky](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/ee7513/32.png) [@mchinsky](https://www.epiusers.help/u/mchinsky)\ **Post date:** [May 3, 2019, 9:00pm UTC](https://www.epiusers.help/t/rest-odata-compatibility-issue/55344/1 "2019-05-03T21:00:48Z")
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](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](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](https://ausmtssc001.epicorsaas.com/SaaS205sc/api/v1/BaqSvc) And NOT get an error?? ---
**Author:** ![hkeric.wci](https://www.epiusers.help/user_avatar/www.epiusers.help/hkeric.wci/32/52019_2.png) [@hkeric.wci](https://www.epiusers.help/u/hkeric.wci)\ **Post date:** [May 3, 2019, 9:13pm UTC](https://www.epiusers.help/t/rest-odata-compatibility-issue/55344/2 "2019-05-03T21:13:21Z")
> [@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](https://epiusers.help/t/whats-new-in-epicor-10-2-400/54686/4) ---
**Author:** ![Mark\_Wonsil](https://www.epiusers.help/user_avatar/www.epiusers.help/mark_wonsil/32/51594_2.png) [@Mark\_Wonsil](https://www.epiusers.help/u/Mark_Wonsil)\ **Post date:** [May 3, 2019, 10:36pm UTC](https://www.epiusers.help/t/rest-odata-compatibility-issue/55344/3 "2019-05-03T22:36:54Z")
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. ---
**Author:** ![Olga](https://www.epiusers.help/letter_avatar_proxy/v4/letter/o/57b2e6/32.png) [@Olga](https://www.epiusers.help/u/Olga)\ **Post date:** [May 3, 2019, 10:53pm UTC](https://www.epiusers.help/t/rest-odata-compatibility-issue/55344/4 "2019-05-03T22:53:09Z")
I don’t think [https://ausmtssc001.epicorsaas.com/SaaS205sc/api/v1/BaqSvc/$metadata](https://ausmtssc001.epicorsaas.com/SaaS205sc/api/v1/BaqSvc/%24metadata) ever worked, we only show metadata for 1 BAQ or service. Otherwise, no Excel will survive huge amount of data… ---
**Author:** ![mchinsky](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/ee7513/32.png) [@mchinsky](https://www.epiusers.help/u/mchinsky)\ **Post date:** [May 7, 2019, 3:29pm UTC](https://www.epiusers.help/t/rest-odata-compatibility-issue/55344/5 "2019-05-07T15:29:03Z")
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 ---
**Author:** ![mchinsky](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/ee7513/32.png) [@mchinsky](https://www.epiusers.help/u/mchinsky)\ **Post date:** [May 7, 2019, 3:30pm UTC](https://www.epiusers.help/t/rest-odata-compatibility-issue/55344/6 "2019-05-07T15:30:26Z")
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 ---
**Author:** ![mchinsky](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/ee7513/32.png) [@mchinsky](https://www.epiusers.help/u/mchinsky)\ **Post date:** [May 7, 2019, 3:31pm UTC](https://www.epiusers.help/t/rest-odata-compatibility-issue/55344/7 "2019-05-07T15:31:13Z")
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 ---
**Author:** ![hkeric.wci](https://www.epiusers.help/user_avatar/www.epiusers.help/hkeric.wci/32/52019_2.png) [@hkeric.wci](https://www.epiusers.help/u/hkeric.wci)\ **Post date:** [May 7, 2019, 3:54pm UTC](https://www.epiusers.help/t/rest-odata-compatibility-issue/55344/8 "2019-05-07T15:54:44Z")
![2019-05-07_1155](https://epiusers.help/uploads/default/original/3X/2/5/253562fd1e9f9442e4f1dd811511c0c886744fda.png) ![2019-05-07_1156](https://epiusers.help/uploads/default/original/3X/d/6/d6528702c04c14009172800f678011b3e56b9504.png) ![2019-05-07_1150](https://epiusers.help/uploads/default/original/3X/b/f/bf5bf1234c191bae8a32f0717c0d92228222219d.png) 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). ```auto 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. ```auto 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: ```auto https://EpicorServer/ERP102400/api/v2/odata/EPIC06/BaqSvc/COM-CustContacts/Data ``` Example $metadata ```auto https://EpicorServer/ERP102400/api/v2/odata/EPIC06/Erp.Bo.CustomerSvc/$metadata ``` ---
**Author:** ![mchinsky](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/ee7513/32.png) [@mchinsky](https://www.epiusers.help/u/mchinsky)\ **Post date:** [May 7, 2019, 4:00pm UTC](https://www.epiusers.help/t/rest-odata-compatibility-issue/55344/9 "2019-05-07T16:00:04Z")
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 ---
**Author:** ![Olga](https://www.epiusers.help/letter_avatar_proxy/v4/letter/o/57b2e6/32.png) [@Olga](https://www.epiusers.help/u/Olga)\ **Post date:** [May 7, 2019, 6:06pm UTC](https://www.epiusers.help/t/rest-odata-compatibility-issue/55344/10 "2019-05-07T18:06:11Z")
Probably old driver did not check for metadata and new one does? ---
**Author:** ![mchinsky](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/ee7513/32.png) [@mchinsky](https://www.epiusers.help/u/mchinsky)\ **Post date:** [May 8, 2019, 9:13pm UTC](https://www.epiusers.help/t/rest-odata-compatibility-issue/55344/11 "2019-05-08T21:13:06Z")
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 ![Capture](https://epiusers.help/uploads/default/original/3X/6/4/64401f51e66b1a0a4baa409a3b5b97092858aad7.png) ---
**Author:** ![hkeric.wci](https://www.epiusers.help/user_avatar/www.epiusers.help/hkeric.wci/32/52019_2.png) [@hkeric.wci](https://www.epiusers.help/u/hkeric.wci)\ **Post date:** [May 8, 2019, 10:20pm UTC](https://www.epiusers.help/t/rest-odata-compatibility-issue/55344/12 "2019-05-08T22:20:55Z")
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. ---
**Author:** ![mchinsky](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/ee7513/32.png) [@mchinsky](https://www.epiusers.help/u/mchinsky)\ **Post date:** [May 9, 2019, 1:37am UTC](https://www.epiusers.help/t/rest-odata-compatibility-issue/55344/13 "2019-05-09T01:37:13Z")
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 ---
**Author:** ![GTI07094](https://www.epiusers.help/letter_avatar_proxy/v4/letter/g/49beb7/32.png) [@GTI07094](https://www.epiusers.help/u/GTI07094)\ **Post date:** [October 15, 2019, 10:45pm UTC](https://www.epiusers.help/t/rest-odata-compatibility-issue/55344/14 "2019-10-15T22:45:50Z")
Any updates on this thread? Yesterday I was able to connect but today I can not. Trying to show how we can use this. ---
**Author:** ![A.Baeisa](https://www.epiusers.help/user_avatar/www.epiusers.help/a.baeisa/32/8988_2.png) [@A.Baeisa](https://www.epiusers.help/u/A.Baeisa)\ **Post date:** [October 16, 2019, 7:39am UTC](https://www.epiusers.help/t/rest-odata-compatibility-issue/55344/15 "2019-10-16T07:39:11Z")
have you read this thread ? > [@E10.2.400 + REST + Excel 2016 - Not working for me](https://www.epiusers.help/t/e10-2-400-rest-excel-2016-not-working-for-me/60393/30): > > @richardh working for you? ---
**Author:** ![mchinsky](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/ee7513/32.png) [@mchinsky](https://www.epiusers.help/u/mchinsky)\ **Post date:** [October 16, 2019, 1:00pm UTC](https://www.epiusers.help/t/rest-odata-compatibility-issue/55344/16 "2019-10-16T13:00:26Z")
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. ---
**Author:** ![GTI07094](https://www.epiusers.help/letter_avatar_proxy/v4/letter/g/49beb7/32.png) [@GTI07094](https://www.epiusers.help/u/GTI07094)\ **Post date:** [October 16, 2019, 2:00pm UTC](https://www.epiusers.help/t/rest-odata-compatibility-issue/55344/17 "2019-10-16T14:00:46Z")
This worked on Monday but not since. I had the screens pop up as in the example. ---
**Author:** ![GTI07094](https://www.epiusers.help/letter_avatar_proxy/v4/letter/g/49beb7/32.png) [@GTI07094](https://www.epiusers.help/u/GTI07094)\ **Post date:** [October 16, 2019, 2:19pm UTC](https://www.epiusers.help/t/rest-odata-compatibility-issue/55344/18 "2019-10-16T14:19:51Z")
![odata%20issue](https://epiusers.help/uploads/default/original/3X/9/6/96facabdf9cbe2d05dc8bc228668de8e18f9c472.jpeg) I have attached the error I get. This is within Production or Pilot and as MArk mentioned we are a SaaS ---
**Author:** ![mchinsky](https://www.epiusers.help/letter_avatar_proxy/v4/letter/m/ee7513/32.png) [@mchinsky](https://www.epiusers.help/u/mchinsky)\ **Post date:** [October 16, 2019, 3:13pm UTC](https://www.epiusers.help/t/rest-odata-compatibility-issue/55344/19 "2019-10-16T15:13:36Z")
Did you try that legacy driver option? ---
**Author:** ![GTI07094](https://www.epiusers.help/letter_avatar_proxy/v4/letter/g/49beb7/32.png) [@GTI07094](https://www.epiusers.help/u/GTI07094)\ **Post date:** [October 16, 2019, 3:19pm UTC](https://www.epiusers.help/t/rest-odata-compatibility-issue/55344/20 "2019-10-16T15:19:02Z")
Yes Mark and says its trying to pull a list of tables [Next page](https://www.epiusers.help/t/rest-odata-compatibility-issue/55344.md?page=2)