Extract Raw Output from Datapoint into Custom HTTP Integration
Hello all,
I'm not sure if this is possible but I'm going to ask here as a last resort.
I simply want to extract the "output" of the "Raw Request/Response" section of a SP Datapoint to be able to post it as JSON (or raw text) into a Google Chat webhook I have configured. The alert works perfectly fine, as well does the custom HTTP integration for the webhook, but it can only post the ##VALUE## after the Complex Datapoint runs (post processing) which converts the number of records returned from the Database into a number that can be alerted upon with a threshold. It's essentially just the number of rows returned, which works for the alert portion. I just want the actual values extracted somehow and appended to the Chat message, so the team watching for these alerts can quickly identify the issue. We are manually copying and pasting this information from using Raw Data > Poll Now and adding it to the chat room after the alert triggers, and I want to automate away this portion.
After reviewing the tokens available for DataSource tokens, I don't think it's possible. Needless to say, I was wondering if anyone here had a "magic work-around" or knew a way to make this possible.
** And to clarify, this SP only ever returns a handful of results at a time, so maximum size of the payload would never be reached. It checks for a particular type of rare error we have.