web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Extracting Notes using API

(0) ShareShare
ReportReport
Posted on by 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

I have the same question (0)
  • Suggested answer
    DAnny3211 Profile Picture
    11,397 on at

    Hi

    Look this

    learn.microsoft.com/.../dynamics_salesorder_get

    Daniele

  • ShaishavM Profile Picture
    215 on at

    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.

  • Suggested answer
    DAnny3211 Profile Picture
    11,397 on at

    hi

    To do what you are asking, you need to make a customised API

    DANiele

  • ShaishavM Profile Picture
    215 on at

    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.

  • Suggested answer
    NAV_with_Narang Profile Picture
    2,294 Moderator on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,917

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,161 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,025 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans