Contact us Blog

Including Lightning Notes in generated documents


This article describes how to include content from your Notes from the Lightning Experience in your Salesforce database in documents and email produced by the Apsona Document Generator.

How to use this feature

Currently, the only supported mode is to extract the Lightning Notes into a sublist in either a Word document or an email. To achieve this:
  1. Create a template containing the sublist for the notes, as needed. (Read about merging data into sublists.)
  2. When mapping the sublist's merge fields:
    • Select the Apsona Lightning Notes Surrogate object as the data source, and map the fields of your sublist to the appropriate fields of the object.
    • Add any filtering criteria necessary, e.g., that the Note's Created Date is within the last month.
    • Set up the linkage so that the ParentId field is linked to the Record ID of the parent object whose notes you wish to extract into the document or email.
This will produce the notes in the document.

Objects used

The Lightning Experience stores Notes in the Content Version object, and introduces additional objects - Content Document and Content Document Link - to relate the notes to the other major objects such as Contacts, Accounts or Cases. This data model is more flexible but also less accessible data model. For this reason, Apsona provides a pseudo-object called the Apsona Lightning Notes Surrogate. This object acts a "window" into the Lightning Notes objects, and produces just the fields needed for extracting the Notes data into merged documents and email.

The Apsona Lightning Notes Surrogate object provides the following fields, all of which are read-only.
Field nameData typeDescription
IdStringThe Record ID of the Note
NameStringThe Note's Name (or subject)
FileTypeStringA value that is always set to SNOTE
BodyStringThe body of the note, in HTML
ParentIdLookupRefers to the parent record (Contact, Account, etc.) with which the note is associated
CreatedDateDate/timeThe date and time of creation of the Note
LastModifiedDateDate/timeThe date and time at which the Note was last modified


  • When merging notes into a Word document, the note content is stripped of HTML and rendered as plain text. This is because the Document Merge tool currently does not support the conversion of HTML into Word format. But when merging into an email message, the HTML structure is preserved.