How to - add Watchlist as an Incident comment

Question

Hello,

I'm trying insert а watchlist as a comment when an incident triggers. Unfortunately this fails. If i remove the step "add comment to incident" i successfully receive an email containing the watchlist in a HTML table. I supposed this might be an incorrect way of inserting the watchlist into the comment section of an Incident.

OUTPUT from where it fails:

{
"error": {
"code": 400,
"source": "logic-apis-westeurope.azure-apim.net",
"clientRequestId": "52f807cd-5a22-47ed-b36c-25eeb25e0b8a",
"message": "The response is not in a JSON format.",
"innerError": "Comment length should not exceed 30000 characters"
}
}

Answer 1

This error "The response is not in a JSON format." usually means that the prior activity was misconfigured or the expected input was not properly formatted. The query activity output may not be compatible with the comment action without modification.

Options:
-Change the query to output less data or change the output
-Parse the body (output) using a JSON parser activity
-Look for examples for how other playbooks reuse query output (maybe formatting as an HTML table for example).