ennoxx.banking has an optional OData interface for reading access to all data. With the help of this interface, for example, bank statement data can be displayed directly in an Excel spreadsheet and updated at a later time. However, the interface can also be accessed via another application. User authentication can be performed either via a combination of user name and password or alternatively via an AuthToken.
IWithin Excel, the call can be set up via the menu item "Retrieve data":
First you are asked to enter the URL:
This is followed by user authentication:
In the following dialog you can select one or more data types:
Once the configuration has been completed, the data (in our example, the advice transactions) is displayed in a new spreadsheet and can be subsequently adjusted or updated at any time:
