Issue with Automatic CSV Report Generation from Kibana 7.13.4

[jancodenew (jan)]

Hi,

In earlier version of kibana I used to decode and encode the post url from Kibana discover tab to change the timestamp to gte: "now-24h" lte: "now" in the url to fetch last 24 hours of data while auto generating the report using the watcher.

Script usded:
[Reflection.Assembly]::LoadWithPartialName("System.Web") | Out-Null
[System.Net.WebUtility]::UrlEncode("")
[System.web.HttpUtility]::UrlDecode("")

Now i am not able to decode the post url from latest version of kibana 7.13.4 after changing the time range as mentioned above. One difference noticed in latest version of URL is that it comes with kibana query language.

Please help me to resolve this issue.

[Marius_Dragomir]

Hello,

The time range should be in plain text so you can change it without the decode, for example in my one:
/api/reporting/generate/csv_searchsource?jobParams=(browserTimezone:Europe/Paris,columns:!(),objectType:search,searchSource:(fields:!((field:'*',include_unmapped:true)),filter:!((meta:(index:'90943e30-9a47-11e8-b64d-95841ca0b247',params:()),range:(timestamp:(format:strict_date_optional_time,gte:'2020-08-03T18:24:46.927Z',lte:'2021-08-03T18:24:46.927Z')))),index:'90943e30-9a47-11e8-b64d-95841ca0b247',parent:(filter:!(),index:'90943e30-9a47-11e8-b64d-95841ca0b247',query:(language:kuery,query:'404')),sort:!((timestamp:desc)),version:!t),title:lala)