Menu
PIX RPA
STUDIO
ROBOT
PIX Master
BASIC ACTIVITIES
COLLECTIONS
CAPTCHAS
CLIPBOARD
WINDOWS CREDENTIAL
WINDOWS
SAP
FILES
GOOGLE DRIVE
GOOGLE SHEETS
GOOGLE DOCS
HTTP
OFFICE
WINDOWS PROCESSES
MACHINE LEARNING
MESSENGERS.TELEGRAM
WEB
Robot examples
Меню
1C - EXECUTE 1C QUERY
Activity «Execute 1C query» can be found in section «1C».
Activity executes the query to the specified 1C database.
The query is done using OLE, this means the COM-objects should be registered in the system for correct performance.
The required 1C version should be launched for that using the Command Line and /RegServer attribute.
Query should be done in 1C query language.
Activity executes the query to the specified 1C database.
The query is done using OLE, this means the COM-objects should be registered in the system for correct performance.
The required 1C version should be launched for that using the Command Line and /RegServer attribute.
Query should be done in 1C query language.
Нажмите на изображение, чтобы увеличить его.
Property; Class; Type; Options; Description
Query; In; String; *; 1C database query text. Query should be done in 1C query language.
Query parameters; In; BR.Core. ExpressionArguments; *; Query parameters marked as '&' in query text
Result; Out; DataTable; *; Query result
Connection; In; String; New connection; Connection string to 1C base. Example: "Srvr='1capp-test-dl:1542':Ref='ZUP_Corp'"
Visibility; In; Boolean; New connection; Show 1C or hide programm
User; In; String; New connection; Username to be used for query execution. The user should have the necessary rights, otherwise the error (exception) will appear
Password; In; String; New connection; Password for the username to be used for query execution
Connection; In; Activities._1C.Connection1C; Existing; Active 1C connection
Option; Description
New connection; Create new 1C connection
Existing; With existing connection