IA-Connect Dynamic Code (Preview)

The path to the folder to be added to the list of folders for the IA-Connect Agent to scan when it tries to load an external reference.

Add the following expression here: workflow()

Add the following expression here: workflow()

If set to true, the JSON will be returned in a table / datatable format (i.e. in the format [{}]). If set to false, the JSON will be returned as a single entity (i.e. in the format {}). Which format to use depends on what you are doing with the JSON. Most IA-Connect actions expect datatable format.

The input table in JSON format.

The index of the column to start deleting at. Use 1 to delete the first column, N to delete the Nth column. If you wish to delete a column by name, leave this input blank and use the input 'Column name to delete' instead.

The optional name of the column to delete. If you wish to delete a column by index, leave this input blank and use the input 'Start column index' instead.

The number of columns to delete, starting at the specified index or name.

The index of the column to start deleting at. Use 1 to delete the first column, N to delete the Nth column. If you wish to delete a column by name, leave this input blank and use the input 'Column name to delete' instead.

The optional name of the column to delete. If you wish to delete a column by index, leave this input blank and use the input 'Start column index' instead.

The number of columns to delete, starting at the specified index or name.

The input array of strings.

The index of the item to start deleting at. Use 1 to delete the first item, N to delete the Nth item.

The number of items to delete.

The input table in JSON format.

The index of the row to start deleting at. Use 1 to delete the first row, N to delete the Nth row.

The number of rows to delete.

The index of the row to start deleting at. Use 1 to delete the first row, N to delete the Nth row.

The number of rows to delete.

The input table in JSON format.

The filter in .NET DataView rowfilter syntax. For example: [Name] like '*Element'.

An optional column name to sort by, after applying the filter. If you wish to sort by multiple columns then list the columns comma separated.

Set to true to sort in an ascending order. Set to false to sort in a descending order.

An optional second column name to sort by (after sorting by the first column).

Set to true to sort the second column name in an ascending order. Set to false to sort in a descending order.

An optional third column name to sort by (after sorting by the first and second columns).

Set to true to sort the third column name in an ascending order. Set to false to sort in a descending order.

The input array of strings.

The name to use for the table column holding the array during the filter operation. This name can then be used as the column name in the .NET DataView rowfilter syntax. For example MyColumn which can then be referred to as [MyColumn].

The filter in .NET DataView rowfilter syntax. For example: [Name] like '*Element'.

The filter in .NET DataView rowfilter syntax. For example: [Name] like '*Element'.

An optional column name to sort by, after applying the filter. If you wish to sort by multiple columns then list the columns comma separated.

Set to true to sort in an ascending order. Set to false to sort in a descending order.

An optional second column name to sort by (after sorting by the first column).

Set to true to sort the second column name in an ascending order. Set to false to sort in a descending order.

An optional third column name to sort by (after sorting by the first and second columns).

Set to true to sort the third column name in an ascending order. Set to false to sort in a descending order.

Add the following expression here: workflow()

The input array of strings.

The name to use for the table column.

Set to true to ignore (drop) empty items in the array. Set to false to include all items.

The name of the computer to check the PowerShell version. If left blank, the computer where the IA-Connect Agent is running will be used.

The authentication mechanism to be used if connecting to a remote computer or running the script as an alternative user. Supported values are 'Basic', 'Credssp', 'Default', 'Digest', 'Kerberos' and 'Negotiate'.

The number of connections to attempt if connecting to a remote computer.

Add the following expression here: workflow()

The input text to match against the regular expression.

The regular expression to match the input text against.

A string array containing the names of the regular expression groups to retrieve. If a blank array is provided, all groups are retrieved. For example: If a regular expression contains (?(Yes|No)) and you specify that the 'NeedsUpdating' group should be retrieved, then the matched value of that named group will be returned.

The index of the match result to retrieve, starting at 1. If you want to match the first result (the default behaviour), enter 1. For example: If an input string is expected to match the regular expression in 5 places and you are interested in the 4th match, enter 4.

Set to true (the default) for a case-sensitive match (e.g. A is not a) or set to false for a case-insensitive match (e.g. A and a are treated as identical).

The maximum number of seconds the regular expression can be processed before timing-out. This stops infinite loops caused by certain regular expressions.

The input text to match against the regular expression.

The regular expression to match the input text against.

The index of the match result to retrieve, starting at 1. If you want to match the first result (the default behaviour), enter 1. For example: If an input string is expected to match the regular expression in 5 places and you are interested in the 4th match, enter 4.

Set to true (the default) for a case-sensitive match (e.g. A is not a) or set to false for a case-insensitive match (e.g. A and a are treated as identical).

The maximum number of seconds the regular expression can be processed before timing-out. This stops infinite loops caused by certain regular expressions.

The input text to match against the regular expression.

The regular expression to match the input text against.

The maximum amount of regular expression matches to perform. For an unlimited number of matches (i.e. keep matching until there are no more matches) enter no value or a value of 0 (the default). This input is designed to avoid infinite regular expression loops by putting a limit on the number of matches.

Set to true (the default) for a case-sensitive match (e.g. A is not a) or set to false for a case-insensitive match (e.g. A and a are treated as identical).

Set to true (the default) if each individual output array element should be trimmed.

Set to true if empty output array elements should be removed from the output array (i.e. you don't want empty results).

The maximum number of seconds the regular expression can be processed before timing-out. This stops infinite loops caused by certain regular expressions.

The input table in JSON format.

The index of the column to return as an array. Use 1 for the first column, N for the Nth column. If you wish to retrieve a column by name, leave this input blank and use the input 'Column name' instead.

The optional name of the column to return as an array. If you wish to retrieve a column by index, leave this input blank and use the input 'Column index' instead.

The index of the column to return as an array. Use 1 for the first column, N for the Nth column. If you wish to retrieve a column by name, leave this input blank and use the input 'Column name' instead.

The optional name of the column to return as an array. If you wish to retrieve a column by index, leave this input blank and use the input 'Column index' instead.

The input string upon which the search is performed.

The start search string.

The end search string or leave blank if searching to the end of the line.

Set to true if you want to search the input string line by line and for the result to only contain the matching string in the current line. Set to false to treat the input string as a single item.

Set to true if you want an exception raised if the search string was not found, or set to false if the action should return 'String between found'=false when the search string was not found.

Set to true if you want spaces or tabs before or after the result to be trimmed.

Set to true if the search strings are regular expressions. Set to false if the search strings are normal text.

Set to true if the search should be case sensitive. Set to false for case insensitive searches.

The input table in JSON format.

The index of the row containing the cell to retrieve. Use 1 for the first row, N for the Nth row.

The index of the column containing the cell to retrieve. Use 1 for the first column, N for the Nth column. If you wish to retrieve a column by name, leave this input blank and use the input 'Column name' instead.

The optional name of the column containing the cell to retrieve. If you wish to retrieve a column by index, leave this input blank and use the input 'Column index' instead.

The input table in JSON format.

The index of the first row to retrieve. Use 1 to start at the first row, N to start at the Nth row.

The number of rows to retrieve. Use 0 (or leave blank) to retrieve all rows.

The index of the first column to retrieve. Use 1 to start at the first column, N to start at the Nth column. If you wish to specify the first column to retrieve by name, leave this input blank and use the input 'Start column name' instead.

The optional name of the first column to retrieve. If you wish to retrieve columns by index, leave this input blank and use the input 'Start column index' instead.

The number of columns to retrieve. Use 0 (or leave blank) to retrieve all columns.

The input array of strings.

The name to use for the table column.

Set to true to ignore (drop) empty items in the array. Set to false to include all items.

The file path to the local assembly file in the local session (where the IA-Connect Director is running).

The name of the assembly to be imported.

Should the assembly be compressed before uploading?

Add the following expression here: workflow()

The input table in JSON format.

The index of the row to insert at. Use 0 to insert at the start of the table, 1 to insert after row 1, N to insert after row N. -1 or any number equal to or higher than the number of items in the table to insert at the end of the table (useful if you don't know how long the table is).

The contents of the row to insert in JSON format. Leave blank if you want to insert an empty row. For example: To insert 'Simon' into the column 'Name' use {"Name":"Simon"} and to additionally insert 'England' into the column 'Country' use {"Name":"Simon","Country":"England"}.

The input array of strings.

The index of the row to insert at. Use 0 to insert at the start of the array, 1 to insert after row 1, N to insert after row N. -1 or any number equal to or higher than the number of items in the array to insert at the end of the array (useful if you don't know how long the array is).

The string value to insert in the new row. Leave blank if you want to insert an empty row.

The index of the row to insert at. Use 0 to insert at the start of the table, 1 to insert after row 1, N to insert after row N. -1 or any number equal to or higher than the number of items in the table to insert at the end of the table (useful if you don't know how long the table is).

The contents of the row to insert in JSON format. Leave blank if you want to insert an empty row. For example: To insert 'Simon' into the column 'Name' use {"Name":"Simon"} and to additionally insert 'England' into the column 'Country' use {"Name":"Simon","Country":"England"}.

The input table in JSON format.

The index of the row to insert at. Use 0 to insert at the start of the table, 1 to insert after row 1, N to insert after row N. -1 or any number equal to or higher than the number of items in the table to insert at the end of the table (useful if you don't know how long the table is).

Add the following expression here: workflow()

The name of the PowerShell module to search for.

Add the following expression here: workflow()

The full path to the lookup table. This must be accessible from the session where the IA-Connect Agent is running. If a folder is specified then all files beneath that folder are processed.

If set to true and any IA-Connect lookup table fails to load (for example if there is a problem in the table) then an exception will be raised. This is the default because if any table fails to load, this will usually result in an exception later in the process. If set to false then problem lookup tables will be ignored and only usable lookup tables will be loade3d.

Add the following expression here: workflow()

The name of the lookup table loaded into the IA-Connect Agent.

Input data to use for the lookup, in JSON format.

The name of one or more columns in the lookup table which hold the values to return in the output table.

Set to true (the default) to raise an exception if the lookup matches no data. Set to false to return a blank string if the lookup matches no data.

Set to true if you want to include blank cells in the return table. Set to false (the default) to only include cells with values.

The format to use when returning the results.

Add the following expression here: workflow()

The name of the lookup table loaded into the IA-Connect Agent.

Input data to use for the lookup, in JSON format.

The column in the lookup table which holds the return value to read.

If set to 1 (the default), the value from the first result column matching the requested name will be returned. Set to a higher value (N) to return the Nth matching column.

Set to true (the default) to raise an exception if the lookup matches no data. Set to false to return a blank string if the lookup matches no data.

Add the following expression here: workflow()

Add the following expression here: workflow()

The input string upon which the character removal is performed.

A string containing all of the characters you wish to remove from the inputs. For example: !@&?^*.

If set to true, IA-Connect will attempt to remove all diacritics from the input string, replacing characters with a diacritic with the same character minus the diacritic. For example: replacing 'acute accented a' with 'a'. In scenarios where there is no direct mapping to a simple character, the character is removed. For example: The German sharp S is removed.

If set to true, IA-Connect will remove all non-alphanumeric characters from the input string.

If set to true, IA-Connect will remove all numeric characters from the input string.

If set to true, IA-Connect will remove all lowercase alphabetical characters from the input string.

If set to true, IA-Connect will remove all uppercase alphabetical characters from the input string.

The name of the lookup table loaded into the IA-Connect Agent.

Add the following expression here: workflow()

The input table in JSON format.

The name of the column to rename.

The new name for the column.

The name of the column to rename.

The new name for the column.

The contents of the PowerShell script to execute. IA-Connect will execute this script as-is by passing directly to the PowerShell automation engine. No PowerShell script is actually created on-disk.

The name of the computer to run the PowerShell script on. If left blank, the script will be run on the computer where the IA-Connect Agent is running.

If no data is returned by the PowerShell command, does this suggest an error?

Should properties which have complex types (as opposed to a simple type such as System.String or System.Boolean or System.Date) be returned?

Should Boolean properties be returned as a Booleans? If false, these are returned as strings.

Should Numeric properties be returned as a Numerics? If false, these are returned as strings.

Should Date properties be returned as a Dates? If false, these are returned as strings.

Some properties (in the PowerShell return results) are collections of values (e.g. an array or table) and by default are not returned in the IA-Connect PowerShell response. This option allows you to specify which properties IA-Connect should attempt to return as a collection and can be entered in JSON or CSV format. For example: To return the EmailAddresses and MemberOf array properties, enter [{"PropertyName": "EmailAddresses"}, {"PropertyName": "MemberOf"}] (JSON format) or EmailAddresses,MemberOf (CSV format).

The authentication mechanism to be used if connecting to a remote computer or running the script as an alternative user. Supported values are 'Basic', 'Credssp', 'Default', 'Digest', 'Kerberos' and 'Negotiate'.

The number of connections to attempt if connecting to a remote computer.

The username to be used if running the script as an alternative user.

The password to be used if running the script as an alternative user.

If set to false (the default), the IA-Connect Agent will run the PowerShell script immediately and return the results to the Director when the script completes. If running a long or complex PowerShell script, this action may time out. If set to true, the IA-Connect Agent will run the PowerShell script as an Agent thread and the IA-Connect Director (or Orchestrator, PowerShell module, Blue Prism) can monitor the status of this Agent thread, waiting for it to complete. This allows long or complex PowerShell scripts to run without timeouts. IA-Connect Agents 9.3 and earlier cannot run PowerShell scripts as an Agent thread.

If you previously ran a PowerShell script as an Agent thread and set 'Seconds to wait for thread' to 0, provide the Agent thread Id to retrieve the results. This Agent thread Id will have been provided by the earlier call to this action. Set to 0 (the default) if you are simply running a PowerShell script (and hence not retrieving the results of a previous PowerShell script run as an Agent thread).

If 'Run script as thread' is set to true, how many seconds to wait for the Agent thread to complete. If the Agent thread running the PowerShell script hasn't completed in this time, an exception will be raised. Set to 0 to bypass the wait: The Agent will continue to run the PowerShell script, but also be available for the next action. You can then retrieve the script results at a later time by using the action 'Wait for Agent thread to complete successfully' to wait for the Agent thread to complete and then re-run this 'Run PowerShell script' action with the input 'Retrieve output data for thread Id' set to the Agent thread Id.

Set to true if the script contains an IA-Connect stored password identifier, in the format {IAConnectPassword:StoredPasswordIdentifier} or an IA-Connect Orchestrator generic credential, in the format {OrchestratorCredential:FriendlyName}. The { } phrase will be replaced by the specified password, escaped and placed in single quotes (unless it is already in quotes in the script).

Set to true to log any PowerShell verbose output into the IA-Connect logs. This could be useful for debugging.

Set to true to return any secure string properties in the PowerShell script output. Set to false (the default) to not return any properties that are held as a secure string. Only set to true if you know what you are doing, since this could result in passwords being transmitted (if there are passwords in the PowerShell script output).

Add the following expression here: workflow()

The input table in JSON format.

The column name to sort by.

Set to true to sort in an ascending order. Set to false to sort in a descending order.

An optional second column name to sort by (after sorting by the first column).

Set to true to sort the second column name in an ascending order. Set to false to sort in a descending order.

An optional third column name to sort by (after sorting by the first and second columns).

Set to true to sort the third column name in an ascending order. Set to false to sort in a descending order.

The input array of strings.

Set to true to sort in an ascending order. Set to false to sort in a descending order.

Set to true for a case sensitive sort (i.e. upper and lower case sorted separately). Set to false for a case insensitive sort.

The column name to sort by. If you wish to sort by multiple columns then list the columns comma separated.

Set to true to sort in an ascending order. Set to false to sort in a descending order.

An optional second column name to sort by (after sorting by the first column).

Set to true to sort the second column name in an ascending order. Set to false to sort in a descending order.

An optional third column name to sort by (after sorting by the first and second columns).

Set to true to sort the third column name in an ascending order. Set to false to sort in a descending order.

The input text to split against the regular expression.

The regular expression to split the input text against.

Set to true (the default) for a case-sensitive split (e.g. A is not a) or set to false for a case-insensitive split (e.g. A and a are treated as identical).

Set to true (the default) if each individual output array element should be trimmed.

Set to true if empty output array elements should be removed from the output array (i.e. you don't want empty results).

The maximum number of seconds the regular expression can be processed before timing-out. This stops infinite loops caused by certain regular expressions.