topic Re: search/jobs/export does not return results with empty column headers in Getting Data In

search/jobs/export does not return results with empty column headers

testingteam — Mon, 28 Sep 2020 14:02:06 GMT

I using the following command to retrieve a particular macro search result.

curl -k -u admin:admin https://:8089/services/search/jobs/export --data search="search `network_macro(index_name,report_name,server_name,1h)`" -d output_mode=csv

Expected result:
"_time",ServerName,Freq,Bandwidth
"2013-06-03 06:00:00.000 UTC",server1,"74.730000",""
"2013-06-03 07:00:00.000 UTC",server2,"74.730000",""

But the actual result is :
"_time",ServerName,Freq
"2013-06-03 06:00:00.000 UTC",server1,"74.730000"
"2013-06-03 07:00:00.000 UTC",server2,"74.730000"

The column that have empty result has not been returned.

But it is worked well while using
search/jobs/{search_id}
search/jobs/{search_id}/results commands.
I am using Splunk 4.3.1 .

How can we get those empty result columns by using the search/jobs/export url.

Re: search/jobs/export does not return results with empty column headers

MuS — Tue, 04 Jun 2013 09:22:59 GMT

Hi testingteam

try to use your search with the fillnull command, read more here http://docs.splunk.com/Documentation/Splunk/5.0.3/SearchReference/Fillnull

hope this helps, MuS

Re: search/jobs/export does not return results with empty column headers

testingteam — Wed, 05 Jun 2013 07:46:38 GMT

Thanks Mus,for your answer.
I have 'n'number of columns.Adding 'fillnull' with all the Columnn names for each query, its hard.

Same macro in 'Search Head' thru Web GUI,the macro result contains all the column names (if data not exist,it displays empty).But in rest api(specifically /jobs/export) why its not returning all the columns.

/jobs/{search_id}/results url gives the expected results then why /jobs/export suppress the columns which not have data.

I expected all the column names(heading) should be returned with the result even it have data or not.

Is there any other way ? Plz help me.