ODATA Feed for Purchase Order Notes

(0) Share

Report

Posted on by MightyJoeC

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?

All responses (3)

Answers (0)

Suggested answer

YUN ZHU 73,110 Super User 2024 Season 2 on at

Like (1)

Report

RE: ODATA Feed for Purchase Order Notes

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

MahGah 15,426 on at

Like (0)

Report

RE: ODATA Feed for Purchase Order Notes

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

JAngle 33,159 on at

Like (0)

Report

RE: ODATA Feed for Purchase Order Notes

This should help you: thinkaboutit.be/.../