Skip to main content

Notifications

Business Central forum
Suggested answer

Creation of an Odata feed based on a query

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,043 Moderator 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

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans