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... / SalesOrders API is onl...
Small and medium business | Business Central, N...
Suggested answer

SalesOrders API is only providing Latest months records

(0) ShareShare
ReportReport
Posted on by onplan 15

I am trying to utilise salesOrders API and it's only giving data for current month. 

when I am trying to use date filter it's showing 

"Could not find a property named 'dateFilter' on type 'Microsoft.NAV.salesOrder'. CorrelationId: 0a9d6694-8ffd-4ad0-ad77-09061137c241." 
How can I get all the records?
Categories:
Dynamics 365 Business Central
  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: SalesOrders API is only providing Latest months records

    Hello,

    Feel free to raise it to Microsoft via your partner or CSP.

    Thanks.

  • onplan Profile Picture
    onplan 15 on at
    RE: SalesOrders API is only providing Latest months records

    Hi 

    I am still not getting data older than 2022-04-01 . I can't see any filters applied into business central as well. 

  • yohi2020 Profile Picture
    yohi2020 245 on at
    RE: SalesOrders API is only providing Latest months records

    Hi,

    Give the API url with your filter.

    eg. API URL....salesOrders?$filter=date eq '2022/06/11'

    And please check the url: github.com/.../Guidelines.md

    Thank you,

  • MahGah Profile Picture
    MahGah 15,437 on at
    RE: SalesOrders API is only providing Latest months records

    Hi

    In BC ->  Web services page check that ODATA and see if any filter applied to it.

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,467 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,066 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans