Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Bank Statement API

RR8
7 - Meteor

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

1 REPLY 1
BrandonB
Alteryx
Alteryx

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. 

Labels
Top Solution Authors