Is it possible to retrieve a report using the Hornbill API

[TomW]

Hello I was wondering if it is possible to access a report in Hornbill using one of the APIs in Hornbill?

Thanks

Tom

[Steve G]

Hi @TomW,

Yes, it's certainly possible, that's actually how our Power BI integration and data export tool both work  

Basically, all you need to do is:

• Run the report using the reporting::reportRun API
• Once the report is finished, use the reporting::reportRunGetStatus API to get the report file names, and use this to build the report content file URL
• Perform a HTTP GET request on the file URL (remembering that you need the authorization header to contain an API key that has access to the report file, for authentication).

Check out the code in those tools for working examples:

https://github.com/hornbill/rPowerBIHornbillDataSources/blob/master/PowerBIDataSource_Report.R

https://github.com/hornbill/goHornbillDataExport 

Cheers,

Steve

[TomW]

Thanks for the information Steve, it is a great help.

Cheers

Tom