How to convert DUNS number to PermID using RDP?

chester.pineda

How to convert DUNS number to PermID or to any other Refinitiv Identifiers (RIC, ISIN, etc.) using RDP?

Jirapongse

@chester.pineda

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.

RFielder

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.

@Jirapongse, @chester.pineda