Splunk SOAR

how to export JSON to CSV

prasanthkota
Engager

Hello All,

New to SPLUNK SOAR. Is there a function or developed by someone where i am trying to export the JSON (output of a splunk query) to CSV? The intent is to add the attachment to our incident management system.

Labels (2)
0 Karma

soar_user
New Member

@prasanthkota did you get this working? I am working on a custom function to convert the splunk query result in the vaultid to csv and would like to know if there is one that already exists for this? what was your end custom function?

0 Karma

prasanthkota
Engager

Thanks @phanTom , I am new to Splunk Soaring is there a custom function that is already built for this? Its ok even if its a basic one I can modify based on the requirement. 

0 Karma

phanTom
SplunkTrust
SplunkTrust

@prasanthkota you would need to use a custom function to take the JSON results and then build a csv, attach it to the vault, then used that vault file to send to your ticketing system. 

https://docs.splunk.com/Documentation/SOARonprem/6.1.0/PlaybookAPI/VaultAPI 

 

- Happy SOARing! Please mark as a solution if it solved your question. -

Get Updates on the Splunk Community!

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...

AI for AppInspect

We’re excited to announce two new updates to AppInspect designed to save you time and make the app approval ...

App Platform's 2025 Year in Review: A Year of Innovation, Growth, and Community

As we step into 2026, it’s the perfect moment to reflect on what an extraordinary year 2025 was for the Splunk ...