I am working on Reconciliation report in Power BI and need to get data from Payment gateway, to which I have only login details only available for access. What should be the best possible ways to get data from API based payment gateways like Bambora and chase E-xact??
It should have the same logic as others.
Please refer to these documents: