Splunk Search

curl fields order on export csv

sloshburch
Ultra Champion

When running a curl for servicesNS/-/-/search/jobs/export -d search="savedsearch temp" -d output_mode=csv

I see that the fields do not output in the order as defined by the underlying search.

Conversely, when running the same curl, but removing the -d output_mode=csv, I see the fields output in the correct order.

Before opening a bug, I figured I'd check with the community. Has anyone seen this before? Known issue or by design?

Tags (3)
1 Solution

sloshburch
Ultra Champion

Oh, yes! So the answer is that the cosmetics of the search, in this case the field ordering, happen on the search UI. So it turns out the command line search doesn't do this formatting and therefore the field order is disregarded.

I highlighted that this is misleading. There is no warning to the user that they are attempting to use a command (fields, table) which will not have expected behavior.

I have case 190546 open for a feature request to "So that the order when using output=csv and the default xml output mode are consistent."

View solution in original post

sloshburch
Ultra Champion

Oh, yes! So the answer is that the cosmetics of the search, in this case the field ordering, happen on the search UI. So it turns out the command line search doesn't do this formatting and therefore the field order is disregarded.

I highlighted that this is misleading. There is no warning to the user that they are attempting to use a command (fields, table) which will not have expected behavior.

I have case 190546 open for a feature request to "So that the order when using output=csv and the default xml output mode are consistent."

cphair
Builder

Good to know. Thanks.

0 Karma

cphair
Builder

@SloshBurch, did you get an answer from Splunk on this? I'm seeing a similar behavior.

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Modernize your Splunk Apps – Introducing Python 3.13 in Splunk

We are excited to announce that the upcoming releases of Splunk Enterprise 10.2.x and Splunk Cloud Platform ...

Step into “Hunt the Insider: An Splunk ES Premier Mystery” to catch a cybercriminal ...

After a whole week of being on call, you fell asleep on your keyboard, and you hit a sequence of buttons that ...