Use FXMacroData in Tableau
Create Tableau extracts from official-source macroeconomic indicators, release calendars, FX rates, commodities, and COT positioning through the FXMacroData Tableau connector package.
Named connector
The package uses Tableau Web Data Connector 3.0 so FXMacroData appears as a Tableau connector once the signed `.taco` is installed.
Extract workflow
Tableau imports selected FXMacroData rows into extracts for dashboards, workbooks, and scheduled refresh workflows.
API-key auth
The connector uses FXMacroData API keys for non-USD currencies, protected datasets, and full-history access.
Connector datasets
Each connector mode maps one FXMacroData REST endpoint family into a Tableau table.
| Connector mode | REST path | Core fields | Typical dashboard |
|---|---|---|---|
| Data catalogue | https://fxmacrodata.com/api/data_catalogue/{currency} |
indicator, name, unit, frequency, source |
Dataset inventory and indicator picker |
| Macro indicator history | https://fxmacrodata.com/api/announcements/{currency}/{indicator} |
date, value, announcement_datetime, source metadata |
CPI, policy-rate, GDP, employment, and trade monitors |
| Release calendar | https://fxmacrodata.com/api/calendar/{currency} |
date, release, indicator, status |
Upcoming macro release board |
| FX rates | https://fxmacrodata.com/api/forex/{base}/{quote} |
date, rate, base, quote |
Pair context and rate-history panels |
| Commodities | https://fxmacrodata.com/api/commodities/{indicator} |
date, price, pct_change, pct_change_12m |
Gold, oil, and commodity-linked currency overlays |
| COT positioning | https://fxmacrodata.com/api/cot/{currency} |
open_interest, noncommercial_net, commercial and nonreportable fields |
Weekly futures positioning dashboard |
Setup and distribution status
The Tableau package is implemented as a Web Data Connector 3.0 source package. A signed `.taco` build is required before production distribution or Tableau Exchange submission.
Local validation
python scripts/validate_tableau_connector.py python scripts/validate_tableau_connector.py --remote
TACO build path
cd extensions/tableau npm install npm run build npm run pack npm run run:desktop
For private testing, start with USD inflation without a key, then add an FXMacroData API key for non-USD macro, EUR/USD FX, gold commodities, and EUR COT smoke tests.
Example source requests
The connector calls the production FXMacroData API and sends your authorized key as an `api_key` query parameter when a key is provided.
https://fxmacrodata.com/api/announcements/usd/inflation https://fxmacrodata.com/api/calendar/usd https://fxmacrodata.com/api/forex/eur/usd?api_key=YOUR_API_KEY https://fxmacrodata.com/api/commodities/gold?api_key=YOUR_API_KEY https://fxmacrodata.com/api/cot/eur?api_key=YOUR_API_KEY