topic Re: Available operator values for Alerts API Filter? in Prisma Cloud Discussions

Available operator values for Alerts API Filter?

gerald.f.kelly — Thu, 26 Sep 2024 22:00:25 GMT

I'd like to submit an Alerts API request as documented here
https://pan.dev/prisma-cloud/api/cspm/submit-an-alert-csv-download-job/
but I'd like to filter it by just certain cloud.accountId values.
The filters documentation at https://pan.dev/prisma-cloud/api/cspm/get-alert-filter-and-options/ list the fields available to filter on but there is no list of supported operators other that "=" and there doesn't seem to be any general API documentation of supported operators either.
I've tried "operator": "IN" and "operator": "in" and "operator": "contains" followed by "value": "('accountA', accountB', 'account')" to no avail.
Is this possible or is "=" the only operator supported in Alerts Filters?

Re: Available operator values for Alerts API Filter?

ACurran2 — Fri, 27 Sep 2024 15:53:00 GMT

Hello,

The documentation does state that '=' is a valid operator to use. We would have to look into whether or not alternative operators would work with the API call used to Submit Alert CSV Generation Job. Can you please try passing the following in the body of your request? Please insert valid account ids and other aspects of the body as needed.

{

"filters": [

{

"name": "cloud.accountId",

"operator": "=",

"value": "123"

{

"name": "cloud.accountId",

"operator": "=",

"value": "1234"

{

"name": "cloud.accountId",

"operator": "=",

"value": "12345"

}

Please confirm if this works for you.

Re: Available operator values for Alerts API Filter?

gerald.f.kelly — Mon, 30 Sep 2024 17:32:59 GMT

Thanks so much for the help! It's ugly, as I have a large number of cloud.accountIds I need to filter on, but it works!