topic Getting containers from Jan to March using REST API in Splunk SOAR

Getting containers from Jan to March using REST API

JoshiSri — Wed, 19 Apr 2023 10:03:23 GMT

Hi there,

I am trying to get the containers detials for stipulated time period, Lets say, Jan 1st 2023 - March 31st - 2023.

May I know what is the format here to get it from REST API. I am trying using below query and getting the results from the very latest conatiners as well.

https://phantom.example.com/rest/container?sort=id&order=desc&label='phishing'&page_size=40000&"start_time"="2023-03-01T00:00:41.728895Z"

Sample output: sharing only one key: value pair

"start_time": "2023-04-19T07:36:41.728895Z",

Re: Getting containers from Jan to March using REST API

phanTom — Wed, 19 Apr 2023 10:10:09 GMT

@JoshiSri you need to use the lte/gte conditions in the REST call:

e.g.

/rest/container?_filter_start_time__gte="2023-01-01T00:00:00"&_filter_start_time__lte="2023-03-01T00:00:00"

Note the double "_" for the lte/gte

You can use python to create the date/time strings if you need to do this dynamically.

-- If this helped please mark as the solution. Happy SOARing --

Re: Getting containers from Jan to March using REST API

JoshiSri — Wed, 19 Apr 2023 10:19:34 GMT

Awesome, worked like charm..!!

One last query, is there any limit for "page_size=40000" and "label='phishing'" this condition, is not working at all, is there a different way to parse label as phishing only containers?

Thanks again, for your quick response.

Re: Getting containers from Jan to March using REST API

phanTom — Wed, 19 Apr 2023 10:26:59 GMT

@JoshiSri you need to add `_filter_<field>` to your query.

Also I am not sure about the page size but if you set it to 0 then you get all.

Re: Getting containers from Jan to March using REST API

JoshiSri — Wed, 19 Apr 2023 11:31:09 GMT

Superb..!! Again, on the mark. Is there any doc for these kind of parameters?

The one on the phantom doc is very on the higher level and is of no use if you want to drill down your search.

It helps, thanks a lot.

Re: Getting containers from Jan to March using REST API

phanTom — Wed, 19 Apr 2023 11:39:22 GMT

This is the best one from a fellow trust member:

https://github.com/zamastyle/phantom_mhike/blob/main/Rest%20API%20Cheat%20Sheet.md

Feel free to mark as a solution to help others with similar issues/queries