Data Sources Beginner

Connect Commodities-API to clariBI

2 min read Updated June 09, 2026
Connect Commodities-API to clariBI with your access key to sync daily commodity prices (wheat, corn, oil, sugar) for the symbols you choose, read-only, with auto-generated dashboards next to your business data.

Connect Commodities-API to clariBI with your access key to sync daily commodity prices (wheat, corn, oil, sugar) for the symbols you choose, read-only, with auto-generated dashboards next to your business data.

What is Commodities-API?

Commodities-API is a commodity-pricing API that publishes daily rates for agricultural, energy and soft commodities such as wheat, corn, Brent crude oil and sugar.

clariBI reads Commodities-API through its REST API using your own access key: the daily price history for each commodity symbol you choose, against a base currency you set. Access is read-only, and clariBI never changes anything in your account.

How to connect Commodities-API

  1. Open Data Sources in clariBI. In clariBI, go to Data SourcesAdd Data Source, find Commodities-API, and paste your access key. The key is Fernet-encrypted at rest.
  2. Choose commodities and history. Type the commodity symbols to track (for example WHEAT, CORN, BRENTOIL), set the base currency, and choose how much history to pull. clariBI reads the prices read-only.
  3. Sync, then get dashboards. clariBI syncs the daily prices, preprocesses them, and builds an insights dashboard. Ask "How did the wheat price track our input costs?" and the AI engine queries the synced prices alongside your spend.

What you can analyze

  • Daily price per commodity (Brent, WTI, wheat, sugar, and more) over your window
  • Energy versus agricultural price divergence across the commodities you track
  • Volatility in energy and agricultural commodity prices
  • Period-over-period change in a commodity price
  • Commodity price moves lined up with your purchase dates
  • Cross-source: commodity prices → input costs → margin

What gets synced

clariBI pulls the daily price history of the commodities you select through the Commodities-API timeseries endpoint, lands it as a preprocessed dataset, and refreshes it on your schedule. Access is read-only.

For each selected commodity, clariBI syncs the daily rate against your base currency, then builds an insights dashboard you can query, extend, or pull into reports.

clariBI only ever reads. It never changes anything in your Commodities-API account.

Questions across your other data

Once your records are synced, the AI engine can join them to the rest of your business data. A few examples:

PairingQuestionHow clariBI answers
Commodities-API × Costs"How much of our cost rise was the wheat price?"Planner: read the daily wheat price from Commodities-API, align it to your ingredient costs by date, and split the change into price versus volume.
Commodities-API × Margin"Did the oil-price spike squeeze our freight margin?"Planner: read the Brent crude price from Commodities-API, join it to freight margin by month, and flag the periods that moved together.

Frequently asked questions

What do I need to connect Commodities-API?

A Commodities-API access key from your Commodities-API account. You paste it into clariBI once; it is Fernet-encrypted at rest, and there is no OAuth popup or app to register.

Can clariBI change anything in Commodities-API?

No. The connector only reads the daily price history for the commodity symbols you select. It never changes anything in your account.

Which clariBI plan includes the Commodities-API connector?

Data-source connectors are available on the Trial, Starter, Professional, and Enterprise plans. You can connect Commodities-API during the free 14-day trial.

Related articles

Related Articles

Data Sources Intermediate

Connecting PostgreSQL and MySQL

Step-by-step instructions for connecting PostgreSQL and MySQL databases to clariBI. Covers connecti…

5 min read

Still Need Help?

Can't find what you're looking for? Our support team is here to help you succeed with clariBI.