It appears that the BAQ Service is not returning results for $metadata so this is causing compatibility problems with Excel and other modern Odata readers. Business Objects do. Has anybody else seen this?

Thanks Brian a lot of awesome info here!! :raised_hands:

@bconner Thanks for all the great information! I have only heard amazing things about EDA and I believe that it is absolutely the solution for 80-90% of the Epicor customers. There will be a very small group who will build their own solution though. I think an easy feature would be to add modern e…

FWIW we’re very aware of the CDM and the rest of the azure analytics/data stack data lake included. I just came back from build with a whole new set of new services to play around with in fact. You can see us starting to use select things like IoT Hub in products now. Anyway better ways to ETL to a…

@bconner Awesome! I assume that you already did a lot of this CDM work for Azure Search with your Epicor Virtual Assistant product?

Someone tell the XL Connect Team to stop lobbying against this… sarcasm Thank you for all the info, and keep up the good work.

Thanks Brian. I’m going to try out the cdata driver. The thing that is so painful is if you use the legacy Excel driver (which is hidden but still available), you can connect to the BAQ Service, then see a list of every BAQ, then pick the ones you want and pull them all into excel. It works exact…

It also appears the problem with trying to use the Service to return the data is you can only do so for one company at a time. If I’m trying to build a solution that can support any client who might have 1, or might have 10 companies in their database, this won’t work unless I built a custom wareho…

[image] mchinsky: The thing that is so painful is if you use the legacy Excel driver (which is hidden but still available), you can connect to the BAQ Service, then see a list of every BAQ, then pick the ones you want and pull them all into excel. It works exactly like sql and is perfect. Unfor…

[image] John_Mitchell: @bconner Awesome! I assume that you already did a lot of this CDM work for Azure Search with your Epicor Virtual Assistant product? I can’t speak to that one - haven’t been significantly involved in the EVA skills development.

Thanks Brian. That was very helpful. However with EDA it seems you just bypass this whole issue and do direct SQL statements to the database and then send the data to Phocus’s data warehouse servers. Then, of course, Epicor allows the Epicor SaaS group to install the EDA extraction program to be …

Issues with REST BAQ

Experts' Corner

A.Baeisa (Al) October 18, 2019, 6:57am 41

For everyone Information, this issue has been solved

Topic		Replies	Views
REST / Odata Compatibility issue Epicor ERP 10 odata	22	6096	October 16, 2019
Pulling BAQ into Excel - Web API, OData, JSON? Kinetic ERP e10	75	14264	April 26, 2023
E10.2.400 + REST + Excel 2016 - Not working for me Epicor ERP 10 e10 , rest , excel	34	7788	October 7, 2021
Working with Odata like sql Epicor ERP 10 odata	15	3895	December 21, 2018
Excel OData connection to SaaS BAQ Kinetic ERP rest-odata-excel	6	4553	August 17, 2021

Issues with REST BAQ

Related topics