Small and medium business | Business Central, N...

eb service access key is no longer supported as authentication. Please use OAuth

(1) Share

Report

Posted on by CU07101338-0

254

Hello everyone!

I hope you are doing well!

I remember a few years ago, I could create web service and used Odata for my excel and Power BI project. But now I have created a web service (Item Reference page) like the image but I see the error:

{"error":{"code":"Authentication_InvalidCredentials","message":"Web service access key is no longer supported as authentication. Please use OAuth.

I would appreciate if you could tell me what is the solution?
Thanks in advance

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

Ramiz 597 on at

Like (1)

Report

Hi,

You need an O-Auth for accessing web services now.

Hope this helps.
https://yzhums.com/20690/

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,441 Super User 2025 Season 2 on at

Like (2)

Report

Web Service Access Key is deprecated and is no longer supported for authentication in Business Central. Microsoft now mandates the use of OAuth 2.0 for secure authentication.

Hope this helps:

https://yzhums.com/37488/

https://yzhums.com/30177/

https://www.encorebusiness.com/blog/how-to-enable-oauth-for-dynamics-365-business-central/

Use following to set OAuth2

https://yzhums.com/20690/

https://community.dynamics.com/blogs/post/?postid=626eba3e-1cef-4552-8dac-bd45ff8ac93f

Was this reply helpful? Yes No
CU07101338-0 254 on at

Like (1)

Report

Thanks for your kind replies!

I tried to do the steps based on the given link (https://yzhums.com/20690/).

I am not sure about this part of the article:

Enter the redirect URl of the application, and then choose Configure.
For example: https://localhost:8080/login

What should I put for my URL? https://businesscentral.dynamics.com/ this one or this https://api.businesscentral.dynamics.com/v2.0/942220cb-7074-4cd9-a22e-295996e916a9/Production/ODataV4?

Anyway, I tried both but unfortunately, I cannot see the page Azure Active Directory Applications in Business Central? or in the user card I cannot see a web service section to put my keys there!

Does anyone know how to do that?
Thanks in advance!

Was this reply helpful? Yes No
Suggested answer

Ramiz 597 on at

Like (1)

Report

Hi,

You can put this URL in the redirect URL of the app.

https://businesscentral.dynamics.com/OAuthLanding.htm

In Business Central, search for page Microsoft Entra Applications

Was this reply helpful? Yes No
CU07101338-0 254 on at

Like (0)

Report

Thanks for your time,

Yes, the link is working and I have completed the process.
but, in a few years ago, I remember I used web service (Odata) for excel and Power BI, but now how can I use the link in Excel for instance?

Thanks!

Was this reply helpful? Yes No
Suggested answer

Ramiz 597 on at

Like (1)

Report

Hi,

Excel still has OData and other data sources that you can use. Are you trying to consume Business Central API in excel to make some reports?

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,441 Super User 2025 Season 2 on at

Like (2)

Report

Could you elaborate your goal so we can help further.

Was this reply helpful? Yes No
CU07101338-0 254 on at

Like (1)

Report

Thanks for your kind responses!
Yes, Excel can support Odata, but Microsoft has changed its process.
a few years ago, I could use web services like this https://api.businesscentral.dynamics.com/v2.0/942220cb-7074-4cd9-a22e-295996e916a9/Production/ODataV4/ and I noticed Microsoft has changed the procedure.
So, I completely proceed the given link steps, but still the link is not working.
I still see the same error.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,225 Most Valuable Professional on at

Like (2)

Report

Hi, good day
I hope this can help you, and give you some hints.

The comprehensive guide to using Business Central Excel Report Metadata with refreshable APIs – BC Development Notebook

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Ramiz 597 on at

Like (1)

Report

Hi @CU07101338-0,

You need to login with the Organizational account. Click on it and then signed it with the account and it will work.

Was this reply helpful? Yes No