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.

Hello @chester.pineda ,

Thank you for your participation in the forum.

Is the reply below satisfactory in resolving your query?

If yes, please click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

-AHS

Upvotes
Accepted
79.2k 251 52 74

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