Splunk Search

Using the Splunk SDK for PHP, how do I output a search result in a CSV file?

ektasiwani
Communicator

Hi,

I want to get results of a search in a CSV file.
I tried this, but its giving me error HTTP 400 Invalid output mode specified (CSV).

$searchParams = array(
    'output_mode' => 'CSV',
    'earliest_time' => '-60m@m',    
    'latest_time' => 'now'

    );

If I remove the output_mode parameter, I am getting a normal result (I mean result on browser screen) and I am using wamp for this.
I tried with oneshot search and blocking search, but both result in the same error.

Thanks

0 Karma
1 Solution

goodsellt
Contributor

Hey, you've probably figured this out, however it does not recognize any of the "output_mode" parameters in anything other than all lowercase, so you'll get that error until you change it to "csv" and so on for the others.

View solution in original post

goodsellt
Contributor

Hey, you've probably figured this out, however it does not recognize any of the "output_mode" parameters in anything other than all lowercase, so you'll get that error until you change it to "csv" and so on for the others.

_smp_
Builder

Bingo, thanks for this response.

0 Karma
Get Updates on the Splunk Community!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

(view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...