Considerations for Data Transformation with Data Processing Engine for Document
Generation
Understand the requirements and guidelines for configuring transformations by using
Data Processing Engine (DPE). Learn how configuration impacts hierarchy, grouping, and
calculated data in a generated document.
Required Editions
Available in: Lightning Experience
Available in: Professional, Enterprise, Unlimited, and
Developer Editions
Include all fields that define relationships. Use these fields to build a hierarchy and
link records.
Object ID, for example Quote ID
Parent reference
Self-lookup fields for bundles and groups
Subtype and writeback structure
One subtype node per context node
One writeback per subtype
Use Composite Writeback to merge outputs
Select JSON structure:
Simple: Flat data, for example, Quote
Hierarchy: Parent-child relationships
Group: Categorized data
Use join to merge computed values with existing data. Use join to:
Add default values
Add formula fields
Include identifier fields to merge correctly data during join. For example:
Quote ID
Quote Line Item ID
Make sure that the template matches the JSON structure:
Use related records for child data
Use children for nested hierarchy
Use grouping fields as headers
Select only required fields in subtype nodes because only selected fields are included in
the output JSON.
Transformation access:
Only Salesforce admins with DocGen Designer licenses can configure
transformations.
At run time, users can execute transformations but can’t configure them.
Support multiple nested levels, including:
Parent-child groups
Nested bundles
Grouping behavior
Works on parent-level and child-level data, such as Quote and Quote Line Items.
Make sure that the grouping field is mapped in the Context Definition.
Alias guidelines
Use clear and meaningful alias names, for example, Price.
Use the same alias consistently across formula node, join node, writeback, and
template.
Alias names are case-sensitive and must match template tokens exactly.
Incorrect alias-mapping results in missing values in the generated document.
Did this article solve your issue?
Let us know so we can improve!
Loading
Salesforce Help | Article
Cookie Consent Manager
General Information
Required Cookies
Functional Cookies
Advertising Cookies
General Information
We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required Cookies
Always Active
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional Cookies
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising Cookies
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.