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
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.
Hello,
Maybe create and publish a PowerBi report and embed that in BC?
Thank you.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,522 Super User 2024 Season 2
Martin Dráb 228,441 Most Valuable Professional
nmaenpaa 101,148