Connect to Spark via multiple methods

To save you time and effort, we’ve built multiple options for you to integrate our data into your systems.

Excel Add-in Excel Add-in

Retrieve Spark prices directly from within your Excel sheet.

More details
Spark API Spark API

Integrate with your systems directly via our API.
Automatically update forward curves, get additional prices for marking positions, bolster risk management systems and use the Spark prices to support analysis. No more manual downloads required and designed for the future.

More details
Spark Webhooks Spark Webhooks

Get the latest price information as they are released automatically via our Webhooks API.
Benefits include getting the latest prices as they are released and receiving an updated price when there’s a price correction.

More details
Power BI Power BI

Retrieve Spark prices into Power BI

More details
3rd-Party Connectors

Retrieve our prices via our 3rd-party connectors.
Available to Spark Premium subscribers. 3rd Party Connectors may apply additional costs.

ZEMA™ ZEMA™
Morningstar Morningstar
Enverus Enverus

Frequently Asked Questions

Firstly, you need an account with us. Any existing Spark accounts within your organisation can be used or you can also create a new account set up as a developer (which doesn't count towards number of nominated Spark Premium accounts).
For Premium plan users:
Navigate to “Contract” > “Data integrations” > “Spark API” on the sidebar menu and follow the steps in this page to access our API.

For Basic plan users: Download button Click on the download button and select “Download with our API”. Follow the steps in this page to access our API.

All Spark users have basic access which means that you can access the SparkS price for free but with a limited dataset.

To access the SparkFo, historical data and wider data sets, users must have premium access which applies on an organisation level. Please get in touch if you'd like more detailed information.

As our API evolves, we will ensure that the older versions of the endpoints remain available to limit any changes on your side. We'll make sure you have enough time to move to the latest version.
The data available via the API is linked to your organisation. This is to ensure that people changes are easier to manage in the future. Additional users can be added to ensure the right teams and people have access to the information and each organisation has a secure, unique token.
The information available via the API is linked to your permission status. Unlimited access to historical data and full forward curves is only available to those with Premium access. Get in touch to find out more.
Yes, your data is secure. Spark uses a HTTPS over TLS (HyperText Transfer Protocol Secure) as a secured, bidirectional tunnel for communication and OAuth2 as authorization framework.

Rate limiting of the API is primarily on per-customer basis — or more accurately described, per user access token. Following limits are currently the default setting:

  • Throttling (requests per second): 50 req/sec
  • Burst (bucket size): 200
  • Quota (requests per day): 1000 req/day

You can request an increase of these limits. Please contact us directly via contact@sparkcommodities.com and describe your scenario.

Either analysts with previous API experience or your IT teams should be comfortable with this. We've designed our API to make it as quick and easy as possible. We are also always available to help if needed.

Power BI


Overview

This guide is intended to get you set up with our custom Power BI connector.

The custom connector is supported for Power BI Desktop.

1) Installation

Install the connector

  1. Download https://static.sparkcommodities.com/downloads/spark_powerbi_connector.pqx
  2. Go to C:\Users\[LOCAL USER]\Documents\Power BI Desktop\Custom Connectors and insert the spark\_powerbi\_connector.pqx file.

Trust the connector

  1. Open Registry Editor
  2. The registry path is HKEY\_LOCAL\_MACHINE\Software\Policies\Microsoft\Power BI Desktop. Make sure the path exists, or create it. This location is chosen due to it being primarily controlled by IT policy and requiring local machine administration access to edit.
  3. Add a new value under the path specified in the previous image. The type should be Multi-String Value: REG\_MULTI\_SZ. It should be called TrustedCertificateThumbprints. Value is 0CBAD0024E74A2731DDFC7486461E6646936150B




2) Using the Connector

  1. Open PowerBI Desktop
  2. Get Data -> More…
  3. Under Other, find SparkConnector
  4. Enter your app.sparkcommodities.com credentials
  5. Select the data you would like to load
  6. You may now use the loaded data for modelling

3) Troubleshooting

Logging out

To logout of your Spark account in PowerBI Desktop,

  1. At the top, File -> Options and settings -> Data source settings
  2. Select SparkConnector and click Clear Permissions