@Sanket1
Finally here is the solution to pass your input parameter as excel and output excel file also will be saved in your local path.
Flow screenshot:
Code:
@@copilotGeneratedAction: 'False'
Scripting.RunPowershellScript.RunPowershellScript Script: $'''# Web API endpoint URL
$apiUrl = \"https://localhost:44387/api/values/pivottable\"
# Input file path
$inputFilePath = \"C:\\Users\\deenu\\Downloads\\Excel A.xlsx\"
# Output file path to save Excel
$outputFilePath = \"C:\\Users\\deenu\\Downloads\\newoutputexcel.xlsx\"
try {
# Create a WebClient object
$webClient = New-Object System.Net.WebClient
# Create a new FormData instance
$formData = New-Object System.Collections.Specialized.NameValueCollection
$formData.Add(\"file\", $inputFilePath)
# Upload the file using multipart/form-data
$responseBytes = $webClient.UploadFile($apiUrl, \"POST\", $inputFilePath)
# Save the response content as byte array to output Excel file
[System.IO.File]::WriteAllBytes($outputFilePath, $responseBytes)
Write-Output \"Excel file saved successfully.\"
}
catch {
Write-Output \"An error occurred: $_\"
}
''' ScriptOutput=> PowershellOutput
Thanks,
Deenuji Loganathan 👩💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥
-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀. If you'd like to appreciate me, please write a LinkedIn recommendation 🙏
