Format Document Data to HTML in 3 Steps with Dell Boomi

Dell Boomi helps connect the applications that are most important to you, but sometimes it isn’t as simple as clicking a button. We’ll show you how we were able to fulfill a client need by formatting document data into a HTML document for emails using processes within Dell Boomi.

We recently helped a Global Medical Devices company transition from a legacy CRM system to Salesforce. We implemented several integrations between Salesforce, SAP and other enterprise systems. Dell Boomi was used to implement all these integrations.

The customer has a requirement to send email notifications from Salesforce when Orders are received. However, the built-in email functionality within Salesforce was not an answer due to the following challenges:

  • Some of the data is outside of Salesforce

  • Salesforce does not have an easy way to access old values of the modified fields to be included in notifications

  • Dynamic email distribution list depending on the data attributes

Due to seamless integration and ease of data access from various sources offered by Dell Boomi, I decided to implement a custom solution using Dell Boomi to send email notifications. Within the Dell Boomi process, accessing data from different sources was pretty straightforward using Boomi’s standard connectors.  However, I faced a challenge while generating the email content in a presentable format using the “document” data.

I was able to overcome this challenge by converting the document data to HTML format using Map and Data Process shapes. This approach is described in the steps below:

Step 1:  Convert the consolidated document data to custom XML

As seen in the below transformation defined in the Map shape, this step converts the data to an XML document by eliminating other data elements that falls outside of the data formatting requirements and prepares the data to convert to HTML.

Step2: Data Process shape facilitates an easy way to manipulate document contents.

The Data Process does the magic and converts the XML document to HTML friendly data. This is achieved by defining a series of Search/Replace steps to convert the document data to HTML notation. The data is transformed as shown below.

Step 3: A Message shape puts all the data together to create an HTML document required to generate email content

The Message shape refers to the formatted data from the previous steps and other data elements that are required to generate the HTML document using Dynamic Document properties which would have been set prior to the data formatting.

Dell Boomi provides a number of options to extract, manipulate, and validate the document data. These capabilities come quite handy in the scenarios where the document data needs to be formatted to implement a custom solution as described in this blog to meet the customer needs.

Dell Boomi Logo

Learn more about our partnership with Dell Boomi

There’s more to explore at Smartbridge.com!

Sign up to be notified when we publish articles, news, videos and more!