...
The ECB Exchange Rates only provide the exchange rates from the Euro Dollar against other currencies. To use ECB Exchange Rates the Lead Currency in Apliqo FPM must be EUR - Euro Dollar in Apliqo FPM.
Alpha Vantage is more flexible and offers exchange rates for a broader array of currency pairs. To access Alpha Vantage's data source, you need to acquire a Rapid API access token, which is free. The Basic tier service allows access to foreign exchange rates with certain restrictions, such as a limit of 500 API queries per month and a cap of 50 API calls per minute. Information regarding registration and subscription to Alpha Vantage can be found at https://docs.rapidapi.com/docs/api-pricing. The FX Downloader can be set up to prevent exhausting of API limits in terms of the number of API calls per minute, particularly if your plan has stricter restrictions than the default ones.
...
Locate <FPM install location>\Batch\fxdownload\Config\ folder and open config.json file in a text editor.
Locate tm1_instances object inside the config.json file. Out of the box version of the file contains a default connection object called “default”.
Specify connection information to your Apliqo FPM instance inside the default object data fields. You may specify following details, only basic are listed below, all are compatible with TM1Py TM1Service class. Do not modified modify any other values outside the default connection object data field. Save the config.json file after changing the connection information.
...
The credentials will be stored by the FX Download inside a system keychain on the server you are running the FX Downloader on. This guarantees the security of the credentials stored. The keychain is password protected and only available to the Windows AD account that is running the Apliqo FPM service. The FX Download does not store the sensitive information outside the keychain and doesn’t output the information to a display or any system logs.
Supply a valid connection object name from config.json in parameter pConnection should you define your own connection information other than default.
Connection test with the provided credentials will be attempted before populating the credential values into a system keychain. Should the connection test fail, the credentials will not be stored in the keychain.
Success or failure of the credentials store action will be communicated by the Apliqo FPM messaging framework. Messages are output into }APQ Process Response Message cube and to the TM1 System Log (tm1server.log) and the FX Downloader log file. If the connection test succeeds the FX Downloader will set Credentials setup option in }APQ Settings cube to 'Y'.
...
The Rapid API access key is considered sensitive information and will be stored by the FX Downloader inside a system keychain.
Supply a valid connection object name from config.json in parameter pConnection should you define your own connection information other than default.
Connection test with provided credentials will be attempted before populating the credential values into a system keychain. Should the connection test fail, the credentials will not be stored!
Success or failure of the credentials store action will be communicated by the Apliqo FPM messaging framework. Messages are output into }APQ Process Response Message cube and in the TM1 System Log (tm1server.log) and the application log file. If the connection test succeeds the FX Downloader will set Credentials setup option in }APQ Settings cube to Y.
...