get RIC code for a given OrgId in python

Question

question

vijay.singh

43 ●8 ●10 ●12

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

dss-rest-api datascope-select dss symbology ric

May 19, 2021 at 11:42 AM

10 |1500

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

wasin.w Jul 06, 2021 at 06:42 AM

Hello @vijay.singh

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

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

Thanks,

AHS

Answer 1 · 2021-05-20T05:03:44Z

Jirapongse

78.9k ●250 ●52 ●74

@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.

May 20, 2021 at 05:03 AM

10 |1500

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

Q&A Forum

question

get RIC code for a given OrgId in python

1 Answer

Write an Answer

question

get RIC code for a given OrgId in python

1 Answer

Write an Answer

Related Questions