215
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
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,570
Super User 2024 Season 2
#2
Martin Dráb
228,683
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (