I am designing a Power BI report for summarizing Purchase Orders from Business Central. The users are placing Notes on the Purchase Order but I can't seem to find a way to use an ODATA feed to retrieve these Notes. Is there a web service that I can use to grab these notes from BC to use in a published Power BI report?
Hi, I just tested it last week.
But I am using the API. I created a new API page for record link first.
Then you can get data by record id.
Endpoint URL: https://api.businesscentral.dynamics.com/v2.0/d8f36038-1f93-4543-affc-5dc92b6ee871/Preview20/api/zy/app1/v2.0/companies(c32dda04-259a-ec11-bb89-6045bd8e52fe)/recordLinks?$filter=recordID eq 'Customer: 10000'
PS: "RecordId" contains the table caption and primary key value of a record.
More details: https://yzhums.com/21163/
Hope this also helps.
Thanks.
ZHU
I believe it is not possible to have ODATA for those notes without any development. According to below blog "The answer is the notes are saved in binary format in a blob field (Note) in the Record Link table (2000000068) and the way it maps to the record is using Record ID."
See below picture and you can see it is no Page for Note to publish using ODATA.
You may need talk to developer to see if it is possible to create Query for notes then publish the query as ODATA.
http://www.navisionworld.com/2015/11/how-to-readwrite-notes-in-navision.html
https://thinkaboutit.be/2019/03/how-do-i-use-record-notes-in-an-al-page-or-report/
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... 291,151 Super User 2024 Season 2
Martin Dráb 229,963 Most Valuable Professional
nmaenpaa 101,156