topic Re: Not able to retrieve Splunk data using Splunk REST API in Getting Data In

Not able to retrieve Splunk data using Splunk REST API

mala_splunk_91 — Tue, 29 Sep 2020 20:39:41 GMT

I want to pull data out of Splunk.
So, Im using REST API to export data which uses CURL call.
For example:am trying below

curl -ku username:pass https://:/services/search/jobs --data-urlencode 'search=search index="_internal" | stats count(eval(sourcetype LIKE "splunk'%'")) AS st_splunk count AS total by host'

I get SID as result and I ran below one

curl -ku username:pass https://:/services/search/jobs//results/ -d output_mode=csv -d count=50000 -d offset=0 -o /tmp/my-output.csv

"result:

<msg type="FATAL">Method Not Allowed</msg>

Why no result found? What ma missing?
Please help on this.
Thanks in advance.
Mala S

Re: Not able to retrieve Splunk data using Splunk REST API

skoelpin — Thu, 26 Jul 2018 17:30:05 GMT

Use the REST API TA in Splunkbase. It's free and works great

https://splunkbase.splunk.com/app/1546/

Re: Not able to retrieve Splunk data using Splunk REST API

jkat54 — Thu, 26 Jul 2018 17:37:57 GMT

Looks like you’re very close but have the wrong URL for getting results.

Follow the “make sure you do” section here:
http://docs.splunk.com/Documentation/Splunk/7.1.2/Search/ExportdatausingRESTAPI

Re: Not able to retrieve Splunk data using Splunk REST API

jkat54 — Thu, 26 Jul 2018 17:39:05 GMT

Found in step 3 on the link I gave.

Also note the comment someone left about 7.1.1 saying they had to use this endpoint.

https://localhost:8089/servicesNS/admin/search/search/jobs/1423855196.339/results

Re: Not able to retrieve Splunk data using Splunk REST API

mala_splunk_91 — Wed, 01 Aug 2018 12:25:57 GMT

We need to pull data and collected in remote server which has connection with Splunk UI
So, Am running this CURL commands in remote server to pull data out of splunk UI server.
(Remote servers is separate Application server which needs splunk data).

so, this is the case, Can I do this by REST API app? or how can i pull out of splunk?

Re: Not able to retrieve Splunk data using Splunk REST API

jkat54 — Wed, 01 Aug 2018 16:15:55 GMT

Yes, but you have to build your own REST API app.

Using instructions here:
http://docs.splunk.com/Documentation/Splunk/7.1.2/Search/ExportdatausingRESTAPI