I am using the Refinitiv Data Platform API on a Mac.
@oliver.rogers19,
In code, the search would look like this:
rdp.search( view = rdp.SearchViews.Organisations, filter = "RCSTRBC2012Name eq 'Utilities'", select = "PrimaryRIC, CommonName", top = 10)
Resulting in this:
Hi @oliver.rogers19,
You can use RDP Search and use TRBC name to filter out companies. For example, to get Utilities, you can use:
https://api.refinitiv.com/discovery/searchlight/v1/{ "View": "Organisations", "Filter": "RCSTRBC2012Name eq 'Utilities'", "Select": "PrimaryRIC, CommonName", "Top": 10}
Response:
{ "Total": 73233, "Hits": [{ "PrimaryRIC": "NEE", "CommonName": "Nextera Energy Inc" }, { "PrimaryRIC": "ENEI.MI", "CommonName": "Enel SpA" },...
For more information, see help for SearchLight in the API playground.
Thanks for the reply @Gurpreet. How do I then embed the body of the search inside an RDP query? I have tried the following which returned None.
rdp.search({ "View": "Organisations", "Filter": "RCSTRBC2012Name eq 'Utilities'", "Select": "PrimaryRIC, CommonName", "Top": 10})
@Gurpreet a quick follow question is where can I find the documentation for the TRBC filter? From your example, 'Name' seems to filter at the TRBC Economic Sector level. I would like to also be able to look up how to filter at the Industry or Activity level
I would recommend that you start with this article on search. It explains search in great detail. The filter and metatdata is also described in the API playground under the reference tab.