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

[Adam Stout]

Generally, we discourage exporting the data out since we then end up with sync issues, security issues (we have to recreate all the security in place in the instance), and limiting the actionability of the data.

However, there are APIs to pull the data in whatever format you want:

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

[prasanjit2]

Hi Adam,

Thanks much , I will go thru this document  which you are shared . 

I want to use the API in such a way I should get the monthly/quarterly report . Shall I have a specific kind of document or video in Youtube or wherever where I can  test it. 

Regards

Prasanjit Swain 

[Prasanjit]

Hi,

I went through the document which you have shared it to me. It seems like the format I am getting is JSON /xml format. 

You can see the API link below 

https://dev74549.service-now.com/api/now/table/incident?sysparm_query=status%3Dequivalent%20id%20of%...

My acheivement is to get the data in Excel format. can you advise me where I need to do the changes in order to get the Excel format. Thank you in advance for your help.

If there is long step process to do this or if you have document related to this , please feel free to share the document to my email id pswaindevops@gmail.com

Thanks

Prasanjit Swain

[M_rio Rui Castr]

Hello Prasanjit Swain,

Its now a baseline functionality but might assist on those monthly/quarterly reports. It even has the possibility to send them directly to a specific email if that is required.

Please have a look here: https://community.servicenow.com/community?id=community_article&sys_id=35679790db1bcc90414eeeb5ca961...

Kind regards,

MRC