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... / Sales order Get API fo...
Small and medium business | Business Central, N...
Answered

Sales order Get API for single sales order-Error

(0) ShareShare
ReportReport
Posted on by raobc@bnopentext.on... 120

Hi,

I am getting all sales order data using below URL, and how to get single sales order data using Get API

api.businesscentral.dynamics.com/.../Company('CRONUS USA, Inc.')/SalesOrder

If i give URL like

api.businesscentral.dynamics.com/.../systemID/Sandbox/ODataV4/Company('CRONUS USA, Inc.')/SalesOrder('S-100001'), i am getting below error

code": "BadRequest_NotFound",
        "message": "The number of keys specified in the URI does not match number of key properties for the resource 'NAV.SalesOrder'
Categories:
Dynamics 365 Business Central
  • Suggested answer
    raobc@bnopentext.onmicrosoft.com Profile Picture
    raobc@bnopentext.on... 120 on at
    RE: Sales order Get API for single sales order-Error

    issue resolved

  • Suggested answer
    raobc@bnopentext.onmicrosoft.com Profile Picture
    raobc@bnopentext.on... 120 on at
    RE: Sales order Get API for single sales order-Error

    Issue is resolved,

    i used as below

    api.businesscentral.dynamics.com/.../Company('CRONUS USA, Inc.')/SalesOrder('Order','S-ORD101001')

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 77,925 Super User 2025 Season 1 on at
    RE: Sales order Get API for single sales order-Error

    Hi, you can using "id" (keys) or add filters.

    For example,

    All Sales orders.

    api.businesscentral.dynamics.com/.../salesOrders

    pastedimage1654218484193v1.png

    Using id:

    api.businesscentral.dynamics.com/.../salesOrders(5554a3c6-7dd6-ec11-8e7e-000d3a50628c)

    pastedimage1654218507807v2.png

    Using filter:

    api.businesscentral.dynamics.com/.../salesOrders eq '101006'

    pastedimage1654218573495v3.png

    More details abou filter in APIs: https://yzhums.com/6117/#toc8

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    JAngle Profile Picture
    JAngle 63 on at
    RE: Sales order Get API for single sales order-Error

    Maybe the v2 api page is a good idea to use. Will avoid the need to pass in primary key values which seems to be the OData pages issue: docs.microsoft.com/.../dynamics_salesorder_get

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,273 Moderator on at
    RE: Sales order Get API for single sales order-Error

    Hi,

    Can you please please put the filters at the end of your api and check ?

    ?$filters=No_="<your so no.>”

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,307 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans