Examples

Integration Function Examples

This section provides a sample Integration Function example in DPL Studio for reference.

Example 1: Fetching a Parameter Value and Exporting Data

This example demonstrates how to use Integration Function features.

In this example:

a. A query accepts a string parameter. b. Two function parameters are created:

1. MyIFParam – String type
2. MyIFTable – Query type

The string parameter is passed to the query. An export template named ExportTemplate exports the query result to a text file, and the export status messages are displayed in the output.

Sample Code

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

public class DemoParameters : IIntegrationFunction {
public void Execute(DataEngine theEngine) {

string userParam = theEngine.GetString("MyIFParam");
Console.WriteLine("Parameter Value is " + userParam + "\r\n");

ParamCollection coll = new ParamCollection();
coll["MyParam"] = int.Parse(userParam);

IDataCachedTable tbl = theEngine.GetQuery("MyIFTable", coll);

Console.WriteLine("Parameter Value fetched from table is " + tbl.GetValue(2, 0) + "\r\n");

string msgStack = theEngine.Export("ExportTemplate", coll);

Console.WriteLine("Export Status Messages : "\

• "\r\n" + msgStack);
  }
  }

Sample Output

Parameter Value is 30

Parameter Value fetched from table is 30

Export Status Messages :

Query Data Manager:Created local store
C:\DOCUME1\sheetal\LOCALS1\Temp\DPL2.db

Data Export:Fetching data from query: MyTable

Data Export:MyTable --> temp

Text Connection:Export Started
Data is being exported

Text Connection:Export Completed
Exported 3 rows in 0h 0m 0s

Data Export:Update successfully completed

Query Data Manager:Removed local store
C:\DOCUME1\sheetal\LOCALS1\Temp\DPL2.db