Answered

ServiceNow get incidents from customer

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I created a Flow to get the Incidents from a customer. I use the ServiceNow connector from Flow. The connector is configured like this:

LIST RECORDS:

Record Type: Incident

Display System References: Yes

Exclude Reference Links: Yes

When I run this. it works. I get the infomrations in a json like I expect from all customers. When I add a query like this: company='COMAPANYA', I dont get anything back. Anyone an idea? I know this company exist and I see it in the first query...

Regards Daniel

Categories:

Using connectors

I have the same question (0)

All responses (4)

Answers (1)

Sutherland Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Daniel,

Could you share more details of your mentioned 'add a query like this: company='COMAPANYA''?

In usual, we could ust Filter array function to get your Jason filter like following snapshot.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Johnny

We have thousand of Incidents. So I would like to query already in the request to ServiceNow. This how it is configured:
I get no Incidents.

Was this reply helpful? Yes No
Verified answer

Sutherland Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Daniel,

Have you ever tried any other queries to check whether it works or not like following doc suggested? I would like want to narrow down the issue scope. Or you could check flow history input body to confirm whether the query expression is correct.
https://docs.microsoft.com/en-us/connectors/service-now/#list-records

Was this reply helpful? Yes No
DJ-1000 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Daniel,

An easy way to create queries is to first run the query in ServiceNow then right-mouse click and copy, then paste in Power Automate.

Was this reply helpful? Yes No