Is there API programming to generate the automate report and export to excel and pulled into the POWER BI tool and show the chart

[prasanjit2]

Hi,

I am new to the Service now.

is theresomething kind of API where allows you to invoke the reports and export to excel file /json/pdf and pulled in by POWERBI and show the chart.

Thanks

Prasanjit Swain

[Prasanjit]

Thanks Mario for sharing the Link.

Using the Adam link https://docs.servicenow.com/bundle/orlando-application-development/page/integrate/inbound-rest/conce...       

I was able to create an API, however the file comes in JSON/XML format. Is there way to get the file in EXCEL format in order to achieve this. Thanks much

Please share the docs/links if you have it

[Adam Stout]

Open a list view in a window without the main rame around it. Add &XLS to the end if.  (XLSX may work too, but I don't remember).