Hi,
We want to extract all Notes linked to Sales Header using API (Get).
Since this is a System table, we are unable to extract using normal API Pages.
Is there any other way?
TIA!
Regards,
SM
Hi,
We want to extract all Notes linked to Sales Header using API (Get).
Since this is a System table, we are unable to extract using normal API Pages.
Is there any other way?
TIA!
Regards,
SM
For any reason if you're not able to create an API Page/Query for a system table, you can try for the below workaround
1. AL Developer to create a global Function inside BC, which will extract the contents of the notes into a text field in Sales Header Table. The AL developer can use 2 text fields with 1024 characters each, if you think the notes will be containing good amount of data. It is not suggested to go beyond 2 fields as it will just create clutter. Whatever data after 2048 characters can be truncated (if this works)
2. This function will be triggered by the API or can be called manually at any point. Once this function is called, the notes data will now be populated into your 2 fields
3. Your API can now access the Sales Header table fields easily
Hi Daniele, Thanks for the reply. I am not able to create an API for Notes as this is a system table. Please share should you have any documentation.
hi
To do what you are asking, you need to make a customised API
DANiele
Thanks Daniele.
This only extracts Sales Header data, we want to extract "Notes" attached to the Sales Header.
Notes are stored in a system table called RecordLink Table.
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... 290,570 Super User 2024 Season 2
Martin Dráb 228,683 Most Valuable Professional
nmaenpaa 101,148