Want to download the table list view in excel format ui action button.

srinivaskan
Tera Contributor

Hi Folks ,
I want to download the entire table data in the list view in Excel Format by using the Ui action button in the workspace ,I have a playbook workspace it will create the tasks in task table but the playbook is having the separate custom table ,in playbook each stage it create tasks in the task table ,now my requirement is when I click the button the total task table need to  download in Excel format how it will works .

@Ankur Bawiskar

3 REPLIES 3

J Siva
Tera Sage

Hi @srinivaskan 

You can download the content (list / form) by using the specially formatted URL.

Include the below script in the workspace ui action script space,

var URL = <insert specially formatted URL>
top.window.open(url,_blank);

Please go through the below article to know more on specially formatted URL.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0748853

 

Regards,

Siva

Thanks for your support ,its working Fine, but in my workspace i dont have that export button it will available for few workspaces only for my playbook workspace it s not available .i want to add the same to my workspace,how to add it.help to add the button to my workspace.

Sarthak Kashyap
Tera Expert

Hi @srinivaskan ,

I tried your problem in my PDI and it working for me 

 

I created a UI Action on incident table which is client callable and added below code 

function callFunc() {
    var url = "https://<your_instance>.service-now.com/incident_list.do?PDF";
    top.window.open(url);
}

Here if you want to download in CSV replace PDF with CSV 

SarthakKashyap_0-1740158631246.png

 

For workspace we already have a option to export the etire table 

SarthakKashyap_1-1740158676439.png

 

Please mark my answer correct and helpful if this works for you

Thanks and Regards

Sarthak