API to Extract data for use PowerBI

[kieran_shah22]

Hi, 

We have two reports built in the intelligence module one for Expense and one for Invoices. 

Invoice Report is called "Invoice Extracted" - it has these fields: 

The Expense Report i want to replicate: 

Is this possible through using the API? As we want to use this for some internal reporting in our Power BI suite. 

Regards, 

Kieran

[KevinD]

@kieran_shah22 I'm not 100% sure what you are asking. You want to build a report in Cognos reporting that has the data items shown in the second screenshot? 

Please clarify. 🙂

[kieran_shah22]

@KevinD I am looking for a way to extract this data using the API, So I can implement it into our inhouse Power BI reports. I have been directed to try these api calls [https://developer.concur.com/api-reference/expense/expense-report/v3.reports.html] & [https://developer.concur.com/api-reference/invoice/v3.payment-request.html] but not sure how I am supposed to get some of the other bits of data... 

[KevinD]

@kieran_shah22 does it need to be extracted with an API or are you looking for a way to get all this data into one file, like in Excel or XML?

[kieran_shah22]

@KevinD Yes ideally would be good to get a direct report so we can compare to what is in our GL. Yes trying to get in either XML or JSON. 

[KevinD]

@kieran_shah22 Cognos reports can be run in XML format. As for JSON, that's out of my wheelhouse unless you want to use our Data Delivery Service.

[kieran_shah22]

@KevinD We currently have these reports set up in Cognos, However we want to move to our internal Power Bi dashboards to keep all the reports uniform, and allow us to complete some reconciliations / comparisons with what is on our GL system. I do not believe we have access to the DDS? or is there a way to call the cognos report into pbi? 

[KevinD]

@kieran_shah22 we do not have any connectors from Cognos to other systems.