Forum Discussion

jkrolczyk's avatar
jkrolczyk
New Contributor
20 days ago

How to run a powershell script from TestComplete with parameters ?

Maybe I am missing this in the documentation? Running PowerShell Scripts From TestComplete | TestComplete Documentation If possible, I was trying to find the syntax to go by for passing in single o...
Desktop Testing
  • jkrolczy's avatar
    jkrolczy
    20 days ago

     

    function Test()
    {  
      // Create a WshShell object
      var WshShell = new ActiveXObject("WScript.Shell");  
      
      // Path to your PowerShell script
      var scriptPath = "C:\\qTestReport\MyScript.ps1";  

      // Parameters to pass to the script
      var param1 = "Bob";
      var param2 = "12";

      // Construct the command line string
      var command = "powershell -File \"" + scriptPath + "\" " + param1 + " " + param2;
      
      Log.Message(command);

      // Execute the PowerShell script with parameters
      WshShell.Run(command, 0, true); 
    }

     

    MyScript.ps1

    param 
    (
        [string]$Name,
        [int]$Age
    )

    $jsonBody = "C:\qTestReport\ESP\qTestResults\finalBody.txt"

    Write-Output "Hello, $Name! You are $Age years old."

    $Name | Out-File -FilePath $jsonBody
    Add-Content -Path $jsonBody $Age


    But file is not getting generated with passed in values


rraghvani's avatar
rraghvani
Champion Level 3

Providing your command is correct, it will work. You can check your string is correctly formed, if you were to output the command to the log,

Log.Message(command)
jkrolczy's avatar
jkrolczy
Regular Contributor
20 days ago

 

function Test()
{  
  // Create a WshShell object
  var WshShell = new ActiveXObject("WScript.Shell");  
  
  // Path to your PowerShell script
  var scriptPath = "C:\\qTestReport\MyScript.ps1";  

  // Parameters to pass to the script
  var param1 = "Bob";
  var param2 = "12";

  // Construct the command line string
  var command = "powershell -File \"" + scriptPath + "\" " + param1 + " " + param2;
  
  Log.Message(command);

  // Execute the PowerShell script with parameters
  WshShell.Run(command, 0, true); 
}

 

MyScript.ps1

param 
(
    [string]$Name,
    [int]$Age
)

$jsonBody = "C:\qTestReport\ESP\qTestResults\finalBody.txt"

Write-Output "Hello, $Name! You are $Age years old."

$Name | Out-File -FilePath $jsonBody
Add-Content -Path $jsonBody $Age


But file is not getting generated with passed in values


  • jkrolczy's avatar
    jkrolczy
    Regular Contributor
    20 days ago

    I got it now !!!

    Path was incorrect:
    powershell -File "C:\qTestReportMyScript.ps1" Bob 12

    Corrected - added another '\'
    var scriptPath = "C:\\qTestReport\\MyScript.ps1"; 

    powershell -File "C:\qTestReport\MyScript.ps1" Bob 12

    Parameters passed in and written into a file to verify