Sourced Values List
Below is the full list of Sourced Values:
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