Hi all - I'm new to the Service Now platform so be gentle 🙂
I'm not a developer but dangerous enough to get around. I currently have an Alexa integration into my ServiceNow PDI that works well for a fun project and I'm looking to extend that but have tons of issues understanding how the survey tables and results of surveys all work together.
In short I am using pysnow to retrieve results from a custom table I've built. That works well. Now what I'd like to do is have the same python code summarize survey results. The survey is built and works. One survey question is to judge sentiment (positive/negative) and the other is a string field for additionally commentary. I'm looking to have my Alexa skill summarize feedback by querying for one positive piece of feedback and speaking the commentary then querying for one negative piece of feedback and speaking that associated commentary.
I've played around with the asmt_metric_result table but for the life of me I can't get my head around how to actually construct the query itself and how to related the results together.
Thanks in advance for any guidance or help here!
