As we intending to move soon to a version of E10 that supports REST I thought I would trial it with Excel. As far as I know it is working as I have done some simple tests using Postman and I am able to retrieve data. However when I try and add a OData service in Excel I get the error “Microsoft Ex…

On the Epicor side i changed added the 2 tags in web.config EnforceApiKeyForRestApiV2 = false AllowInsecureRestApi = true On the Excel side, for the query I edited the credentials after the initial request threw an error. For example I have tried the sample from the REST setup guide with my own …

disable https - < add key=“AllowInsecureRestApi” value=“True” /> disable app key - < add key=“EnforceApiKeyForRestApiV2” value=“false” /> By natively supporting OData, Epicor ERP web services allow for easy consumption from tools that leverage the protocol. You can have a refreshable spreadshee…

tried that mate, v2 still give me errors, if you could apply it in your environment with some screenshots, i will be very appreciated

[image] richardh: BaqSvc/COM-CustContacts/Data for me it is loading data. https://erp102/erp10/api/v2/odata/epic06/BaqSvc/COM-CustContacts/Data

[image] richardh: On the Excel side, for the query I edited the credentials after the initial request threw an error. this is the bit i am struggling with, i have tried all of it with no lock [image]

Yes. This is the place I added the credentials. I just used one of our system manager accounts.

[image] richardh: http://epicorapp01/E102400LIVE/api/v2/odata/NCPLTD/BaqSvc/COM-CustContacts/Data [image]

[image] richardh: EnforceApiKeyForRestApiV2 = false AllowInsecureRestApi = true where exactly on the web.config did you change this, could you please screenshot it

can you clear existing setting [image] [image] then do setting again as below [image] [image] [image]

[image] richardh: EnforceApiKeyForRestApiV2 change this on the server web.config?

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

Epicor ERP 10

surendrapal (Surendra Pal) October 3, 2019, 11:08am 25

Issues with REST BAQ

Topic		Replies	Views
REST / Odata Compatibility issue Epicor ERP 10 odata	22	6129	October 16, 2019
Issues with REST BAQ Experts' Corner rest	43	13346	October 21, 2019
Excel OData connection to SaaS BAQ Kinetic ERP rest-odata-excel	6	4580	August 17, 2021
Excel and REST - getting started Epicor ERP 10 rest	7	4153	September 3, 2021
Epicor & Power Bi / Excel Epicor ERP 10 e10 , power-bi	9	5020	February 11, 2021

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

Related topics