Auxiliary Data Import Format
Currency Rate Import Format
The SmartTUBE solution supports the import of exchange rates in the XML format of the European Central Bank (ECB). Dynamically updated rates from ECB could be obtained here, but you can use any other source with the same format.
Example
|
<gesmes:Envelope xmlns:gesmes=“http://www.gesmes.org/xml/2002-08-01” xmlns=“http://www.ecb.int/vocabulary/2002-08-01/eurofxref”> <gesmes:subject>Reference rates</gesmes:subject> <gesmes:Sender> <gesmes:name>European Central Bank</gesmes:name> </gesmes:Sender> <Cube> <Cube time=“2022-04-26”> <Cube currency=“USD” rate=“1.0674”/> <Cube currency=“JPY” rate=“136.15”/> <Cube currency=“BGN” rate=“1.9558”/> <Cube currency=“CZK” rate=“24.423”/> <Cube currency=“DKK” rate=“7.4393”/> <Cube currency=“GBP” rate=“0.84135”/> <Cube currency=“HUF” rate=“374.46”/> <Cube currency=“PLN” rate=“4.6466”/> <Cube currency=“RON” rate=“4.9458”/> <Cube currency=“SEK” rate=“10.3935”/> <Cube currency=“CHF” rate=“1.0229”/> <Cube currency=“ISK” rate=“138.40”/> <Cube currency=“NOK” rate=“9.7943”/> <Cube currency=“HRK” rate=“7.5625”/> <Cube currency=“TRY” rate=“15.7944”/> <Cube currency=“AUD” rate=“1.4828”/> <Cube currency=“BRL” rate=“5.2490”/> <Cube currency=“CAD” rate=“1.3613”/> <Cube currency=“CNY” rate=“6.9837”/> <Cube currency=“HKD” rate=“8.3735”/> <Cube currency=“IDR” rate=“15365.76”/> <Cube currency=“ILS” rate=“3.5147”/> <Cube currency=“INR” rate=“81.7265”/> <Cube currency=“KRW” rate=“1340.02”/> <Cube currency=“MXN” rate=“21.6538”/> <Cube currency=“MYR” rate=“4.6485”/> <Cube currency=“NZD” rate=“1.6102”/> <Cube currency=“PHP” rate=“55.681”/> <Cube currency=“SGD” rate=“1.4666”/> <Cube currency=“THB” rate=“36.596”/> <Cube currency=“ZAR” rate=“16.7787”/> </Cube> </Cube> </gesmes:Envelope> |
Weather Forecast Import
SmartTUBE apps allow you to provide your subscribers with a weather forecast. The Openweather service is used as the data source. If you do not know whether the corresponding module is installed on your system, please contact the SmartLabs Technical Support . Then create a job for regularly updating weather data:
- Register on the website Openweathermap.org and get your unique API key {appid=} by following the instructions on the “Guide” page.
- Create a new job using the weatherforecastsimport#doimport method in the Method field.
- In the Method parameters > appid field, specify your Openweather API key.
- In the Dictionaries > Cities > [desired city] > External ID field, specify the corresponding city ID on the Openweather website. You can find it on the https://openweathermap.org/city page after searching by the desired city. The last parameter in the URL is the city ID. Example for Moscow:
You can also specify the city geo coordinates in the Coordinates field. Example:
Please note that this field has a lower priority than the External ID.