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!

2024 Splunk Career Impact Survey | Earn a $20 gift card for participating!

Hear ye, hear ye! The time has come again for Splunk's annual Career Impact Survey!  We need your help by ...

Optimize Cloud Monitoring

  TECH TALKS Optimize Cloud Monitoring Tuesday, August 13, 2024  |  11:00AM–12:00PM PST   Register to ...

What's New in Splunk Cloud Platform 9.2.2403?

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