Skip to main content

Notifications

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

Creation of an Odata feed based on a query

(0) ShareShare
ReportReport
Posted on by 15

Hi,

Is it possible to create a 'custom' odata web service based on a sql query, i.e. is it possible for a 'normal user' without having to pay a developer ?

Sample query

SELECT  Item_No

      ,MIN(Posting_Date) as NewOnStock_Date_UK       

  FROM < the Dynamics table called [item ledger entries export] >

  WHERE Location_Code = 'GIN'

       AND Document_Type =  'Purchase Receipt'

GROUP BY Item_No

ORDER BY Item_No ASC

  • Suggested answer
    Steven Renders Profile Picture
    Steven Renders 5,051 Super User 2024 Season 1 on at
    RE: Creation of an Odata feed based on a query

    No, that's not possible, because of the MIN(Posting_Date) requirement ;-)

    However, you can use the Reporting Data Setup wizard, as a user in BC, to expose Pages/Queries as ODATA web services:

    If you can’t find it in the Assisted Setup, then you can try this link:

    https://businesscentral.dynamics.com/?page=6711

    This runs page 6711, the Setup Reporting Data wizard.ReportingDataSetup.png

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Creation of an Odata feed based on a query

    Hello,

    Maybe create and publish a PowerBi report and embed that in BC?

    Thank you.

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

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans