Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Extracting Notes using API

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

Categories:
  • Suggested answer
    NAV_with_Narang Profile Picture
    NAV_with_Narang 2,218 Moderator on at
    RE: Extracting Notes using API

    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

  • ShaishavM Profile Picture
    ShaishavM 215 on at
    RE: Extracting Notes using API

    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
    DAnny3211 Profile Picture
    DAnny3211 9,217 Moderator on at
    RE: Extracting Notes using API

    hi

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

    DANiele

  • ShaishavM Profile Picture
    ShaishavM 215 on at
    RE: Extracting Notes using API

    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
    DAnny3211 9,217 Moderator on at
    RE: Extracting Notes using API

    Hi

    Look this

    learn.microsoft.com/.../dynamics_salesorder_get

    Daniele

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,570 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,683 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans