5
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/
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
