Download all active incidents in Excel xlsx format using ui page?

arey yaar · ‎10-23-2018

I need to download all active incidents of the incident table in the xlsx format ,When a button is clicked.Need to do this in ui page..

Ahmmed Ali · ‎10-24-2018

Hello,

sorry, i was checking the this in simple html page.

for UI page, below thing worked for me.

html:

<?xml version="1.0" encoding="utf-8" ?>
<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">

<button type="button" onclick="downloadIncidents()">Click Me!</button>

</j:jelly>

client script:

function downloadIncidents(){
window.location.href='https://instanceName.service-now.com/incident_list.do?sysparm_query=active=true&EXCEL';
}

This should work for you also.

Thanks,

Ali

If I could help you with your Query then, please hit the Thumb Icon and mark my answer as Correct!!

Thank you,
Ali

View solution in original post

Ahmmed Ali · ‎10-24-2018

Hello,

Not sure about xlsx format, but using below link you can download all active incidents in xls format.

just give href url as below in your button.

https://instance_name.service-now.com/incident_list.do?sysparm_query=active%3Dtrue&EXCEL

Thanks,

Ali

If I could help you with your Query then, please hit the Thumb Icon and mark my answer as Correct!!

Thank you,
Ali

arey yaar · ‎10-24-2018

it shows an error

Error:

The reference to entity "EXCEL" must end with the ';' delimiter.

Ahmmed Ali · ‎10-24-2018

replace instance name with your instance name in URL. like dev12345.

Thanks,

Ali

If I could help you with your Query then, please hit the Thumb Icon and mark my answer as Correct!!

Thank you,
Ali

arey yaar · ‎10-24-2018

I used my instance name but it shows the error

Error:

The reference to entity "EXCEL" must end with the ';' delimiter.

Ahmmed Ali · ‎10-24-2018

I tried below and it worked for me.

<button type="button" onclick="window.location.href='https://dev12345.service-now.com/incident_list.do?sysparm_query=active=true&EXCEL'">Click Me!</button>

Thanks,

Ali

If I could help you with your Query then, please hit the Thumb Icon and mark my answer as Correct!!

Thank you,
Ali