User Tools

Site Tools


Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
en:process_steps:ws_import_sql [2022/03/09 11:09]
levi
— (current)
Line 1: Line 1:
-====== WSheet Import SQL ====== 
  
-This step allow us to get data with a SELECT query from an SQL server we already connected to through SQL Connection step. The data we get then can be placed into a target worksheet to editing and saving. The step has the following parameters: 
-  * **Connection Djeeni name: ** This name identifies the connection name we wish to use to get data from. 
-  * **SQL Query (SELECT): ** The SQL query we want to use to get data. The query must be a SELECT query. 
-  * **Target top left cell: ** This parameter is only usable for target worksheets. We should use a target worksheet Djeeni name and the target cell we wish to copy the data from the query. 
-  * **Options ** (Optional): No additional options available at the moment.