Splunk SOAR

Getting containers from Jan to March using REST API

JoshiSri
Explorer

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&"star...

 

Sample output: sharing only one key: value pair

"start_time": "2023-04-19T07:36:41.728895Z",
0 Karma
1 Solution

phanTom
SplunkTrust
SplunkTrust

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

View solution in original post

phanTom
SplunkTrust
SplunkTrust

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

phanTom
SplunkTrust
SplunkTrust

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

JoshiSri
Explorer

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. 

0 Karma

JoshiSri
Explorer

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. 

0 Karma

phanTom
SplunkTrust
SplunkTrust

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

0 Karma
Get Updates on the Splunk Community!

Splunk Certification Support Alert | Pearson VUE Outage

Splunk Certification holders and candidates!  Please be advised of an upcoming system maintenance period for ...

Enterprise Security Content Update (ESCU) | New Releases

In September, the Splunk Threat Research Team had two releases of new security content via the Enterprise ...

New in Observability - Improvements to Custom Metrics SLOs, Log Observer Connect & ...

The latest enhancements to the Splunk observability portfolio deliver improved SLO management accuracy, better ...