Functions.Templates/Templates/MySqlInputBinding-PowerShell/run.ps1

<#
Sample MySql Input Binding

These tasks should be completed prior to running:
    1. Update "commandText" in function.json - this should be the query to execute to retrieve the values being returned
    2. Add an app setting named "MySqlConnectionString" containing the connection string to use for the MySql connection
@param Request The HttpRequest that triggered this function
@param items The array of objects returned by the MySql input binding
#>
using namespace System.Net

# Trigger and input binding data are passed in via the param block.
param($Request, $items)

# Write to the Azure Functions log stream.
Write-Host "PowerShell function with MySql Input Binding processed a request."

# Assign the value to return as the HTTP response. 
# The -Name value matches the name property in the function.json for the binding
Push-OutputBinding -Name Response -Value ([HttpResponseContext]@{
    StatusCode = [System.Net.HttpStatusCode]::OK
    Body = $items
})