Has anyone successfully managed to retrieve Business Report data from IFS to an external application - through API/Projection (or using Boomi).
Generate a BR report and then use that result as something that need to be transferred to an external application.
Our scenario is that we need to create balance sheet/P&L and then transfer the result to a Consolidation system for the parent company. These reports are created in BR.
I can find the created BR report in Excel_Report_Archive, as an Excel file but I have not managed to access the data. There doesn’t seem to be any generated API’s for Business reports either, for Quick Reports there are API’s automatically created that can be used to extract the data from IFS.
Or maybe this has to be solved in Excel, through the generated Excel Sheet - to manually trigger a transfer with some sort of script?
