For a deeper look into our DataScope Select REST API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
vijay.singh avatar image
43 ●5 ●7 ●11

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.

  
  
                
    
                 
  1. requestUrl = 'https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractRaw'
    2. 
                 
  2.  
    3. 
                 
  3. requestHeaders = {
    
    
    4. 
                 
  4.     "Prefer": "respond-async",
    5. 
                 
  5.     "Content-Type": "application/json",
    6. 
                 
  6.     "Authorization": "token " + token
    7. 
                 
  7. }
    8. 
                 
  8.  
    9. 
                 
  9. requestBody = {
    
    
    10. 
                 
  10.     "ExtractionRequest": {
    
    
    11. 
                 
  11.         "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.LegalEntityHierarchyExtractionRequest",
    12. 
                 
  12.         "ContentFieldNames": [
    13. 
                 
  13.             "ID",
    14. 
                 
  14.             "Legal Entity OrgID",
    15. 
                 
  15.             "Official Name",
    16. 
                 
  16.             "Related OrgID",
    17. 
                 
  17.             "Immediate Parent OrgID",
    18. 
                 
  18.             "Ultimate Parent OrgID"
    19. 
                 
  19.         ],
    20. 
                 
  20.         "IdentifierList": {
    
    
    21. 
                 
  21.             "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.EntityIdentifierList",
    22. 
                 
  22.             "EntityIdentifiers": [
    23. 
                 
  23.                 {"Identifier": "100421204", "IdentifierType": "OrgId" }
    24. 
                 
  24.             ]
    25. 
                 
  25.         },
    26. 
                 
  26.         "Condition": {
    
    
    27. 
                 
  27.             "DeltaDays": "5"
    28. 
                 
  28.         }
    29. 
                 
  29.     }
    30. 
                 
  30. }
    31. 
                 
  31.  
    32. 
                 
  32. r2 = requests.post(requestUrl, json=requestBody, headers=requestHeaders)
    33. 
                 
  33. status_code = r2.status_code
    34.
dss-rest-apidssdatascope-selectsymbologyric
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.

1 Answer

Upvotes
Accepted
Jirapongse avatar image
56.1k ●145 ●45 ●65

@vijay.singh

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.


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.