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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
43 2 1 7

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 5.0 MiB each and 10.0 MiB total.

Upvotes
Accepted
38.1k 71 35 53

@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 5.0 MiB each and 10.0 MiB total.

Upvotes
13k 32 12 18

@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 5.0 MiB each and 10.0 MiB total.

Upvotes
43 2 1 7

@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 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea