Data list

​

Command properties

​

List → data list input

• CSV: Comma-separated values commonly used for tabular data.
• List: A simple list of values separated by delimiters such as commas or spaces.
• Selection: Input values selected from a web page by using a relative XPath.
• Excel: A Microsoft Excel spreadsheet.
• Parquet: A columnar file format optimized for large data sets.
• Date Range: A sequence of dates between specified From and To dates. For example, a range from January 1, 2019 through January 5, 2019 can produce 2019-01-01, 2019-01-02, 2019-01-03, 2019-01-04, and 2019-01-05 when the corresponding date format is selected.

• Manual: Lets you enter data manually. This source is available for CSV and List data types.
• Agent Parameter: Uses the value of a selected input parameter. This source is available for CSV and List data types.
• Shared Files: Uses files stored in a designated space. Shared files are available to users with access to that space and can be reused by multiple Agents in the same space, but they are not available from other spaces. To upload a shared file, open the New Agent menu and select New Shared File. In the Create Shared File window, drag and drop a file or click Upload File to select one from your device.
• Private Files: Uses files stored in the Agent’s Files section. These files are available only to that Agent.
• Script: Runs a script written in C#, Python, JavaScript, or regular-expression syntax to access or manipulate the input data.

​

C#

#r System.IO.dll

using System.IO;

public string GetData(RunContext context)
{
    var filename = context.GlobalData.GetString("TickerInputFile");
    var filepath = context.SharedFiles.GetFile(filename);
    var inputfile = File.ReadAllText(filepath);
    return inputfile;
}

​

Python

from se_scripting_utils import *

def get_data(context: RunContext):
    filename = "all_us_company_100.csv"
    filepath = context.shared_files.get_file(filename)
    file = open(filepath, "r")
    return file.read()

​

Regex

sequence 1 to 20 step 2

• Data includes headers: Specifies whether the input data has a header row. This option is checked by default for every data type.
  • Checked: Skips the first row because it is assumed to contain column headers. This is commonly used for CSV, Excel, and Parquet files.
  • Unchecked: Processes every row, including the first. Use this setting for data without headers or when the first row must be processed.

​

List → list settings

• The input data is processed entirely in one session.
• The Agent does not split the input data even when multiple sessions are specified.

• The Agent divides the input data into parts and processes each part in a separate session.
• Parallel sessions can improve performance for large data sets or complex operations.

• The command tracks how many times it is executed.
• The count can measure Agent progress and help determine extraction success criteria.

​

Export

​

Files → upload files

• Drag and Drop Files: Adds multiple files by dropping them into the area labeled Drag files here…. Uploaded files become accessible and visible in the interface.
• Upload File: Adds multiple files by using the file picker. Uploaded files become accessible and visible in the interface.
• Name: Opens a detailed view for the selected file that shows its File Size, Last Modified date, and editing options.
  • Back to Files: Returns to the Upload files view.
  • Edit: Lets you modify the uploaded file.
  • Save button: Saves changes made to the file.
  • Cancel: Discards changes and preserves the original file.
• File Size: Displays the size of the uploaded file.
• Added: Displays the date and time when the file was uploaded.
• Delete: Removes the uploaded file.
• Edit: Opens the detailed file view, which shows the File Size, Last Modified date, and an additional Edit option.
  • Back to Files: Returns to the Upload files view.
  • Edit: Lets you modify the uploaded file.
  • Save button: Saves changes made to the file.
  • Cancel: Discards changes and preserves the original file.
• Download: Downloads the uploaded file.