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
#1
André Arnaud de Cal...
291,419
Super User 2024 Season 2
#2
Martin Dráb
230,492
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
