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
I'd suggest you remove the field and the output dataframe will be like below.
You can use another get_data() request to request TR.NAICSNationalIndustryAll like this
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 37 Alpha
- 167 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 707 Datastream
- 1.5K DSS
- 633 Eikon COM
- 5.3K Eikon Data APIs
- 15 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 7 Trading API
- 3K Elektron
- 1.5K EMA
- 259 ETA
- 571 WebSocket API
- 40 FX Venues
- 16 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 25 Messenger Bot
- 4 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 284 Open PermID
- 47 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 24 RDMS
- 2.2K Refinitiv Data Platform
- 4 CFS Bulk File/TM3
- 896 Refinitiv Data Platform Libraries
- 5 LSEG Due Diligence
- 1 LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 125 Open DACS
- 1.1K RFA
- 108 UPA
- 196 TREP Infrastructure
- 232 TRKD
- 921 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 105 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛