Differences

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

--- transformations:powershell [2018/01/11 20:52] – dmitry
+++ transformations:powershell [2021/07/03 22:18] – craigt
@@ Line 1: / Line 1: @@
-===== PowerShell =====
+{{ transformations:PowerShellAction.png}}
+====== POWERSHELL ======
+Category: Workflow / External\\
-Category: Workflow / External.
+\\
+=====Description=====
+This action allows executing PowerShell commands and scripts from within EasyMorph. PowerShell 3.0 or above is required.
-This transformation allows executing PowerShell commands and scripts right in EasyMorph. It requires PowerShell 3.0 or above installed.
+\\
+=====Use cases=====
+PowerShell is a very versatile scripting language supported by the vast ecosystem of the .NET framework. Having EasyMorph integrated with Powershell opens access to a large number of PowerShell cmdlets which help automate various tasks (e.g. advanced file operations, sending emails, computer management, and administration).
+EasyMorph actions can effectively be inserted into PowerShell command pipelines (e.g. generate a list of files in EasyMorph, filter it using EasyMorph expressions, and then send the resulting list into PowerShell).
+Finally, it becomes possible to write custom cmdlets (e.g. in C#) and run them from EasyMorph using EasyMorph parameters or column data.
+\\
+=====Action settings=====
+^ Setting  ^ Description  ^
+|Input pipeline\\ (accessible via $input)|Select the input pipeline, if any.  Options:  //None//, //Column//, or //Table//.|
+|Commands<sup>*</sup>|Enter one more PowerShell commands.|
+|Output and errors|Select whether output and errors will be captured by EasyMorph.  Options:  //Do not capture output. Fail on errors.//\\ or //Capture output and error collections.//|
+<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\
+\\
+=====Remarks=====
 It is possible to send values of column to the executed PowerShell commands through the built-in **$input** variable in PowerShell, for instance:
-   $input | Sort-Object
+  $input | Sort-Object
 Note that **$input** is an enumerator for the sequence, not the sequence itself.
-It is also possible to insert EasyMorph parameters right into the script text, as well as capture the output sequence from the PowerShell script back to EasyMorph.
+\\
+It is possible to insert EasyMorph parameters right into the script text. Just insert parameter names in curly braces. For instance:
-**See also**
+  Copy-Item "{Source file}" c:\test
-  * Blog: [[http://blog.easymorph.com/2017/12/running-powershell-commands-in-easymorph.html|Running PowerShell commands in EasyMorph]]
+\\
+It is also possible to capture the output sequence from the PowerShell script back to EasyMorph. Note that the output sequence should be explicitly converted in the PowerShell script into a sequence of basic types such as //string//, //integer//, //float//, //DateTime// or //bool//. Formatted output of the standard PowerShell console is not captured.
+\\
+=====See also=====
   * [[transformations:runprogram|Action: Run program]]
-  * [[https://docs.microsoft.com/en-us/powershell/scripting/setup/installing-windows-powershell|Installing Windows PowerShell]]
+  * Blog: [[http://blog.easymorph.com/2017/12/running-powershell-commands-in-easymorph.html|Running PowerShell commands in EasyMorph]]
+  * Microsoft documentation: [[https://docs.microsoft.com/en-us/powershell/scripting/install/installing-powershell-core-on-windows?view=powershell-7.1|Installing Windows PowerShell]]