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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
43 8 10 12

how to get OrgId for given Ric in Python

We have list of ric_id and need to get corresponsing OrgId.

dss-rest-apidatascope-selectdssricssymbology
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
Accepted
78.6k 248 52 74

@vijay.singh

You can try the Equity Search (Search/EquitySearch).

The request is:

{
    "SearchRequest": {
        "AssetStatus": "Active",
        "AssetCategoryCodes": null,
        "SubTypeCodes": null,
        "CurrencyCodes": null,
        "CompanyName": null,
        "Description": null,
        "DomicileCodes": null,
        "ExchangeCodes": null,
        "FairValueIndicator": null,
        "FileCodes": null,
        "GicsCodes": null,
        "OrgId": null,
        "Ticker": null,
        "Identifier": "NNND.F",
        "IdentifierType": "Ric",
        "PreferredIdentifierType": "Pid"
    }
}

The output is:

        {
            "Identifier": "8590933189",
            "IdentifierType": "Pid",
            "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"
        }
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
21.9k 58 14 21

@vijay.singh, You cannot search for OrgID from a RIC. It is not a one-one relationship. You can try to use a PermID or search for the instrument using Entity Search.

{
  "SearchRequest": {
    "Name": "International Business Machines",
    "OfficialNameOnly": False,
    "DomicileCodes": None,
    "CountryOfIncorporationCodes": None,
    "TrBusinessClassificationCodes": None,
    "VerifiedOnly": False,
    "RegulatedOnly": False,
    "IssuersOnly": False,
    "ActiveOnly": False,
    "IncludeUnManagedOrUnVerified": False,
    "IdentifierType": "OrgId",
    "PreferredIdentifierType": "OrgId"
  }
}

response

{
  "@odata.type": "#DataScope.Select.Api.Search.EntitySearchResult",
  "Identifier": "18228",
  "IdentifierType": "OrgId",
  "Key": "VjF8MHgwMDAzZWYwNmMxNzIyYzc1fEVORU58MTgyMjh8T1JH",
  "Description": "INTERNATIONAL BUSINESS MACHINES CORPORATION",
  "InstrumentType": "Entity",
  "Type": "Business Organization",
  "Domicile": "United States",
  "CountryOfIncorporation": "United States",
  "ParentOrgId": "18228",
  "UltimateParentOrgId": "18228"
},
{
  "@odata.type": "#DataScope.Select.Api.Search.EntitySearchResult",
  "Identifier": "108286962",
  "IdentifierType": "OrgId",
  "Key": "VjF8MHgwMDAzZWYwNmNhNTkyOTUwfEVORU58MTA4Mjg2OTYyfE9SRw",
  "Description": "IBM CORP-SURFAID ANALYTICS BUS",
  "InstrumentType": "Entity",
  "Type": "Business Organization",
  "Domicile": "United States",
  "CountryOfIncorporation": "United States",
  "ParentOrgId": "108286962",
  "UltimateParentOrgId": "108286962"
},

PS: As already mentioned, Refinitiv helpdesk is the best place to ask content questions.

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
43 8 10 12

@Gurpreet thanks for the above information. Could you please provide the exact API call to be made to get the OrgId for given RIC.

Also please point me to the API doc of this API where I could find input and output response paramters and their values.

We currenlty have only the RIC codes of the company.

Expecting something like:

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": ric_code, "IdentifierType": "Ric"}
                # { "Identifier": "100421204", "IdentifierType": "OrgId" }
            ]
        },
        "Condition": {
            "DeltaDays": "5"
        }
    }
}

r2 = requests.post(requestUrl, json=requestBody, headers=requestHeaders)
status_code = r2.status_code


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.

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.