Skip to main content

Notifications

Topic Creation & Management
Unanswered

Looking to query service now from the bot

Posted on by

I am trying to query service now ticket statuses from the PVA. How can I do this? 

  • DiegoPeres Profile Picture
    DiegoPeres 327 on at
    Re: Looking to query service now from the bot

    Hello @treed779,

    First of all, you create a topic so that the user can inform the number he wishes to consult, in servicenow the demands, requests and incidents are in different tables so make it clear what type of consultation the user can perform.
    Then build a Power Automate to effectively perform the query.
    You can do the status query in servicenow in two ways, using the native ServiceNow connector, where first you have to list the records in the table, passing as parameter the record number, here follows an example with an incident: 

     

    DiegoPeres_4-1660587945154.png

     

    DiegoPeres_5-1660588074818.png

     

     

    After the query all information related to the number searched will be available.

     

    The second option, and the one I recommend, is via HTTP request, where you query your ServiceNow quickly and objectively.

    DiegoPeres_2-1660587211739.png

     

    DiegoPeres_1-1660587154517.png


    To query from other tables just change the table name, the parameters are the same.

     


    Did I answer your question?😉
    Please consider accepting it as the solution to help other members find you faster.


    Like my answer?


    Like it! 👍



    Thanks!
    Diego Peres,
    Connect with me: Linkedin

     

  • peterswimm Profile Picture
    peterswimm on at
    Re: Looking to query service now from the bot

    You can do this with a flow connector in PVA

    https://docs.microsoft.com/en-us/power-virtual-agents/advanced-flow-create

     

    and the ServiceNow Power Platform connector:

    https://docs.microsoft.com/en-us/connectors/service-now/#get-record

     

    I would recommend that you try using slot filling and a regex entity for your ServiceNow ticket id

    https://docs.microsoft.com/en-us/power-virtual-agents/advanced-entities-slot-filling

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

September 2024 Newsletter…

September 2024 Community Newsletter…

Community Update Sept 16…

Power Platform Community Update…

Tuesday Tip #2 Global Search…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 141,651

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,493

Leaderboard

Featured topics