LSEG Data API Metadata

bferguson

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

@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.