question

Upvotes
Accepted
l.marsden avatar image
5 ●0 ●1 ●2

Data not appearing when pull from RDP but can see data available on the interface?

Hi there,

I am using RDP to pull some information regarding Indonesian companies. For the odd PermID, no information is appearing when I use "get_data", even though I can clearly see the information on the overview page for the company. Why might that be the case? This occurs whether the company is in a long list of IDs, or pulled indivudally. See my example below with a screenshot showing the information is there - at the moment RDP doesn't even return the company name.

flds = ["TR.CompanyName","TR.IsPublic", "TR.FreeFloatPct", "TR.InstrPctHldStrategic", "TR.HeadquartersCountry", "TR.HeadquartersRegion", "TR.NAICSSector", "TR.NAICSSubsector", "TR.NAICSIndustryGroup", "TR.NAICSInternationalIndustry"]

rd.get_data('5000715011', flds) # gives me no results for this company


1710517289815.png

rdp-api#contentrdp
1710517289815.png (210.1 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jonathan.legrand avatar image   jonathan.legrand

Hello @l.marsden

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If so, can you please click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks, AHS

raksina.samasiri avatar image   raksina.samasiri

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,
AHS

2 Answers

· Write an Answer
Upvotes
Accepted
aramyan.h avatar image
5k ●16 ●2 ●7

Hi @l.marsden ,


The issue is the fields you are asking are empty for that instrument. Consider using the below:

flds = ["TR.CommonName,TR.OrganizationID,TR.CommonHQAddressLine1,TR.CommonHQAddressLine2,TR.CommonHQAddressLine3,TR.HeadquartersCity,TR.HQStateProvince,TR.HQAddressPostalCode,TR.HeadquartersCountry,TR.RegistrationCountry,TR.F.TotRevBizActiv,TR.CompanyHasIslamicFinance,TR.LegalEntityIdentifier,TR.CompanyLegalType,TR.CompanyLongitude,TR.CompanyLatitude,TR.LegalEntityIdentifier,TR.IROfficerName,TR.IREmailAddress"]
 
rd.get_data('5000715011', flds)


screenshot-2024-03-15-at-180618.png


In general, you can check the fields used in Workspace by clicking in the (i) icon next to the tole widget:

screenshot-2024-03-15-at-180739.png

Best regads,

Haykaz


screenshot-2024-03-15-at-180618.png (42.8 KiB)
screenshot-2024-03-15-at-180739.png (6.4 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
l.marsden avatar image
5 ●0 ●1 ●2

Hi Haykaz, thanks for this response. These fields now appear if i use TR.CommonName, which then brings up the other fields that I had in my original request (e.g., NAICS sector). This suggests that some of these fields do exist, but don't appear if I use the wrong first field (e.g., TR.CompanyName).

Why is this?

This has implications for some other work that I'm doing, as the number of results I get changes if I add a field that not all companies have. @aramyan.h

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

aramyan.h avatar image aramyan.h
Hi @l.marsden ,


I am not sure if there is any dependency with the first field. If you provide a specific example I can have a look.

As it comes to why one field is available for one company and not for another, I would advice reaching out content specialists by posting a content question via my.refinitiv.com or using Help&Support in Workspace/Eikon.


Best regards,

Haykaz

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.