Link to download visual data in excel format

Hi,

We have one visual in dashboard and below is the url for the same. User want to have a direct link which would allow them to download the data for the visual in excel format.
Any tag that could added to below visual, which would directly download the data in excel.

https://bigdataplatform-gcgarc.wlb3.nam.nsroot.net:38888/arc/apps/app/32425?sheet=1

Any other suggestion would greatly appreciated!!

Thank you!!!

@Ganesh you should be to download any Visual data in XLSX format in Arcadia 4.5.x and forward. There’s a few known bugs with this feature though that were also resolved in Arcadia 5.1.1. If you need the fully functionality of this feature I would suggest an upgrade to Arcadia 5.1.x.

@ Ganesh: Hey, did you find a solution for your request? I’m looking for the same. I found this, but did not work:

https://arcadia.intranet.commerzbank.com/arc/sqlrun/xlsxdownloadStore

@taddwood: Can you pls check?

Thanks!

@waiman that is the correct endpoint but you have to form the request POST body correctly. Below is an example of the Request body from a Visual XLSX download. Keep in the mind the format of this data should be JSON, so you’ll want to make sure all of the key/value pairs are formatted properly. This example is showing the JSON data already parsed so you can’t copy this directly and test it.

An easy way to grab this structure and information is to open Chrome Developer Tools and capture the request from the Network tab:

query: /* ,  */ select `row_id` as 'row_id', `order_id` as 'order_id', `order_date` as 'order_date',  as 'order_date_month',  as 'order_date_year', `order_date_string` as 'order_date_string',  as 'order_date_month_end',  as 'order_date_substring',  as 'order_date_year_month', `order_priority` as 'order_priority', `order_quantity` as 'order_quantity', `sales` as 'sales', `discount` as 'discount', `ship_mode` as 'ship_mode', `profit` as 'profit',  as 'positive_profit', `unit_price` as 'unit_price', `shipping_cost` as 'shipping_cost', `customer_name` as 'customer_name', `province` as 'province' from `default`.`superstore_sales` where ([order_date] between '2012-12-30' and '2012-12-30') limit 100
dsreq: {"version":1,"type":"SQL","limit":1000,"time":[],"session":[],"dimensions":[{"type":"SIMPLE","expr":"[row_id] as 'row_id'"},{"type":"SIMPLE","expr":"[order_id] as 'order_id'"},{"type":"SIMPLE","expr":"[order_date] as 'order_date'"},{"type":"SIMPLE","expr":"[order_date_month] as 'order_date_month'"},{"type":"SIMPLE","expr":"[order_date_year] as 'order_date_year'"},{"type":"SIMPLE","expr":"[order_date_string] as 'order_date_string'"},{"type":"SIMPLE","expr":"[order_date_month_end] as 'order_date_month_end'"},{"type":"SIMPLE","expr":"[order_date_substring] as 'order_date_substring'"},{"type":"SIMPLE","expr":"[order_date_year_month] as 'order_date_year_month'"},{"type":"SIMPLE","expr":"[order_priority] as 'order_priority'"},{"type":"SIMPLE","expr":"[order_quantity] as 'order_quantity'"},{"type":"SIMPLE","expr":"[sales] as 'sales'"},{"type":"SIMPLE","expr":"[discount] as 'discount'"},{"type":"SIMPLE","expr":"[ship_mode] as 'ship_mode'"},{"type":"SIMPLE","expr":"[profit] as 'profit'"},{"type":"SIMPLE","expr":"[positive_profit] as 'positive_profit'"},{"type":"SIMPLE","expr":"[unit_price] as 'unit_price'"},{"type":"SIMPLE","expr":"[shipping_cost] as 'shipping_cost'"},{"type":"SIMPLE","expr":"[customer_name] as 'customer_name'"},{"type":"SIMPLE","expr":"[province] as 'province'"}],"aggregates":[],"partitions":[],"filters":["[order_date] between '2012-12-30' and '2012-12-30'"],"outerFilters":[],"having":[],"global_segments":[{"type":"SEGMENT","segments":[]}],"events":[],"distinct":false,"derived_data":[],"solr_query":[],"autotime_override":"","dataset_id":731}
async: true
cache_read: true
parameters_case_sensitive: true
is_edit: true
viz_params: {"order_date_2.start":"2009-01-01","order_date_2.end":"2012-12-30","order_date_2.include_nulls":"false","order_date_3.start":"2012-12-30 00:00:00","order_date_3.end":"2012-12-30 00:00:00","order_date.start":"2012-12-30","order_date.end":"2012-12-30"}
report_id: 19031
parent_report_id: 19033
dataset_id: 731
dataconnection_id: 76
xlsxfilename: Untitled_20200507073306.xlsx