get RIC code for a given OrgId in python
We have list of OrgId of companies recieved from Organisation Hierarcy data API.
requestUrl='https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractRaw'
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.LegalEntityHierarchyExtractionRequest"
Now for all the companies recieved from Organisation Hierarcy data, we require corresponding RIC codes.
Could you point us to the API which can provide the relevant data.
Also if you can provide the code snippet(as mentioned below) for API call, it will be very helpful.
- requestUrl = 'https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractRaw'
-
- requestHeaders = {
- "Prefer": "respond-async",
- "Content-Type": "application/json",
- "Authorization": "token " + token
- }
-
- requestBody = {
- "ExtractionRequest": {
- "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.LegalEntityHierarchyExtractionRequest",
- "ContentFieldNames": [
- "ID",
- "Legal Entity OrgID",
- "Official Name",
- "Related OrgID",
- "Immediate Parent OrgID",
- "Ultimate Parent OrgID"
- ],
- "IdentifierList": {
- "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.EntityIdentifierList",
- "EntityIdentifiers": [
- {"Identifier": "100421204", "IdentifierType": "OrgId" }
- ]
- },
- "Condition": {
- "DeltaDays": "5"
- }
- }
- }
-
- r2 = requests.post(requestUrl, json=requestBody, headers=requestHeaders)
- status_code = r2.status_code
From my finding, I can use the returned "Legal Entity OrgID" fields with the Search/EquitySearch endpoint to get RIC codes.
{
"SearchRequest": {
"AssetStatus": "Active",
"AssetCategoryCodes": null,
"SubTypeCodes": null,
"CurrencyCodes": null,
"CompanyName": null,
"Description": null,
"DomicileCodes": null,
"ExchangeCodes":null,
"FairValueIndicator": null,
"FileCodes": null,
"GicsCodes": null,
"OrgId": "116916829,100421204,101908452,95420",
"Ticker": null,
"Identifier": null,
"IdentifierType": null,
"PreferredIdentifierType": null
}
}
The response looks like this:
"value": [
{
"Identifier": "NNND.F",
"IdentifierType": "Ric",
"Source": "FRA",
"Key": "VjF8MHgwMDAzZGQwMDEzNjY5NjNkfDB4MDAwM2RjMDAzZGM1ODBhN3xGUkF8RVFRVXxFUVRZfE9EU0h8RXx8Tk5ORC5GfDAxODY",
"Description": "TENCENT ORD",
"InstrumentType": "EquityQuote",
"Status": "Valid",
"DomicileCode": "CN",
"CurrencyCodes": "EUR",
"SubTypeCode": "ODSH",
"AssetStatus": "Active",
"IssuerName": "TENCENT HOLDINGS",
"IssuerOrgId": "100421204",
"Exchange": "FRA",
"FileCode": "186"
},
{
"Identifier": "UBSFF.PK",
"IdentifierType": "Ric",
"Source": "PNK",
"Key": "VjF8MHgwMDAzZGQwMDE0ZDE3ZjY0fDB4MDAwM2RjMDA0MjAxMGI5N3xQTkt8RVFRVXxFUVRZfE9EU0h8RXx8VUJTRkYuUEt8MTA2MA",
"Description": "UBISOFT ENTERTAINMENT ORD",
"InstrumentType": "EquityQuote",
"Status": "Valid",
"DomicileCode": "FR",
"CurrencyCodes": "USD",
"SubTypeCode": "ODSH",
"AssetStatus": "Active",
"IssuerName": "UBISOFT ENT",
"IssuerOrgId": "95420",
"Exchange": "PNK",
"FileCode": "1060"
},
However, please directly contact the Refinitiv DataScope Select support team via MyRefinitiv to verify it.