Not able to generate saved reports (On-demand reports) through Reporting-CLI in opensearch dashboards.

[Rajeshdaneti]

Hi Rupal, I am trying to generate a saved report through reporting-cli but getting error. Not sure whether giving a correct url-

reporting --url https://localhost:5601/app/reports-dashboards#/YNfdEIUBEXSpUhMUQPpL --format pdf --filename sales_by_cat.pdf

reporting --url https://localhost:5601/app/reports-dashboards#/report_definition_details/Kz3u64QBun0oheBCcZQK --format pdf --filename dummy1

reporting --url hhttps://localhost:5601/api/reporting/generateReport/YNfdEIUBEXSpUhMUQPpL --format pdf --filename sales_by_cat.pdf

Please help me, how to get a correct url of saved report. When I am checking saved report url from user interface - got below link, which shows report details only - https://localhost:5601/app/reports-dashboards#/report_definition_details/YNfdEIUBEXSpUhMUQPpL

I tried many ways but not able to generate. I suspect link is not correct. Please give some samples for generating on-demand saved reports through report-cli.

Regards Rajesh Kumar.

[Rajeshdaneti]

Hi All, Please assist me in resolving the aforementioned problem. For me, it is a blocker.

Regards Rajesh Kumar

[rupal-bq]

Hi Rajesh,

If you are trying to download a report which was previously downloaded using dashboard reports plugin, then you can find the corresponding url in source column.

Examples for url:

Discover: http://localhost:5601/app/discover#/view/571aaf70-4c88-11e8-b3d7-01146121b73d Dashboard: http://localhost:5601/app/dashboards#/view/7adfa750-4c81-11e8-b3d7-01146121b73d Dashboard with additional filters applied: http://localhost:5601/app/dashboards#/view/7adfa750-4c81-11e8-b3d7-01146121b73d?_g=(filters:!(),refreshInterval:(pause:!f,value:900000),time:(from:now-24h,to:now))&_a=(description:'Analyze%20mock%20flight%20data%20for%20OpenSearch-Air,%20Logstash%20Airways,%20OpenSearch%20Dashboards%20Airlines%20and%20BeatsWest',filters:!(),fullScreenMode:!f,options:(hidePanelTitles:!f,useMargins:!t),query:(language:kuery,query:''),timeRestore:!t,title:'%5BFlights%5D%20Global%20Flight%20Dashboard',viewMode:view)

NOTE: If a URL contains !, history expansion needs to be disable temporarity. bash: set +H zsh: setopt nobanghist Alternate option would be adding URL value in envirnoment variable as URL="<url-with-!>"

[rupal-bq]

Hi Rajesh,

We recently released reporting-cli. Please check https://opensearch.org/docs/latest/dashboards/reporting-cli/rep-cli-index/ for more information.