We use API search function to retrieve data, but it returns unknown property 'ProviderSymbol'. Th...

xuke

...e field in Eikon Client is "PROV_SYMB"

df = rd.discovery.search(

view=rd.discovery.Views.COMMODITY_QUOTES,

top=10,

filter="(ProviderSymbol eq 'm2401')",

select="ProviderSymbol,RIC"

)

{

"return_code": 500,

"return_info": "Error code 400 | Invalid filter: unknown property 'ProviderSymbol'",

"result": {}

}

Find more posts tagged with

api

#content

#product

Accepted answers

Jirapongse

@xuke

Thank you for reaching out to us.

This ProviderSymbol is not a valid field in the COMMODITY_QUOTES.

You can use the following code to the all available fields in the COMMODITY_QUOTES.

response = search.metadata.Definition(
    view = search.Views.COMMODITY_QUOTES  # Required parameter
).get_data()

response.data.df

I tried m2401 in Eikon and it doesn't show anything.

All comments

Jirapongse

@xuke

Thank you for reaching out to us.

This ProviderSymbol is not a valid field in the COMMODITY_QUOTES.

You can use the following code to the all available fields in the COMMODITY_QUOTES.

response = search.metadata.Definition(
    view = search.Views.COMMODITY_QUOTES  # Required parameter
).get_data()

response.data.df

I tried m2401 in Eikon and it doesn't show anything.

xuke

@Jirapongse thanks. I asked another question is related to this question. Could you have a look at it? (https://community.developers.refinitiv.com/questions/108440/how-to-use-eikon-api-to-get-commodities-ric-code-b.html) I got a reply to use search function to get the RIC code.

Jirapongse

@xuke

I assume that m2401 is from Ticker (M) and Expirate Date (Jan 24).

If my assumption is correct, the seach query should be:

{
  "View": "CommodityQuotes",
  "Filter": "TickerSymbol eq 'M' and ContractMonthYear eq 'Jan 24' and AssetStateName eq 'Active' and RCSAssetCategoryLeaf xeq 'Commodity Future' and ExpiryDateString ne null",
  "Select": "DocumentTitle,RIC,AssetType,ContractMonthYear,Periodicity,RCSAssetCategoryLeaf,RCSAssetClass,RCSCurrencyLeaf,ExchangeCode,ExpiryDateString"
}

The output is:

{
  "Total": 1,
  "Hits": [
    {
      "DocumentTitle": "DCE Soybean Meal Commodity Future Jan 2024, Commodity Future, Dalian Commodity Exchange",
      "RIC": "DSMF4",
      "AssetType": [
        "DERIVATIVE"
      ],
      "ContractMonthYear": "Jan 24",
      "Periodicity": "Irregular",
      "RCSAssetCategoryLeaf": "Commodity Future",
      "RCSAssetClass": "FUT",
      "RCSCurrencyLeaf": "Chinese Yuan",
      "ExchangeCode": "DLC",
      "ExpiryDateString": "15 Jan 2024"
    }
  ]
}

joneliu

"TickerSymbol eq 'M' and ContractMonthYear eq 'Jan 24' and AssetStateName eq 'Active' and RCSAssetCategoryLeaf xeq 'Commodity Future' and ExpiryDateString ne null",

Hi , I want to replace 'TickerSymbol' with 'TradingSymbol’, but It's not valid.

What is the solution to solve it

joneliu

@Jirapongse Can you help me solve this problem

Jirapongse

@joneliu

I couldn't find this "TradingSymbol" field in the CommodityQuotes.

EXPLORE OUR SITES