Hi Guys, I finally got to 10.2. I am trying to get a basic baq into excel like we did at insights last year! I can view the baq in swagger and it works. When I run it in postman it’s fine. When i try and ran it through excel odata Data → New Query → From OData Feed I get 500 - Internal server …

Is anything in the Servers Windows Event Log?

Download / Run Fidller and see what that request / response looks like.

Version of Excel? I do this ALL the time. No more copy/paste from dashboards… Mark W.

excel is 2016. This query is only in one company but when i make a request in excel it’s in the other company so I need to pass the company parameter. I think this is the issue. Jose: fiddler header is in first post. response is 500 “There is a problem with the resource you are looking for, and it…

Not sure if it matters, i use this syntax for company selection: $URI/api/v1/BaqSvc/$BAQ?Company=‘compID’&… Mark W.

Thanks Mark, Yeah using that syntax gets me a little bit further but it’s now failing on the metadata call For some reason it’s trying https://Server/Epicor/api/v1/BaqSvc/$metadata I thought it should try https://Server/Epicor/api/v1/BaqSvc/BAQName$metadata How do i post xml in here? Trying t…

unfortunately, our BAQ data is not completely compliant to OData standard. That is why new Excel products cannot get BAQ result (IIRC when Company is specified in parenthesis). Try to call BAQ without company name. will it help?

Thanks Mark. This forum needs a code tag. Thanks Olga - yes it seems to be broken on the newest version of excel with the company selector. if i remove the company selector it works fine. I can work around it by using a macro but it would be great to fix this! Cheers Patrick

[image] PatL: This forum needs a code tag. It has one See FAQ Code Syntax Highlighting in Posts - FAQ - Epicor User Help Forum

Well if this works for someone, this is what I have for OData with Excel. I don’t use Postman [image] EPICOR Report from OData ERP 10 Okay, Here it goes! First, we need to create the cells that will act as parameters If yo…

BAQ Odata help

Epicor ERP 10

Mario.Cortes (Alejandro Cortes) May 3, 2018, 6:37pm 12

Well if this works for someone, this is what I have for OData with Excel. I don’t use Postman

Topic		Replies	Views
Working with Odata like sql Epicor ERP 10 odata	15	3941	December 21, 2018
E10.2.400 + REST + Excel 2016 - Not working for me Epicor ERP 10 e10 , rest , excel	34	7822	October 7, 2021
Issues with REST BAQ Experts' Corner rest	43	13355	October 21, 2019
REST / Odata Compatibility issue Epicor ERP 10 odata	22	6131	October 16, 2019
Excel OData connection to SaaS BAQ Kinetic ERP rest-odata-excel	6	4584	August 17, 2021

BAQ Odata help

Related topics