question

Upvotes
Accepted
3 0 1 2

How to convert DUNS number to PermID using RDP?

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

rdp-apirefinitiv-data-platformrdp
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
80.1k 258 52 75

@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.

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
261 2 0 2

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

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.