LSEG Data API Metadata

bferguson · May 13

I want to access the metadata information I can see on workspace for a set of cash prices (image attached).

I'm assuming it's something like:

import lseg.data as ld

import pandas as pd

APP_KEY = os.getenv("LSEG_APP_KEY")

ld.open_session(app_key=APP_KEY)

ric = "SYB-2YNOLAF-C1"fields = [ "TR.CommonName", "TR.AssetCategory", "TR.AssetType", "TR.Currency", "TR.PermID", "TR.UnderlyingRIC", "TR.Popularity", "TR.DisplayType"]

df = ld.get_data( universe=[ric], fields=fields )

However a lot of the metadata fields are not available (see output below)

Is there a better way of fetching this metadata/is it just not available?

Thank you

Jirapongse · May 13

@bferguson

Thank you for reaching out to us.

You need to contact the helpdesk team directly via MyAccount to verify those fields.

Otherwise, you can use the search API instead. For example:

df = ld.discovery.search(
    view = ld.discovery.Views.SEARCH_ALL,
    query = "SYB-2YNOLAF-C1",
    select = "DocumentTitle,RCSCurrencyLeaf,RCSUnderlyingProductLeaf,RCSAssetCategoryLeaf,MainIndexCommonName"
)
    
df

You can list all available fields in the SEARCH_ALL view by using the search metadata.

response = search.metadata.Definition(
    view = search.Views.SEARCH_ALL
).get_data()

response.data.df

The examples are available on GitHub.

You can also refer to the Building Search into your Application Workflow article.

bferguson · May 13

https://community.developers.refinitiv.com/discussion/comment/125700#Comment_125700

Thank you very much - super helpful.

Is there a way of searching for what metadata fields are available for a given RIC via the search or discovery hooks?

Was not able to find examples

Jirapongse · May 14

https://community.developers.refinitiv.com/discussion/comment/125701#Comment_125701

No. However, you can list all available fields in views by using the search metadata.

LSEG Data API Metadata

Answers

Categories

EXPLORE OUR SITES

LSEG Data API Metadata

Answers

Categories