HTML Processing

Integration utilities can be used to format data into HTML files using Data Process Logic Studio. This example demonstrates how to retrieve query data using function parameters and display the output in HTML format.

In this example

a. Parameters are retrieved from the Members section.
b. The corresponding properties are displayed in the Properties section of the Function Parameters dialog box.
c. The parameter name InTable is passed to the GetQuery() function.
d. The parameter InTable contains: ParamType: Query, ParamValue: Customers\

Sample Code

using Data Process Logic.DataEngine;
using Data Process Logic.Connectors.ConnectorInterfaces;
using Data Process Logic.IntegrationUtils;

public class HtmlProcessing : IIntegrationFunction {

public void Execute(DataEngine theEngine) {

IntegrationUtils.Initialize(theEngine);

IDataCachedTable tbl = theEngine.GetQuery("InTable");

// Format data as HTML
HtmlTable ht = new HtmlTable(tbl);

// Display table
ht.Display();

// Save the file in the fusion pack directory
ht.Save(@"%FPDIR%\Final.htm");

// Send as Email
ht.SendMail(
"you@YourCompany.com",
"customer@YourCustomer.com",
null,
"Sending HTML file from Data Process Logic",
"mail.riseglobal.net"
);
}
}

Features Demonstrated

This example shows how to:

a. Retrieve query data using Integration Functions
b. Convert query data into HTML format
c. Display HTML content
d. Save HTML files to the Fusion Pack directory
e. Send HTML content through email using Integration Utilities\