This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
en:process_steps:ws_import_sql [2022/02/25 17:28] levi created |
— (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. | ||