question

Upvotes
Accepted
3 0 0 1

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 5.0 MiB each and 10.0 MiB total.

Upvotes
Accepted
38.1k 71 35 53

@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 5.0 MiB each and 10.0 MiB total.

Upvotes
141 2 0 1

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 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea