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

Helpful resources

Quick Links

Welcome to the Power Platform…

We are thrilled to unveil the newly-launched Power Platform Communities!…

Getting Started…

Welcome to the Power Platform Community! We appreciate your visit…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 138,287

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,172

Leaderboard

Featured topics