Online Documents
English
English
  • First Launch Experience
  • Activate Software License
  • How to Train EMILY?
  • Simple Web Automation
  • Web Automation Tools
  • Web Automation Processor
  • User Fill
  • Workspace Script
  • File Exporter
  • File Enumerator
  • EXCEL Processor
  • EXCEL Analyzer
  • EXCEL Writer
  • EXCEL Filler
  • CSV Creator
  • PowerShell
  • PDF Analyzer
  • Mail Sender
  • Mail Reader
  • Exchange Mail Sender
  • Exchange Mail Reader
  • HTTP Analyzer
  • Command Line
  • DOCX Templater
  • SQL Executor
  • Desktop Automation (DA)
  • SFTP
  • JSON API Server
  • Chart
  • DOCX2HTML
  • Manage Folder
  • Google Drive
  • Google Sheets
  • Google OCR
  • Google NLU
  • Azure Form Recognizer
  • Anti-Captcha
  • ChatGPT
  • Gemini
  • Schedule Trigger
  • Mail Trigger
  • File Trigger
  • API Trigger
  • Protect Text
  • Flexibility & Security
  • Announcements
    • Version Release
    • Third Party Notice
Powered by GitBook
On this page
  • TYPE
  • HOST
  • PORT
  • USER
  • PASSWORD
  • DATABASE
  • SQL STATEMENT
  • Input Object
  • Output Object

SQL Executor

Connect to the specified database to execute SQL instructions and analyze the results

PreviousDOCX TemplaterNextDesktop Automation (DA)

Last updated 1 year ago

TYPE

Choosing the database type. If oracle is selected, the Oracle SQL Developer client library is also required to be installed on your local machine: mysql, postgres, oracle, mssql

HOST

Database host, which can be an IP address or host domain name.

PORT

Database host port number.

USER

User account name for connecting to the database. Supports %FILENAME% variable.

PASSWORD

The password for the user account filled above. Supports %FILENAME% variable.

DATABASE

Database name. Supports %FILENAME% variable.

SQL STATEMENT

SQL commands executed on the specified database. %FILENAME% variables can be used within the commands: SELECT * from %price%

Input Object

In the input array, each element represents a record retrieved from an SQL query. The object contains keys representing the columns of the queried table and their corresponding values for that specific record.

Output Object

Each key added to the output object will be output as a .txt file in the workspace. The file name will be the key, and the text content will be the corresponding value.

// Write the result to the text file 'total.txt' in the workspace
let total = 0
input.forEach((row) => total = total + row.price)
output['total'] = total

--

We are dedicated to improving our content. Please let us know if you come across any errors, including spelling, grammar, or other mistakes, as your is valuable to us! 🤖️⚡️

feedback