Splunk SOAR (f.k.a. Phantom)

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!

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...