40
Hi,
I'm trying to load data from the attachment section of an Item (notes, marked in red below) into Power BI but I can't find that page in webservices to get the data from.
I saw on another post that there's a table called "Record Link" but I can't find that table in Webservices. Is it because I don't have the access to it or it's really not available to be read via odata?
Thanks,
Mariana
You get results using the code Steven provided in his blog. However, it is doubling up on the results so that part needs a review at least:
In my case the doubling up is down to some bad data. In any case it is probably best to have an additional filter in place on the recordlink table like so:
Share
Report
All responses (
Answers (
RecordLink.SetRange("Record ID", MyRec.RecordId());
RecordLink.SetRange(Type, RecordLink.Type::Note);
//New filter to isolate notes only from the current company context
RecordLink.SetRange(Company,CompanyName);
APIs are 'faster' then web services in theory, but behind the scenes both are odata ;-)
Queries are in many cases better then pages because queries can aggregate data (group-by & sum).
Images/Notes in Record links are stored encoded, so even if you create an API/webservice it might not work in Power BI.
This is a good guide on how to get the data. As Yun as said an api page is required/best future plan. The code in the post could be adapted to retrieve the details in an api page
https://thinkaboutit.be/2019/03/how-do-i-use-record-notes-in-an-al-page-or-report/
Hi, Standard Web Services and APIs do not correspond to all tables in the system. If you need to, you can create new pages and publish them to Web Services, or create APIs pages directly. I personally recommend APIs pages because its performance is much better than OData.
Hope this helps.
Thanks.
ZHU
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,532
Super User 2024 Season 2
#2
Martin Dráb
228,501
Most Valuable Professional
#3
nmaenpaa
101,148