how to get OrgId for given Ric in Python
We have list of ric_id and need to get corresponsing OrgId.
Best Answer
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"
}
@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.
@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