topic Re: Rest api filtering in Splunk SOAR

Rest api filtering

meshorer — Wed, 29 May 2024 08:25:21 GMT

Hello,

is there a way to use a rest api and search for containers that contain the word computer or the word process in the container name? I only manage to filter for “contains” or the filter “in”, , but i failed to use both.

Re: Rest api filtering

phanTom — Wed, 29 May 2024 08:40:52 GMT

@meshorer

The IN operator will only look for the entire entry in the list so won't work as you cant wildcard the entries. You may have to pull in containers within a date/time range and then do some post-processing in custom code to grab what you need from the returned values.

Re: Rest api filtering

meshorer — Wed, 29 May 2024 18:17:14 GMT

@phanTom
ok so maybe there is a way to use IN operator on values in custom fields? For exmple custom field key is department, and i want to sort for values buisness, HR

Re: Rest api filtering

SOARt_of_Lost — Fri, 31 May 2024 17:16:28 GMT

What's your end goal with this? That would affect how I'd approach the problem. Do you want a playbook to take action based on this info, or is it some kind of audit?

Re: Rest api filtering

victor_menezes — Fri, 31 May 2024 18:35:45 GMT

Yep, you'll have to have separated calls for that. Filters on SOAR REST can be appended but they will work as "AND" condition as "OR" is not supported in that sense as a limitation on Django querysets 😞

So the easiest way would be to combine the results of https://<your_soar_instance>/rest/container?_filter_name__icontains="computer" and the ones from https://<your_soar_instance>/rest/container?_filter_name__icontains="process" and finally process then accordingly.