How to convert DUNS number to PermID or to any other Refinitiv Identifiers (RIC, ISIN, etc.) using RDP?
How to convert DUNS number to PermID or to any other Refinitiv Identifiers (RIC, ISIN, etc.) using RDP?
You can use the https://api.refinitiv.com/discovery/symbology/v1/lookup to convert DUNS numbers to PermIDs or others.
For example:
{ "from": [ { "identifierTypes": [ "DunsNumber" ], "values": [ "196337864" ] } ], "to": [ { "identifierTypes": [ "PermId" ] } ], "type": "auto" }
The output is:
{ "data": [ { "input": [ { "value": "196337864", "identifierType": "DunsNumber" } ], "output": [ { "value": "4297297477", "identifierType": "PermId", "objectType": "Organization" } ] }
You can use the following request to get the main equity RIC.
{ "from": [ { "identifierTypes": [ "DunsNumber" ], "values": [ "196337864" ] } ], "to": [ { "identifierTypes": [ "RIC" ] } ], "path": [ { "relationshipTypes": [ "InverseIsPrimarySecurityOf" ], "objectTypes": [ { "from": "Organization", "to": "AnyInstrument" } ] }, { "relationshipTypes": [ "InverseIsValuationQuoteOf" ], "objectTypes": [ { "from": "AnyInstrument", "to": "AnyQuote" } ] } ], "type": "strict" }
The output is:
{ "data": [ { "input": [ { "value": "196337864", "identifierType": "DunsNumber" } ], "output": [ { "value": "FB.O", "identifierType": "RIC" } ] } ],
For more information, please refer to the RDP API Document.
IMPORTANT UPDATE - unfortunately the use of DUNS numbers in discovery/symbology/v1 API is no longer permitted due to usage restrictions. This includes queries where DUNS is the input value so the above queries will not be supported. An alternative could be to navigate from another organisation identifier such as LEI.