topic Re: How can I create an External Lookup that does not create a CSV but displays the results? in Knowledge Management

How can I create an External Lookup that does not create a CSV but displays the results?

danfein — Tue, 19 Dec 2017 04:15:31 GMT

I am looking to run a python script that will take the results of several API calls and make them into something that Splunk displays as if the data were retrieved from its own indexing.

Is it possible to run on the fly queries like this?:

Search in Splunk >
External lookup is triggered >
apidata.py is invoked >
Data returned in some way to Splunk >
Displayed in Splunk

I believe this is possible, but the only way I have seen it thus far has been with CSVs, but the data returned will be high.

Re: How can I create an External Lookup that does not create a CSV but displays the results?

nickhills — Tue, 19 Dec 2017 09:48:28 GMT

You want to use a scripted input.
http://docs.splunk.com/Documentation/Splunk/7.0.1/AdvancedDev/ScriptSetup

This is very common and is simple to do. You can make you life even easier if your script returns a date and key=value pairs as its response, as Splunk would need no further extractions to fully interpret and index your data.

Re: How can I create an External Lookup that does not create a CSV but displays the results?

danfein — Wed, 20 Dec 2017 00:19:40 GMT

This doesn't look like something that would take in a custom query from Splunk, am I mistaken?

Re: How can I create an External Lookup that does not create a CSV but displays the results?

kamlesh_vaghela — Wed, 20 Dec 2017 03:57:31 GMT

HI @danfein,

I think Splunk Custom command will help you. You just create a custom command and write some python code to call APIs and display values as a result. There are few links which can be helpful you to create custom command.

http://docs.splunk.com/Documentation/SplunkCloud/6.6.3/Search/Writeasearchcommand
https://docs.splunk.com/Documentation/SplunkCloud/6.6.3/Search/Customsearchcommandshape
http://dev.splunk.com/view/python-sdk/SP-CAAAEU2
https://www.splunk.com/blog/2014/04/14/building-custom-search-commands-in-python-part-i-a-simple-generating-command.html

Thanks