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

Creation of an Odata feed based on a query

(0) Share

Report

Posted on by Andrew Lane Lindy

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

All responses (2)

Answers (0)

Suggested answer

Steven Renders 5,051 Super User 2024 Season 1 on at

Like (0)

Report

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.
Suggested answer

Marco Mels on at

Like (0)

Report

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.