Bank Statement API

[RR8]

Hi

Does anyone currently connect to bank via an API to download bank statement information to run reconciliations  retrieve balances etc?

How do you go about getting an API set up with the bank - I have heard of OBIE but not sure what the process is.

Alteryx would work very well  for automating recs and retrieving balances - is their a use case out there anyone can share example?

thanks for help

[BrandonB · Accepted solution]

Hi @RR8 

Every API is a little bit different, but this is the general concept: https://community.alteryx.com/t5/Engine-Works/REST-API-In-5-Minutes-No-Coding/ba-p/8137 

If the vendor has an API available, it is normally just a matter of connecting to the right URL, passing the right header/payload/authentication information, and it will return the data requested. This is of course a great advantage over manually downloading Excel files. If you can provide some more information about the specific bank and API in question I can help with a bit more custom catered advice. Otherwise, the link above goes through the basics.