/
SET

SET

Owned by Morten Lindequist Køhler
Feb 14, 2024
2 min read

Assigns a value to a Data Source and / or any number of values to parameters.

Command Properties

From

Value to assign

To

Name of the Output Data Source.

Script

Value to be assigned if From is empty. Can be used for very long values (e.g. texts, templates, html, Xml etc.)

Example 1:

Action Map - From

To

Command

 

 

SET

http://localhost:8040/Perfion/Report.ashx

$ReportAPI

 

Above example assigns a url to a Data Source named 'ReportAPI'.

Map

From

Value to assign
… or …
A lookup-reference to a value to be found somewhere else e.g.@RemoteConnectionName=My Con
This will get the value of the Connection-string with the name "My Con" stored in the Perfion Remote Connections table.

To

Name of the variable to assign the value to
… or …
Name of a system parameter (reserved names)

Script

Value to be assigned if From is empty. Can be used for very long values (e.g. texts, templates, html, Xml etc.).

Example 2:

Action Map - From

To

Command

Script

 

 

SET

 

The Value in From

$String

 

 

149.5

$Number

 

 

 

$LongText

 

This is a very long string of text on multiple lines  that exceeds 255 chars

@RemoteConnectionName=EmailSmtpServer

SMTP

 

 

Above example shows how a short string value "The Value in From" is assigned to a global variable that we have chosen to name $String. It also shows how to assign a number to a variable. Numbers are always represented with a '.' as decimal separator. If a value cannot be recognized as a number it will be treated as a string. Furthermore, the example shows how the Script-field can be used to assign a long text-value, and how values can be looked up, and assigned to either a variable or a system parameter such as e.g. SMTP.