Appending HTML Lines Using String Builder
  • Updated on 05 Mar 2019
  • 2 minutes to read
  • Print
  • Dark
    Light

Appending HTML Lines Using String Builder

  • Print
  • Dark
    Light

Appending HTML Lines using a String Builder Step requires a few steps to get the data from the database and then select the information needed to Append an HTML line into Text. The String Builder Steps are found in the Steps Tab under Data> Text> Builder.

Example

The flow example below demonstrates how to append HTML lines to the String Builder. The steps used in the flow example are listed below.

Steps:

  • Create String Builder: All Steps [Catalog] > Data > Text > Builder
  • Get all from dbo.ProductData: Integrations> My Integrations> Database> Mock Data (Database)> dbo_Products(Table)
  • ForEach Step: All Steps [Catalog] > Flow Management
  • Append HTML Line: All Steps [Catalog] > Data > Text > Builder
  • To HTML Text: All Steps [Catalog] > Data > Text > Builder

Append-HTML-Lines.jpg

Create String Builder

In the Create String Builder Step s editor under Outputs set the Done path to Rename and enter CreateStringBuilder_Output.
2018-09-07_143019.jpg

Get all from dbo.ProductData

Note: This step is populating data from an integrated database. It is not necessary to integrate with a database, this step should be replaced with the relevant data for your process.

In the Get all from dbo.ProductData the Table will appear under Output Settings and under Output Type. Under Inputs set the Limit count to Ignore or specify the Input. Under Outputs and Done select the data, set to ProductData_Result.
2018-09-07_143420.jpg

ForEach Step

In theForeach Step Editor , select the Data Type and select the collection outcome under  Collection. Under Common Properties and underData select the database that Decisions has been integrated with (Mock Data). Next, underInputs and Collection choose Select From Flow and then pickProducts_Result outcome.

2018-09-07_143758.jpg

Append HTML line

In the Append HTML Line editor underInputs next to line To Add select Merge HTML Text and select Show Editor to add the inputs. Next, to String Builder choose Select From Flow and select the CreatStringBuilder_Output.
2018-09-07_151456.jpg

Show Editor: SelectShow editor to open the Merge Text Editor . Create anHTML text using flow inputs on the left. Select the data from the database that you want to be displayed. Selected below is Current ProductName and Current Product ProductNumber.
2018-09-07_151741.jpg

To HTML Text

In the HTML Text editor under Inputs next to reset Data select Constant and check the box. Next to String Builder set toSelect From Flow and then Pick CreateStringBuilder_Output.
2018-09-07_152016.jpg

Connect the Pathways and Debug the Flow

After theSteps are configured in theProperties Tab underCommon Properties , connect the pathways as displayed. Complete the flow by selecting Debug and verify that the flow works properly.

Was this article helpful?