web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Odata HTTP Error 400
Small and medium business | Business Central, N...
Answered

Odata HTTP Error 400

(0) ShareShare
ReportReport
Posted on by Hendry_Leo_Yes248 45

I am trying business central 2019 release wave 2 Version: NA Business Central 15.5 (Platform 15.0.41893.0 + Application 15.5.41926.0)

i can see web services list from the default install and can click on the OData link. It opens and ask for password

Sampel URL

192.168.88.103:7048/.../ItemSalesByCustomer

I have tried 2 kinds of password

  • AD User password (also used to login to Business Central, so I know that the combination of user and password is valid)
  • Web Service Key

both give HTTP Error 400

Tried to open the the URL in Postman, also gives error HTTP 400

Where can i start to check what is wrong? Is it because I am using evaluation license?

I have the same question (0)
  • Verified answer
    Hendry_Leo_Yes248 Profile Picture
    Hendry_Leo_Yes248 45 on at

    it is documented by microsoft here (docs.microsoft.com/.../web-services-authentication) and here (docs.microsoft.com/.../walkthrough--viewing-page-data-in-excel-using-powerpivot--odata-)

    Basically I am using on premise installation with Username authentication.

    So my web services also use Username authentication, and Web Service Key can not be used

    The problem is with my client (in this case Google Chrome and Postman) can not pass the correct Digest authentication

    I have success with Insomia Rest Client and Firefox, IE & Edge (old edge, not the one based on chromium)

    So I am going to close this thread.

    Thank you all for the help

  • Hendry_Leo_Yes248 Profile Picture
    Hendry_Leo_Yes248 45 on at

    it is not this setting, I can use both ServicesUseNTLMAuthentication to True and False, without any issue in Internet Explorer of Edge.

    I just can not use Google Chrome

    Edit: Firefox is also good

  • Hendry_Leo_Yes248 Profile Picture
    Hendry_Leo_Yes248 45 on at

    oops, forgot to put the links

    docs.microsoft.com/.../web-services-authentication

    It is also mention here (https://docs.microsoft.com/en-us/dynamics-nav/walkthrough--viewing-page-data-in-excel-using-powerpivot--odata-) that Web Service Key require NavUserPassword credential type.

    So I just need to figure out how Google Chrome and postman can pass my windows credential correctly

  • Hendry_Leo_Yes248 Profile Picture
    Hendry_Leo_Yes248 45 on at

    I can get OData using Edge browser. I have to pass my Windows password, not the Web Service Key.

    It is explained in here.

    Funny thing is I can not use Chrome to get this OData.

  • Marco Mels Profile Picture
    Marco Mels on at

    Hello,

    Best would be to raise a support request with Microsoft support for "offline" analysis.

    Thanks.

  • Hendry_Leo_Yes248 Profile Picture
    Hendry_Leo_Yes248 45 on at

    tried to create user with username@domain format, and DYN365BC will not accept it for Windows Authentication. It will have to be in the format DOMAIN\username or HOSTNAME\username

  • Hendry_Leo_Yes248 Profile Picture
    Hendry_Leo_Yes248 45 on at

    I have also tried hostname\administrator in Postman, also gives 401

    I also have another test with BC SaaS, and the OData works over there.

    Trying to replicate the same with my on premise testing.

    I am actually trying to use OData to import sales data from POS system.

    I have open new thread here (community.dynamics.com/.../using-odata-to-import-sales-transaction)

    Am I walking to dead end?

  • gert-jan.terschure Profile Picture
    gert-jan.terschure 200 on at

    You're now getting a 401, meaning the login is incorrect.

    In the first screenshot (Postman) the username is "Administrator". In the second screenshot (BC) the username is "<Hostname>\Administrator". The username in Postman needs to be the exact username from the second screenshot. Additionally, using hostnames in username isn't recommended. The default Microsoft uses in BC SaaS is the first part of the upn, eg "firstname.lastname@domain".

  • Community Member Profile Picture
    Community Member on at

    I suggest you the follwoing changes:

    change ServicesUseNTLMAuthentication to True

    put the url for Odata nad SOAP

  • Hendry_Leo_Yes248 Profile Picture
    Hendry_Leo_Yes248 45 on at

    what specific key is it?

    attached my customsettings.config,

    have to rename to txt to be able to attach

    PS: This is on premise installation with user login against windows username (local and AD)

    CustomSettings.txt

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,457

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 742 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 669 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans