Rest api filtering

[meshorer]

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. 

[victor_menezes]

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.

[meshorer]

@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 

[SOARt_of_Lost]

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?

[phanTom]

@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.