InfoSet Parameters

InfoSet parameters are placeholders that you include within the data source. Smart Notification replaces parameters with actual values when it retrieves data from a data source.

The format you use to enter parameters is [parameter]. You can also specify optional default values.

Note: SQL Server uses [ ] for names that include spaces. For example,

SELECT
        column1 AS [My Column] FROM table1

. In this example, you do not need to provide a parameter value if [My Column] is the desired name. When prompted for parameters in these cases you can leave the parameter blank.

Using the Delimited Document data source

Use the Delimited Document data source type to set up separate .CSV files as data sources.

Example

Set the file name in the InfoSet at C:\MyPath\[vendor-ID].csv. Where [vendor-ID].csv is the name of the file. When you update the InfoSet, you need to provide a vendor ID, for example, Vendor 1, so that the system updates the InfoSet from C:\MyPath\vendor1.csv.