question

Upvotes
Accepted
3 1 2 7

Retrieve mapping of inactive SEDOLS to Organization Perm ID

Hi, I am looking to get a mapping of inactive SEDOLs to the organization Perm ID. I can see the /discovery/symbology/v1/lookup API is able to map identifiers to Organization PermID but for inactive SEDOLs, it requires one to pass in an effectivedate parameter?

Is there any way to retrieve a list of all inactive SEDOLS in one request? See below a small example of inactive sedols. Thanks.

{
"from": [

{
"identifierTypes": [

"RIC"

],

"values": [

"BT6HT99",

"6929325",

"B70DWB2",

"B1LJTM7"

]

}

],

"to": [

{
"objectTypes": [

"organization"

],

"identifierTypes": [

"PermID"

]

}

],

"reference": [

"name",

"status",

"classification"

],

"type": "auto"

}
sedol
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.

1 Answer

· Write an Answer
Upvotes
Accepted
261 2 0 2

Hello @danny.lo


A showHistory feature was added last week to discovery/symbology/v1 API queries that will enable navigation between 2 entities through time. For example you can navigate from SEDOL to Organisation PermID and see which organisations the SEDOL was related to over time, see example below. Would this help with your use case?


{

"from": [

{

"identifierTypes": [

"SEDOL"

],

"values": [

"B70DWB2"

]

}

],

"to": [

{

"objectTypes": [

"organization"

],

"identifierTypes": [

"PermID"

]

}

],

"reference": [

"name",

"status",

"classification"

],

"showHistory": true,

"type": "auto"

}


Note - in most cases the historical relationships between entities are only available back to early 2000s in discover/symbology/v1 API

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.