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. 🙂

Thank you,
Kevin
SAP Concur Community Manager
Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.

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?

Thank you,
Kevin
SAP Concur Community Manager
Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.