Attention! The Google BigQuery integration has to be enabled to use this feature.

Importing data from Fixer

After enabling the Fixer data source, exchange rates information will be uploaded to BigQuery once every 24 hours.

Connecting and configuring

The process of connecting data sources is described in detail in the overview.

In order to connect a new data source, go to “DATA IMPORT → Automatic” (1), select the type of data source from the menu (2) and enter the API token from your Fixer personal account https://fixer.io/dashboard (3)

Configuring data source

After authorization you need to set the data source parameters.

(1) The name of the data source. It is displayed in the interface in the list of sources.

(2) The Base currency, which is the currency to which the exported exchange rates are relative to.

To save and enable the data source, click “Save” (3).

The “Disconnect” button (4) is used to revoke the authorization data. The settings are saved.

You can enable or disable the data source at any time (5).

Where to get data on exchange rates

The data for this data source will be written to a table named fixerExchangeRates_{BASE_CURRENCY}_{YYYYMMDD}

Table structure

Field name Type Mode
currency STRING REQUIRED
rate FLOAT REQUIRED