Economic Data Series API

getCmdtyStatsId

The getCmdtyStatsId API is used identify instrument identifiers that can be passed to getCmdtyStats in order to request data on the applicable series. Users can search for data series based on search parameters covering content, source, area, frequency, and more.

View All APIs

First Name^*

Last Name^*

Email Address^*

Phone^*

Company^*

Role^*

Industry^*

Country^*

What you are looking for?^*

Please provide as much information as possible (e.g. exchanges, markets or other data sources), the APIs you are interested in (e.g. getQuote, getHistory, getChart, getCorporateActions, etc.), and your use case.

Here are some examples: Example #1, Example #2, Example #3.

By submitting this form you are opting in to receive email communications from Barchart for related product, service or company information, updates and announcements. You can unsubscribe at anytime. View our Privacy Policy.

Inputs

commodity^optional

The primary subject of item of a data series. User can pass values such as "soy" and expect data series infomation for "soybean" and "soybeans" to be returned

Type

string (A sequence of characters. (example: GOOG))

Example

Corn

measurement^optional

The measured aspect of a item

Type

string (A sequence of characters. (example: GOOG))

Example

Production

area^optional

The geographic location of data series. Passing less specific queires - such as "america" in lieu of "united states" may be preferable to return meta for all possibly applicable data series

Type

string (A sequence of characters. (example: GOOG))

Example

United States of America

source^optional

The originating sources of a data series. May include organization, associated report, data table, down to sourcing figure

Type

string (A sequence of characters. (example: GOOG))

Example

USDA

maxRecords^optional

The maximum amount of records returned. This parameter should be set to the maximum number of records desired.

Type

enum (A type which includes a list of valid possible values.)

Example

50

Default

200

Valid Values

50, 100, 150, 200, 250, 300, 350, 400, 450, 500

page^optional

The page value to use in order to determine the offset while returning results.

Type

integer (A numeric type defining a whole number. (example: 2))

Example

1

Default

Outputs

shortSymbol
always returned

A shorter alernate symbol for the data series.

string
A sequence of characters. (example: GOOG)

seriesDescription
always returned

A short description of the data series, that is created via concatenation of the following 4 data elements delimited by semicolons: "item";"measurement,frequency,unitDescription";"area";"sourcing figure"

string
A sequence of characters. (example: GOOG)

Status Code Responses

200

Success

400

Bad Request

The request was invalid, please see the message for more information.

500

Internal Server Error

Something is not working correctly, please contact support.

JSON

GET

GET https://ondemand.websol.barchart.com/getCmdtyStatsId.json?apikey=YOUR_API_KEY&commodity=Corn&measurement=Production&area=United+States+of+America&source=USDA&maxRecords=50&page=1
Host: ondemand.websol.barchart.com

POST

POST https://ondemand.websol.barchart.com/getCmdtyStatsId.json
Host: ondemand.websol.barchart.com
Content-Type: application/x-www-form-urlencoded
Content-Length: length

apikey=YOUR_API_KEY&commodity=Corn&measurement=Production&area=United+States+of+America&source=USDA&maxRecords=50&page=1

Response

{
    "status": {
        "code": 200,
        "message": "Success."
    },
    "results": [
        {
            "shortSymbol": "UD04006M.CS",
            "seriesDescription": "Corn;Production,Annual,Bushel;Colorado;Corn for Grain Area Harvested, Yield, and Production"
        },
        {
            "shortSymbol": "UD04007F.CS",
            "seriesDescription": "Corn;Production,Annual,Bushel;Oklahoma;Corn for Grain Area Harvested, Yield, and Production"
        },
        {
            "shortSymbol": "UD040085.CS",
            "seriesDescription": "Corn;Production - Aug Forecast,Annual,Bushel;Kansas;Corn for Grain Area Harvested, Yield, and Production"
        },
        {
            "shortSymbol": "UD04008Q.CS",
            "seriesDescription": "Corn;Production - Aug Forecast,Annual,Bushel;Washington;Corn for Grain Area Harvested, Yield, and Production"
        },
        {
            "shortSymbol": "UD04008X.CS",
            "seriesDescription": "Corn;Production - Sep Forecast,Annual,Bushel;Delaware;Corn for Grain Area Harvested, Yield, and Production"
        },
        {
            "shortSymbol": "UD04009P.CS",
            "seriesDescription": "Corn;Production - Sep Forecast,Annual,Bushel;Wisconsin;Corn for Grain Area Harvested, Yield, and Production"
        },
        {
            "shortSymbol": "UD0400AG.CS",
            "seriesDescription": "Corn;Production - Oct Forecast,Annual,Bushel;Pennsylvania;Corn for Grain Area Harvested, Yield, and Production"
        },
        {
            "shortSymbol": "UD0400AP.CS",
            "seriesDescription": "Corn;Production - Nov Forecast,Annual,Bushel;Alabama;Corn for Grain Area Harvested, Yield, and Production"
        },
        {
            "shortSymbol": "UD0400AT.CS",
            "seriesDescription": "Corn;Production - Nov Forecast,Annual,Bushel;Delaware;Corn for Grain Area Harvested, Yield, and Production"
        },
        {
            "shortSymbol": "UD0400BG.CS",
            "seriesDescription": "Corn;Production - Nov Forecast,Annual,Bushel;South Dakota;Corn for Grain Area Harvested, Yield, and Production"
        },
        {
            "shortSymbol": "UD04031W.CS",
            "seriesDescription": "Corn;Inventory,Quarterly,Bushel;Indiana;Corn Stocks by Position"
        },
        {
            "shortSymbol": "UD040320.CS",
            "seriesDescription": "Corn;Inventory,Quarterly,Bushel;Louisiana;Corn Stocks by Position"
        },
        {
            "shortSymbol": "UD04032A.CS",
            "seriesDescription": "Corn;Inventory,Quarterly,Bushel;New Jersey;Corn Stocks by Position"
        },
        {
            "shortSymbol": "UD04032E.CS",
            "seriesDescription": "Corn;Inventory,Quarterly,Bushel;North Dakota;Corn Stocks by Position"
        },
        {
            "shortSymbol": "UD04032K.CS",
            "seriesDescription": "Corn;Inventory,Quarterly,Bushel;South Dakota;Corn Stocks by Position"
        },
        {
            "shortSymbol": "UD04032O.CS",
            "seriesDescription": "Corn;Inventory,Quarterly,Bushel;Virginia;Corn Stocks by Position"
        },
        {
            "shortSymbol": "UD0403EK.CS",
            "seriesDescription": "Corn;Production, Annual, Bushel;CO-D80;Corn for Grain Area Harvested, Yield, and Production"
        },
        {
            "shortSymbol": "UD0403EL.CS",
            "seriesDescription": "Corn;Production, Annual, Bushel;CO-D90;Corn for Grain Area Harvested, Yield, and Production"
        },
        {
            "shortSymbol": "UD0403FZ.CS",
            "seriesDescription": "Corn;Production, Annual, Bushel;KS-D30;Corn for Grain Area Harvested, Yield, and Production"
        },
        {
            "shortSymbol": "UD0403GG.CS",
            "seriesDescription": "Corn;Production, Annual, Bushel;LA-D50;Corn for Grain Area Harvested, Yield, and Production"
        }
    ]
}

XML

GET

GET https://ondemand.websol.barchart.com/getCmdtyStatsId.xml?apikey=YOUR_API_KEY&commodity=Corn&measurement=Production&area=United+States+of+America&source=USDA&maxRecords=50&page=1
Host: ondemand.websol.barchart.com

POST

POST https://ondemand.websol.barchart.com/getCmdtyStatsId.xml
Host: ondemand.websol.barchart.com
Content-Type: application/x-www-form-urlencoded
Content-Length: length

apikey=YOUR_API_KEY&commodity=Corn&measurement=Production&area=United+States+of+America&source=USDA&maxRecords=50&page=1

Response

<?xml version="1.0" encoding="utf-8"?>
<getCmdtyStatsId>
  <status>
    <code>200</code>
    <message>Success.</message>
  </status>
  <item>
    <shortSymbol>UD04006M.CS</shortSymbol>
    <seriesDescription>Corn;Production,Annual,Bushel;Colorado;Corn for Grain Area Harvested, Yield, and Production</seriesDescription>
  </item>
  <item>
    <shortSymbol>UD04007F.CS</shortSymbol>
    <seriesDescription>Corn;Production,Annual,Bushel;Oklahoma;Corn for Grain Area Harvested, Yield, and Production</seriesDescription>
  </item>
  <item>
    <shortSymbol>UD040085.CS</shortSymbol>
    <seriesDescription>Corn;Production - Aug Forecast,Annual,Bushel;Kansas;Corn for Grain Area Harvested, Yield, and Production</seriesDescription>
  </item>
  <item>
    <shortSymbol>UD04008Q.CS</shortSymbol>
    <seriesDescription>Corn;Production - Aug Forecast,Annual,Bushel;Washington;Corn for Grain Area Harvested, Yield, and Production</seriesDescription>
  </item>
  <item>
    <shortSymbol>UD04008X.CS</shortSymbol>
    <seriesDescription>Corn;Production - Sep Forecast,Annual,Bushel;Delaware;Corn for Grain Area Harvested, Yield, and Production</seriesDescription>
  </item>
  <item>
    <shortSymbol>UD04009P.CS</shortSymbol>
    <seriesDescription>Corn;Production - Sep Forecast,Annual,Bushel;Wisconsin;Corn for Grain Area Harvested, Yield, and Production</seriesDescription>
  </item>
  <item>
    <shortSymbol>UD0400AG.CS</shortSymbol>
    <seriesDescription>Corn;Production - Oct Forecast,Annual,Bushel;Pennsylvania;Corn for Grain Area Harvested, Yield, and Production</seriesDescription>
  </item>
  <item>
    <shortSymbol>UD0400AP.CS</shortSymbol>
    <seriesDescription>Corn;Production - Nov Forecast,Annual,Bushel;Alabama;Corn for Grain Area Harvested, Yield, and Production</seriesDescription>
  </item>
  <item>
    <shortSymbol>UD0400AT.CS</shortSymbol>
    <seriesDescription>Corn;Production - Nov Forecast,Annual,Bushel;Delaware;Corn for Grain Area Harvested, Yield, and Production</seriesDescription>
  </item>
  <item>
    <shortSymbol>UD0400BG.CS</shortSymbol>
    <seriesDescription>Corn;Production - Nov Forecast,Annual,Bushel;South Dakota;Corn for Grain Area Harvested, Yield, and Production</seriesDescription>
  </item>
  <item>
    <shortSymbol>UD04031W.CS</shortSymbol>
    <seriesDescription>Corn;Inventory,Quarterly,Bushel;Indiana;Corn Stocks by Position</seriesDescription>
  </item>
  <item>
    <shortSymbol>UD040320.CS</shortSymbol>
    <seriesDescription>Corn;Inventory,Quarterly,Bushel;Louisiana;Corn Stocks by Position</seriesDescription>
  </item>
  <item>
    <shortSymbol>UD04032A.CS</shortSymbol>
    <seriesDescription>Corn;Inventory,Quarterly,Bushel;New Jersey;Corn Stocks by Position</seriesDescription>
  </item>
  <item>
    <shortSymbol>UD04032E.CS</shortSymbol>
    <seriesDescription>Corn;Inventory,Quarterly,Bushel;North Dakota;Corn Stocks by Position</seriesDescription>
  </item>
  <item>
    <shortSymbol>UD04032K.CS</shortSymbol>
    <seriesDescription>Corn;Inventory,Quarterly,Bushel;South Dakota;Corn Stocks by Position</seriesDescription>
  </item>
  <item>
    <shortSymbol>UD04032O.CS</shortSymbol>
    <seriesDescription>Corn;Inventory,Quarterly,Bushel;Virginia;Corn Stocks by Position</seriesDescription>
  </item>
  <item>
    <shortSymbol>UD0403EK.CS</shortSymbol>
    <seriesDescription>Corn;Production, Annual, Bushel;CO-D80;Corn for Grain Area Harvested, Yield, and Production</seriesDescription>
  </item>
  <item>
    <shortSymbol>UD0403EL.CS</shortSymbol>
    <seriesDescription>Corn;Production, Annual, Bushel;CO-D90;Corn for Grain Area Harvested, Yield, and Production</seriesDescription>
  </item>
  <item>
    <shortSymbol>UD0403FZ.CS</shortSymbol>
    <seriesDescription>Corn;Production, Annual, Bushel;KS-D30;Corn for Grain Area Harvested, Yield, and Production</seriesDescription>
  </item>
  <item>
    <shortSymbol>UD0403GG.CS</shortSymbol>
    <seriesDescription>Corn;Production, Annual, Bushel;LA-D50;Corn for Grain Area Harvested, Yield, and Production</seriesDescription>
  </item>
</getCmdtyStatsId>

CSV

GET

GET https://ondemand.websol.barchart.com/getCmdtyStatsId.csv?apikey=YOUR_API_KEY&commodity=Corn&measurement=Production&area=United+States+of+America&source=USDA&maxRecords=50&page=1
Host: ondemand.websol.barchart.com

POST

POST https://ondemand.websol.barchart.com/getCmdtyStatsId.csv
Host: ondemand.websol.barchart.com
Content-Type: application/x-www-form-urlencoded
Content-Length: length

apikey=YOUR_API_KEY&commodity=Corn&measurement=Production&area=United+States+of+America&source=USDA&maxRecords=50&page=1

Response

shortSymbol,seriesDescription
"UD04006M.CS","Corn;Production,Annual,Bushel;Colorado;Corn for Grain Area Harvested, Yield, and Production"
"UD04007F.CS","Corn;Production,Annual,Bushel;Oklahoma;Corn for Grain Area Harvested, Yield, and Production"
"UD040085.CS","Corn;Production - Aug Forecast,Annual,Bushel;Kansas;Corn for Grain Area Harvested, Yield, and Production"
"UD04008Q.CS","Corn;Production - Aug Forecast,Annual,Bushel;Washington;Corn for Grain Area Harvested, Yield, and Production"
"UD04008X.CS","Corn;Production - Sep Forecast,Annual,Bushel;Delaware;Corn for Grain Area Harvested, Yield, and Production"
"UD04009P.CS","Corn;Production - Sep Forecast,Annual,Bushel;Wisconsin;Corn for Grain Area Harvested, Yield, and Production"
"UD0400AG.CS","Corn;Production - Oct Forecast,Annual,Bushel;Pennsylvania;Corn for Grain Area Harvested, Yield, and Production"
"UD0400AP.CS","Corn;Production - Nov Forecast,Annual,Bushel;Alabama;Corn for Grain Area Harvested, Yield, and Production"
"UD0400AT.CS","Corn;Production - Nov Forecast,Annual,Bushel;Delaware;Corn for Grain Area Harvested, Yield, and Production"
"UD0400BG.CS","Corn;Production - Nov Forecast,Annual,Bushel;South Dakota;Corn for Grain Area Harvested, Yield, and Production"
"UD04031W.CS","Corn;Inventory,Quarterly,Bushel;Indiana;Corn Stocks by Position"
"UD040320.CS","Corn;Inventory,Quarterly,Bushel;Louisiana;Corn Stocks by Position"
"UD04032A.CS","Corn;Inventory,Quarterly,Bushel;New Jersey;Corn Stocks by Position"
"UD04032E.CS","Corn;Inventory,Quarterly,Bushel;North Dakota;Corn Stocks by Position"
"UD04032K.CS","Corn;Inventory,Quarterly,Bushel;South Dakota;Corn Stocks by Position"
"UD04032O.CS","Corn;Inventory,Quarterly,Bushel;Virginia;Corn Stocks by Position"
"UD0403EK.CS","Corn;Production, Annual, Bushel;CO-D80;Corn for Grain Area Harvested, Yield, and Production"
"UD0403EL.CS","Corn;Production, Annual, Bushel;CO-D90;Corn for Grain Area Harvested, Yield, and Production"
"UD0403FZ.CS","Corn;Production, Annual, Bushel;KS-D30;Corn for Grain Area Harvested, Yield, and Production"
"UD0403GG.CS","Corn;Production, Annual, Bushel;LA-D50;Corn for Grain Area Harvested, Yield, and Production"

PHP

<?php

$ondemand = new SoapClient('https://ondemand.websol.barchart.com/service?wsdl');

$params = [
    'apikey' => 'YOUR_API_KEY',
    'commodity' => 'Corn',
    'measurement' => 'Production',
    'area' => 'United States of America',
    'source' => 'USDA',
    'maxRecords' => '50',
    'page' => '1',
];

$result = $ondemand->getCmdtyStatsId($params);
var_dump($result);

Classic ASP

Dim ondemand
Dim result

Set ondemand = Server.CreateObject("MSSOAP.SoapClient30")
ondemand.ClientProperty("ServerHTTPRequest") = True
ondemand.MSSoapInit("https://ondemand.websol.barchart.com/service?wsdl")

Set result = ondemand.getCmdtyStatsId("YOUR_API_KEY", "Corn", "Production", "United States of America", "USDA", "50", "1")

Perl

use SOAP::Lite;
use SOAP::WSDL;

my $ondemand = SOAP::Lite
    -> service('https://ondemand.websol.barchart.com/service?wsdl');

my $result = $ondemand->getCmdtyStatsId('YOUR_API_KEY', 'Corn', 'Production', 'United States of America', 'USDA', '50', '1');

print $result;

Python

from suds.client import Client
ondemand = Client('https://ondemand.websol.barchart.com/service?wsdl')

result = ondemand.service.getCmdtyStatsId('YOUR_API_KEY', 'Corn', 'Production', 'United States of America', 'USDA', '50', '1')

print(result)

Ruby

require 'savon'

ondemand = Savon.client(wsdl: 'https://ondemand.websol.barchart.com/service?wsdl')

response = ondemand.call(
    :getCmdtyStatsId,
    message: {
        apikey: 'YOUR_API_KEY',
        commodity: 'Corn',
        measurement: 'Production',
        area: 'United States of America',
        source: 'USDA',
        maxRecords: '50',
        page: '1',
    }
)

response.body