For the complete documentation index, see llms.txt. This page is also available as Markdown.

Sourced Values List

Below is the full list of Sourced Values:

Source
Value Identifier

ActionField

Get/Set value using an ActionField defined in Actions.

AIQueryResult

The result of an AI query.

ApiKey

Unique id used to authenticate and authorize a user or application when accessing an API. Treated like a password.

Argument

Get/Set value using an argument passed to the project. Use button to select or define arguments.

Boolean

Get/Set a boolean value — True or False.

CalendarYear

Get/Set value as calendar year — Current, Previous, Next, or a specific year (e.g. 2024).

Concatenation

Get/Set value by concatenating multiple values including text, Data Fields, etc.

ConditionResult

Get/Set result of executing a Condition.

ConnectionString

Get/Set value by configuring a connection string.

DataFieldValue

Get/Set value of a column in the current record of a Source or Target activity in the project.

DataRecordJson

Get/Set value of a current record of a Source or Target activity in JSON format.

DataSourceEntityKeyValue

Get the new key value in cache using the DataSource and Entity of the source.

Date

Get/Set value using a Date. Use editor button to enter a Date, select Date function, add TimeSpan, etc.

DateTime

Get/Set value using a DateTime. Use button to enter a DateTime, select DateTime function, add TimeSpan, etc.

Decimal

Get/Set value using a Decimal value.

Double

Get/Set a value using a Double value.

Entity

Get/Set value using the name of the primary entity of a Source or Target activity.

EnvironmentSettingField

Get/Set value from a pre-defined environment setting field. Use editor button to select or define Environment Setting Fields.

EnvironmentVariable

Get/Set an environment variable.

Enum

Get/Set value of an Enum.

Expression

Get/Set value using the result of executing a JavaScript expression. Use editor button to enter Expression.

FieldCount

Get/Set value using the number of fields/columns in a Source or Target.

FieldMap

Get/Set the value or transformed value in use for the field map, retrieved from DataFieldValue, SourceDataFieldValue, etc.

FileContents

Get/Set value using the entire contents of a text file. Use button to enter or select the file name.

FilePath

Get/Set value as a file path in the file system.

FiscalYear

Get/Set value as Fiscal Year — Current, Previous, Next, or a specific year (e.g. 2024).

FolderPath

Get/Set value using a folder path.

Function

Get/Set value using the result of executing a function in an assembly.

Guid

Get/Set value from a GUID. Enter the GUID or select "New Guid".

Html

Get/Set value using HTML (optionally including merged fields).

Int16

Get/Set value as Int16 integer data type.

Int32

Get/Set value as Int32 integer data type.

Int64

Get/Set value as Int64 integer data type.

Integer

Get/Set value as Int32 integer data type.

ListValue

Get/Set value using a list value.

None

Select None if no value is to be returned.

Numeric

Get/Set a numeric value.

Password

Get/Set value using a password.

PicklistEntry

Get/Set value using a picklist entry.

PicklistEntryDescription

Get/Set value using a picklist description.

PrimaryKeyValue

Get/Set value using the value of the primary key field of a data record.

ProjectName

Get/Set value using the name of a project in the current project database.

RecordCount

Get/Set value using the number of records in a Source.

RecordsJson

Get/Set value of records from a Source activity in JSON format.

RetrievedId

Get value of a retrieved id when a target activity is set to bulk load records.

Script

Get/Set value using the result of executing a Script (JavaScript function).

Single

Get/Set value as Single data type.

SourceDataFieldValue

Gets a data field value in the current Source.

SourceOrTargetActivityName

Get/Set value using the name of a Source or Target activity.

SourcePickListLookup

Get/Set result of looking up a picklist value for replication.

SQL

Get/Set value as SQL Statement.

String

Get/Set value as String data type.

System

Get/Set value using a System value (LastError, LastRunDateTime, etc.).

TargetDataFieldValue

Gets a data field value in the currently active Target.

TimeSpan

Get/Set value as TimeSpan.

Url

Get/Set value using a URL.

User

Get/Set a User record value (UserID, UserName, etc.).

Variable

Get/Set value using a pre-defined workflow variable. Use button to select or define Variables.

Workflow

Get/Set value using a Workflow value (LastError, LastRunDateTime, etc.).

WorkflowActivityName

Get/Set value using the name of an activity in the project.

WorkflowActivityResultValue

Get/Set value using the result of activity execution.

WorkflowDataManagerFieldName

Get/Set value using the name of a field used in a Source or Target activity.

WorkflowDataSourceListEntry

Get/Set a data source list entry.

XML

Get/Set value using an XML string.

Last updated