Fields missing information in API pull even though they have values in Workspace

I am using get_data to pull the following fields about about 5000 PermIDs. While it runs relatively smoothly (takes about 10 mins), some of the fields (e.g., country of headquarters) have gaps even though I can see they have values in Workspace. Is this because I'm throttling the API or some other error?
info_by_permid_finance = rd.get_data( universe=permids_finance_list, fields=flds_finance_info, parameters={"Scale": "6"},)

TR.OrganizationID
TR.CommonName
TR.BusinessSummary
TR.LegalEntityIdentifier
TR.ISIN
TR.TickerSymbol
TR.CompanyLegalType
TR.RegistrationCountry
TR.HeadquartersCountry
TR.HeadquartersRegion
TR.UltimateParent
TR.UltimateParentId
TR.IsPublic
TR.InstrPctHldStrategic
TR.FreeFloatPct
TR.TRBCActivity
TR.GICSSubIndustry
TR.NAICSNationalIndustry
TR.TRBCActivityAll
TR.NAICSNationalIndustryAll

Dependencies
python 3.11 (to use rdp)

import refinitiv.data as rd

from refinitiv.data.errors import RDError

from refinitiv.data.content import search

Answers

  • Hi @l.marsden ,

    Including field TR.NAICSNationalIndustryAll in get_data request along with these fields you're using will return the dataframe like below, as this field include multiply classifications of the company. For the request like this, field TR.NAICSNationalIndustry that you're currently using is more proper than the one with -All suffix

    image.png

    I'd suggest you remove the field and the output dataframe will be like below.

    image.png

    You can use another get_data() request to request TR.NAICSNationalIndustryAll like this

    image.png