1. Supply chain field names and missing rows
In my pipeline I am querying each company using `TR.SCRelationship`, `TR.SCRelationship.ScorgIDOut`, `TR.SCRelationshipUpdateDate`, `TR.SCRelationshipConfidenceScore`, and `TR.SCRelationshipFreshnessScore`. The problem is that for many large, well-known listed companies I consistently get "no matching rows" when I filter the returned relationship type column for `SUPPLIER` or `CUSTOMER`. These are companies that clearly appear in Eikon's supply chain interface with documented relationships, so I am not sure if I am using the wrong field names for programmatic access, if there is a coverage difference between the desktop and the API, or if this is related to my subscription level. Could you confirm whether these are the correct and current field names for `ek.get_data()` calls, and whether there is an alternative approach that would return more complete results?
import eikon as ek
ek.set_app_key('YOUR_APP_KEY')
fields = [
'TR.SCRelationship',
'TR.SCRelationship.ScorgIDOut',
'TR.SCRelationship.instrument',
'TR.SCRelationshipUpdateDate',
'TR.SCRelationshipConfidenceScore',
'TR.SCRelationshipFreshnessScore',
]
for ric in ['AAPL.O', 'MSFT.O', 'VOW3.DE', 'MC.PA', '000030.SZ']:
data, err = ek.get_data([ric], fields)
print(f'\\n--- {ric} ---')
print(data)
print('Error:', err)
The main thing I'm seeing is that for many large listed companies, the ones where I can clearly see supplier and customer relationships in the Eikon desktop, the API either returns nothing or returns rows with relationship types that don't match SUPPLIER or CUSTOMER at all.
2. Organisation IDs that do not resolve to a RIC
When I pass the counterparty org IDs from `TR.SCRelationship.ScorgIDOut` back to `ek.get_data()` requesting `TR.RIC`, a significant number return nothing. I currently drop these from my dataset, but I suspect some of them may still have partial data available. Is it possible to retrieve basic fields like `TR.CommonName`, `TR.Revenue`, `TR.TRBCBusinessSector`, or `TR.HeadquartersCountry` using an organisation ID directly rather than a RIC? And what is the typical reason an org ID fails to resolve. Is it because the company is private, delisted, or simply not covered?
3. Historical relationship data
I wanted to ask whether the supply chain API supports querying relationships as of a specific historical date, or whether it only ever returns the current snapshot. My work looks at ESG and emissions data across multiple fiscal years, so ideally the network structure would correspond to the same time period. If only the current snapshot is available I would like to flag that as a limitation, but I want to confirm before doing so.
4. SCREEN() syntax and TRBC taxonomy level
I am using `SCREEN()` inside `ek.get_data()` to build my company universe programmatically, with a syntax along the lines of `SCREEN(TR.TRBCBusinessSector=="Chemicals", TR.CompanyMarketCap(Scale=6)>=500)`. I wanted to confirm whether this is the recommended approach for programmatic universe selection via the API, and also whether `TR.TRBCBusinessSector` is the correct field name to use at that level of the TRBC taxonomy. I want to make sure I am not accidentally mixing it up with `TR.TRBCIndustryGroup` or another level.
5. TR.EnvironmentalDataIndependentVerification returning empty
I am requesting `TR.EnvironmentalDataIndependentVerification` for FY0, FY-1, and FY-2 across a dataset of several thousand companies, and it is consistently returning empty across my entire sample. I want to check whether this field is actually available via `ek.get_data()` or only through the desktop interface. If it is not accessible via API, is there an equivalent field I could use to indicate whether a company's environmental data has been independently verified or audited?
And one more thing I wanted to raise. I'm running this for my Master's thesis and need supply chain data for around 12,500 companies, but I keep hitting a hard 429 limit after roughly 1,500–2,000 calls per day. Is there a daily limit specific to these supply chain fields? And is it possible to pass multiple instruments in a single call for TR.SCRelationship? If there's a process to request a temporary quota increase for academic use I'd really appreciate being pointed in the right direction.
