topic How to use Spring XML Application to read data and retrieve search results from Splunk and convert it into CSV format? in Getting Data In https://community.splunk.com/t5/Getting-Data-In/How-to-use-Spring-XML-Application-to-read-data-and-retrieve/m-p/242522#M47018 <P>Hi,</P> <P>I have an application (Spring XML Application) which needs to read data from Splunk and convert it into CSV format.</P> <P>I am new to Splunk. Any guidance?</P> <P>Thanks,<BR /> Phanendra</P> Wed, 18 Jan 2017 20:22:05 GMT meduriphani 2017-01-18T20:22:05Z How to use Spring XML Application to read data and retrieve search results from Splunk and convert it into CSV format? https://community.splunk.com/t5/Getting-Data-In/How-to-use-Spring-XML-Application-to-read-data-and-retrieve/m-p/242522#M47018 <P>Hi,</P> <P>I have an application (Spring XML Application) which needs to read data from Splunk and convert it into CSV format.</P> <P>I am new to Splunk. Any guidance?</P> <P>Thanks,<BR /> Phanendra</P> Wed, 18 Jan 2017 20:22:05 GMT https://community.splunk.com/t5/Getting-Data-In/How-to-use-Spring-XML-Application-to-read-data-and-retrieve/m-p/242522#M47018 meduriphani 2017-01-18T20:22:05Z Re: How to use Spring XML Application to read data and retrieve search results from Splunk and convert it into CSV format? https://community.splunk.com/t5/Getting-Data-In/How-to-use-Spring-XML-Application-to-read-data-and-retrieve/m-p/242523#M47019 <P>Hi Phanendra, </P> <P>There are two search commands you can use to convert Splunk search results into .csv. </P> <P><STRONG>outputcsv</STRONG><BR /> This command saves search results to the specified CSV file on the local search head in the $SPLUNK_HOME/var/run/splunk/csv directory. Updates to $SPLUNK_HOME/var/run/*.csv using the outputcsv command are not replicated across the cluster. <BR /> For details, see <A href="http://docs.splunk.com/Documentation/Splunk/6.5.1/SearchReference/Outputcsv" target="_blank">http://docs.splunk.com/Documentation/Splunk/6.5.1/SearchReference/Outputcsv</A>. </P> <P><STRONG>outputlookup</STRONG><BR /> Writes search results to a static lookup table or KV store collection that you specify. <BR /> For details, see <A href="http://docs.splunk.com/Documentation/Splunk/6.5.1/SearchReference/Outputlookup" target="_blank">http://docs.splunk.com/Documentation/Splunk/6.5.1/SearchReference/Outputlookup</A>. </P> <P>Hope this helps. Thanks! <BR /> Hunter</P> Tue, 29 Sep 2020 12:28:39 GMT https://community.splunk.com/t5/Getting-Data-In/How-to-use-Spring-XML-Application-to-read-data-and-retrieve/m-p/242523#M47019 hunters_splunk 2020-09-29T12:28:39Z Re: How to use Spring XML Application to read data and retrieve search results from Splunk and convert it into CSV format? https://community.splunk.com/t5/Getting-Data-In/How-to-use-Spring-XML-Application-to-read-data-and-retrieve/m-p/242524#M47020 <P>Hi Hunter,</P> <P>Thank you for your reply. Another application is keep on writing the data. My Spring XML application has to query for every 2 minutes and retrieve the data in CSV format from the last fetch record. It should not read the data which is already read. The output CSV file must be returned to my application, It should not be saved onto local search head.</P> <P>Right now, my application is throwing error the below error.</P> <P>[java.lang.Error - Unresolved compilation problems: <BR /> The import com.google cannot be resolved<BR /> The import com.google cannot be resolved<BR /> JsonReader cannot be resolved to a type</P> <P>Any suggestions?</P> <P>Thanks,<BR /> Phanendra Meduri</P> Thu, 19 Jan 2017 14:50:14 GMT https://community.splunk.com/t5/Getting-Data-In/How-to-use-Spring-XML-Application-to-read-data-and-retrieve/m-p/242524#M47020 meduriphani 2017-01-19T14:50:14Z