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?

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

JAngle 150 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

MahGah 15,583 on at

Like (0)

Report
Copy link

Link copied!

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/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 98,311 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No