filename

This can either be a relative path to a file on the server, or an HTTP URL.
When the file is on the server, the file should be placed in the Development data or Server data tab, and the Table scope of the table must be set accordingly.
When you use an HTTP URL, you can specify the user and pass parameters for authentication.

ext

By default the filename extension is used to determine the file type, but this can be overridden.

user

The username for the remote file when using an HTTP URL.

pass

The password for the remote file when using an HTTP URL.

sheet

The sheet or named range to import. For sheet names a '$' character should be appended at the end.
If not specified the first sheet is loaded.

firstcolumn

The first column to start from. The default setting is {autodetect}.

firstrow

The first row to start from. The default setting is {autodetect}.

'driver={mvfile}; filename=Data/Dataset.xlsx;'

the first sheet of an Excel file

'driver={mvfile}; filename=Data/Dataset.xlsx; sheet=MySheet$;'

the sheet named 'MySheet'

hasheader

Whether the first row of the file is a header row. The default setting is {true}.

delim

The delimiting character. The default setting is {tab}. For some special characters, for example semicolon, the ASCII value should be used.

quote

The character used to quote values. The default setting is {autodetect}.

escape

The character used to escape characters. The default setting is {none}, which only interprets two quote characters as one.

encoding

The encoding used in the file, e.g., UTF8, or LATIN1. The default setting is {UTF8}.

'driver={mvfile}; filename=Textfile.txt; delim=,; quote=";'

with comma (,) separators and " quotes

'driver={mvfile}; filename=Textfile.txt; delim=|; quote=";'

with pipe (|) separators and " quotes

'driver={mvfile}; filename=Textfile.txt; delim=9; quote=';'

with tab separators and ' quotes

'driver={mvfile}; filename=Textfile.txt; delim=59; quote=none;'

with semicolon separators and no quotes

'driver={mvfile}; filename=Textfile.txt; delim=,; quote="; escape=\;'

with comma (,) separators, " quotes and \ escape characters

'driver={mvfile}; filename=http://www.example.com/files/example.txt;'

from a web server

'driver={mvfile}; filename=http://www.example.com/files/example.txt; User=Jane; mv-credential-Pass=example_com_credentials'

from a web server with basic access authentication

driver

The ODBC driver to use for this connection. Not needed when using the 'dsn' parameter.

dsn

The ODBC DSN to use for this connection. Not needed when using the 'driver' parameter.

user

Username to be used to connect to the external datasource.

pass

Password to be used to connect to the external datasource.

other

Any other parameters are passed as specified to the ODBC driver.

'Driver={SQL Server Native Client 11.0};Server=SERVERNAME;Database=MyDatabase;'

to a SQL Server database

'Driver={Oracle in OraClient12Home1};Dbq=MyTSN;'

to an Oracle database

'DSN=MyDSN; User=MyUser; Pass=MyPass;'

using a configured DSN with a username and password

scriptText

The text of the script.

Mandatory
Note: only if scriptFile is not used.

scriptFile

Filename from which to load the script. This can be a relative path to a file on the server.

When the file is on the server, the file should be placed in the Development data or Server data tab, and the Table scope of the table must be set accordingly.

Mandatory
Note: only if scriptText is not used.

inputData

A semicolon separated text with column headers that contains the input for the script.

Note: The csvtable function can be used to generate data in the correct format.

Mandatory

scriptType

The name of the handle to use as specified in the GenericScriptHandlers setting in the Server Settings.

Note: If scriptFile is specified, this will be automatically detected based on the file extension.

Optonal

args

Customize the arguments to pass to the script.
This should be a JSON encoded list.

There are two special arguments; '<SCRIPT>', and '<INPUT>'. Occurrences of '<SCRIPT>' are replaced with the path to a script file, and occurrences of '<INPUT>' are replaced with the path to the input file. This enables you to customize the call to the script handler with additional arguments. The default is ["<SCRIPT>", "<INPUT>"].

Optional

debugPath

An absolute path to a folder.

If this parameter is specified, UiPath Process Mining will output the input file (as given to the external process), and the external process's output (as read from the external process standard output) in this folder for debugging purposes.

Optional

Host

The hostname or IP address of the SAP application server.

Mandatory

SystemNumber

The two-digit number between 00 and 99 that identifies the designated instance.

Mandatory

FunctionModule

When setting up a native SAP extraction the SAP Z_XTRACT_IS_TABLE Function Module is required. If, for example, the Function Module is renamed in your SAP system, you can specify the correct name in the FunctionModule parameter in the SAP connection string.FunctionModule parameter.

Overrides the default Z_XTRACT_IS_TABLE function module that is used when querying this table.

Optional

Username

The username of the account that is being used to log in to the SAP instance.

Mandatory

pass

The password of the user above. Can be used in combination with the credential store, use mv-credential-pass in this case.

Mandatory

client

The client that is being used.

Mandatory

Language

The language that is used when logging in.

Mandatory

table

The SAP tablename from which the data must be loaded. For example EKPO.

Mandatory

fields

An array of fields that will be retrieved from the SAP table specified in the table property.

Note: If the fields property is empty, all fields will be retrieved.

Mandatory

where

A where clause to retrieve a subset of a table.

Optional

limit

An integer number that specifies a fixed number of records to be retrieved from the table.
Note: if limit is set to '0', there will be no limit.

Optional

'table=' + urlencode("EKPO")

all fields of all records of table EKPO.

'table=' + urlencode("EKPO") + '&fields=' + urlencode(listtojson(["MANDT", "EBELN"]))

the MANDT and EBELN field for all records of the EKPO table.

'table=' + urlencode("EKPO") + '&where=' + urlencode("EBELN = 4500000001")

all fields from EKPO table where EBELN is equal to 4500000001.