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

Notifications

Announcements

No record found.

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... / Consuming Odata servic...
Small and medium business | Business Central, N...
Answered

Consuming Odata service for On Premise Business Central Deployment

(0) ShareShare
ReportReport
Posted on by SelfStarter 70

Hello Everyone,

I am a starter related to APIs.

Currently I have a requirement where I need to create Customer from a third party application in on premise Business Central environment by consuming odata service.

I already have the web service published for the customer list page.

Now I want to consume the service in postman and create the customer and I am kind of completely stuck as I am not clear with the process of consuming the service in postman.

I tried to do some investigation over internet, all were related to business central hosted environment and not on premise.

I request for some help, as currently I am really not clear where to start and how to proceed.

Please excuse me if my request sounds like spoon feeding.

Thanks in advance for all suggestions

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    JAngle 133 on at

    Check this out: https://youtu.be/f7G7O3a2Aic

    I follow what Adend Jan does for all things BC api wise. Slightly more advanced at times but this video has some great tips!

    Mary does a good intro video too: https://youtu.be/k0yx45TACrE

  • SelfStarter Profile Picture
    SelfStarter 70 on at

    Thanks a lot Josh for replying.

    Both of the videos provide detailed process overview, but the issue is they are for business central hosted environment, my current environment is on premise with windows authentication and thats why I am facing a challenge...

  • Suggested answer
    JAngle Profile Picture
    JAngle 133 on at

    You could be using a web service key (password) and your username. It counts as basic authentication in postman. You can create a web service key from the user record. If you’re on premise then you won’t have to worry as much about this being deprecated in the future versions

  • SelfStarter Profile Picture
    SelfStarter 70 on at

    Hi Josh,

    While testing with GET method, I tried with basic authentication in postman and my windows username and web service key as password but it returned 401 error. Then I changed the authentication to NTLM and used my windows username and password and also provided the domain and also activated the Use NTLM Authentication in NAV Service. With these changes the GET method was able to fetch data from NAV in Postman.

    But for POST method I tried both with basic and NTLM authentication and providing the customer data in the Body in Postman but I got the following error

    {

       "error": {

           "code": "BadRequest",

           "message": "An unexpected 'StartArray' node was found when reading from the JSON reader. A 'StartObject' node was expected.  CorrelationId:  xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx."

       }

    }

    The  above error is for NTLM authentication...

  • SelfStarter Profile Picture
    SelfStarter 70 on at

    Hi Everyone,

    If possible please suggest something for the mentioned issue.

  • SelfStarter Profile Picture
    SelfStarter 70 on at

    Thanks Josh your suggestion helped. I was able to create customer from Postman. But in case of sales invoice I am able to create the header, but when I try to create the lines I get the message

    Status 405 Entity does not support insert.

    Can you please suggest me. I am using the page 516 as the web service to consume for sales invoice line.

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

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 November Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,151

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,443 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,092 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans