MSTeams echo bot using PowerShell Azure Functions

Question

How should one parse the chat text received as JSON payload in the request body when using an outgoing webhook as an application in a Teams group to fetch the output of a PowerShell Azure function?

using namespace System.Net
param($Request, $TriggerMetadata) 

$text       =($Request.Body|ConvertFrom-Json).text #Parse request body to extract message text                     
   
$Response   = @{                                   #This simply echoes the received text
    type    = 'message'
    text    = "You said: $text"} | ConvertTo-Json

Push-OutputBinding -Name Response -Value ([HttpResponseContext]@{
  StatusCode= [HttpStatusCode]::OK
  Body      = $Response})

The code is working partially so that I can get the text output of the function ['You said'] as a response in Teams. However, it cannot parse the text passed while calling the function in Teams and echo it in the response.

Have you tried inspecting the raw JSON structure in $Request.Body? What message do you receive if you do text = "You said: '$($Request.Body)'"? — Mathias R. Jessen
– Mathias R. Jessen, Commented Mar 18, 2024 at 20:42
This sounds like a typical CHAT issue. Is the text being sent in one message or multiple messages? You can't parse a message if it is not complete. Often with chat applications it is using timers to send data so the receiver doesn't get the entire text until more than one response is read. You have to wait until the entire message is received before processing. Which means joining messages and waiting for a terminating character like a return before processing. — jdweng
– jdweng, Commented Mar 18, 2024 at 21:58
@MathiasR.Jessen, Yes, I get You said: 'System.Management.Automation.OrderedHashtable' — Ayan Mullick
– Ayan Mullick, Commented Mar 18, 2024 at 23:17
By the looks of things, $Request.Body (maybe) already contains the parsed json in a hashtable and $text = $Request.Body | ComvertFrom-Json is silently failing, leaving $text equal to $null and results in the output string You said: . Try $text = $Request.Body.text instead and see if that shows the text in the output message… — mclayton
– mclayton, Commented Mar 19, 2024 at 0:23
@mclayton, $text = $Request.Body.text results in a null output after You said: too. — Ayan Mullick
– Ayan Mullick, Commented Mar 19, 2024 at 0:56

Ayan Mullick · Accepted Answer · 2024-03-28 02:18:57Z

0

PFB how to parse the Teams message text from the JSON payload in the request body and the regex to remove the application name while echoing.

using namespace System.Net
param($Request, $TriggerMetadata)

$text        =  $Request.Body['text'] -replace '.*PSFuncEchoBot\s*'

Push-OutputBinding -Name Response -Value ([HttpResponseContext]@{
  StatusCode = [HttpStatusCode]::OK
  Body       = @{type = 'message'; text = "You said: $text"}    
})

PFB output screenshot

edited Mar 28, 2024 at 2:18

answered Mar 19, 2024 at 18:52

Ayan Mullick

1622 gold badges16 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MSTeams echo bot using PowerShell Azure Functions

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related