For a deeper look into our DataScope Select REST API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
23 8 12 22

Request ISIN and get response for CUSIP, ISIN, TICKER and NAME

Dear All,

I need information for example where when i request ISIN and then i should get response for CUSIP, ISIN, TICKER and NAME. I would like to know does Refinitiv provide this information together, if yes then which REST API i need to use and if possible are there any example already present.

For example Linde plc’s CUSIP is G54950103 and its ISIN is IE000S9YS762.

Thank you.

With regards,

Rahul D

dss-rest-apidss#content
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.

Upvote
Accepted
76.5k 238 52 72

@rahul.deshmukh

The CUSIP also works with the TermsAndConditionsExtractionRequest but the Ticker doesn't work.

{
    "ExtractionRequest": {
        "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
        "ContentFieldNames": [
            "RIC",
            "CUSIP",
            "ISIN",
            "SEDOL",
            "Ticker",
            "Company Name",
            "Official Name",
            "CIN Code","Issuer PermID","Parent Issuer OrgID"
        ],
        "IdentifierList": {
            "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
                {
                    "Identifier": "G54950103",
                    "IdentifierType": "Cin"
                },
                {
                    "Identifier": "459200101",
                    "IdentifierType": "Cusip"
                },
                {
                    "Identifier":"LIN",
                    "IdentifierType":"Ticker"
                   
                }
            ]
        }
    }
}

The output is:

"Contents": [
        {
            "IdentifierType": "Cin",
            "Identifier": "G54950103",
            "RIC": "LIN.N",
            "CUSIP": null,
            "ISIN": "IE000S9YS762",
            "SEDOL": "BNZHB81",
            "Ticker": "LIN",
            "Company Name": "Linde",
            "Official Name": "LINDE PUBLIC LIMITED COMPANY",
            "CIN Code": null,
            "Issuer PermID": "5083858869",
            "Parent Issuer OrgID": null
        },
        {
            "IdentifierType": "Cusip",
            "Identifier": "459200101",
            "RIC": "IBM.N",
            "CUSIP": "459200101",
            "ISIN": "US4592001014",
            "SEDOL": "2005973",
            "Ticker": "IBM",
            "Company Name": "IBM",
            "Official Name": "INTERNATIONAL BUSINESS MACHINES CORPORATION",
            "CIN Code": null,
            "Issuer PermID": "4295904307",
            "Parent Issuer OrgID": null
        },
        {
            "IdentifierType": "Ticker",
            "Identifier": "LIN",
            "Error": "Not found"
        }
    ],

For a ticker, you can use the Equity search (Search/EquitySearch). The request looks like this:

{
    "SearchRequest": {
        "AssetStatus": "Active",
        "AssetCategoryCodes": null,
        "SubTypeCodes": null,
        "CurrencyCodes": null,
        "CompanyName": null,
        "Description": null,
        "DomicileCodes": null,
        "ExchangeCodes": ["NYS" ],
        "FairValueIndicator": null,
        "FileCodes": null,
        "GicsCodes": null,
        "OrgId": null,
        "Ticker": "LIN",
        "Identifier": null,
        "IdentifierType": null,
        "PreferredIdentifierType": "Isin"
    }
}

Set the Ticker and ExchangeCodes properties.

The response is:

"value": [
        {
            "Identifier": "IE000S9YS762",
            "IdentifierType": "Isin",
            "Source": "NYS",
            "Key": "VjF8MHgwMDEwMGIwMDE2MDk3YWVlfDB4MDAxMDBiMDAxYTU5ZWM3YnxOWVN8RVFRVXxFUVRZfE9EU0h8RXx8TElOLk58MDA3Nw",
            "Description": "LINDE ORD",
            "InstrumentType": "EquityQuote",
            "Status": "Valid",
            "DomicileCode": "GB",
            "CurrencyCodes": "USD",
            "SubTypeCode": "ODSH",
            "AssetStatus": "Active",
            "IssuerName": "LINDE",
            "IssuerOrgId": "121649824",
            "Exchange": "NYS",
            "FileCode": "77",
            "Tag": "77"
        }
    ]

For more information regarding the equity search, please refer to the REST API Tutorial 12: Search for an Equity tutorial.

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.

thanks @Jirapongse we can close the ticket

Upvotes
76.5k 238 52 72

@rahul.deshmukh

Thank you for reaching out to us.

I assume that you are using DSS REST API.

To extract those information, you can use an on-demand extraction with the TermsAndConditionsExtractionRequest report tempate and then send the request to the Extractions/ExtractWithNotes endpoint. The request message looks like this:

{
    "ExtractionRequest": {
        "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
        "ContentFieldNames": [
            "RIC",
            "CUSIP",
            "ISIN",
            "SEDOL",
            "Ticker",
            "Company Name",
            "Official Name",
            "CIN Code"
        ],
        "IdentifierList": {
            "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
                {
                    "Identifier": "G54950103",
                    "IdentifierType": "Cin"
                },
                {
                    "Identifier": "IE000S9YS762",
                    "IdentifierType": "Isin"
                }
            ]
        }
    }
}

For more information, please refer to the REST API Tutorial 7: On Demand T&C extraction tutorial.

I think G54950103 is an CIN code.

Unique nine-digit alpha-numeric code used to identify non-U.S. and non-Canadian securities. The first character is a letter representing the country of issue. The next five characters are numbers that represent the issuer, followed by two digits that represent the security. The final digit is the check digit.

The output looks like this:

    "Contents": [
        {
            "IdentifierType": "Cin",
            "Identifier": "G54950103",
            "RIC": "LIN.N",
            "CUSIP": null,
            "ISIN": "IE000S9YS762",
            "SEDOL": "BNZHB81",
            "Ticker": "LIN",
            "Company Name": "Linde",
            "Official Name": "LINDE PUBLIC LIMITED COMPANY",
            "CIN Code": null
        },
        {
            "IdentifierType": "Isin",
            "Identifier": "IE000S9YS762",
            "RIC": "LIN.N",
            "CUSIP": null,
            "ISIN": "IE000S9YS762",
            "SEDOL": "BNZHB81",
            "Ticker": "LIN",
            "Company Name": "Linde",
            "Official Name": "LINDE PUBLIC LIMITED COMPANY",
            "CIN Code": null
        }
    ],

However, the Notes description indicates that I don't have the permission to access 'CIN Code'.

 "Notes": [
        "...
Column 'CIN Code' suppressed for lack of 'CIN Code' permission.
Processing completed successfully at 09.08.2023 10:56:06, taking 0.101 Secs.
..."
    ]

If you don't have the permission to access 'CIN Code', please contact your Refinitiv account team or sales team to get the permission.

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.

Thanks @Jirapongse. Yes we are using DSS REST API. One question where do i get all the list of fields which i can request on-demand extraction with the TermsAndConditionsExtractionRequest ?

I try with this REST API request and i get below response :

LIN.N,,IE000S9YS762,,LIN,Linde,LINDE PUBLIC LIMITED COMPANY,

I see the CUSIP is null so does it mean i dont have permission and contact Refinitiv account team ?

Upvote
76.5k 238 52 72

@rahul.deshmukh

You can send the HTTP GET request to https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/GetValidContentFieldTypes(ReportTemplateType=DataScope.Select.Api.Extractions.ReportTemplates.ReportTemplateTypes'TermsAndConditions') to the list of available fields in this report tempate. It was mentioned in the REST API Tutorial 7: On Demand T&C extraction tutorial.

Otherwise, you can download the Refinitiv DataScope Select Data Content Guide which provides definitions of all of the data fields available in DataScope Select.

According to the returned repsonse and output from Eikon, there is no CUSIP for IE000S9YS762.

1691566249601.png

G54950103 is an CIN code. I think it is an extension of the CUSIP system according to this page. However, you need to contact the Datascope Select support team directly via MyRefinitiv to conifrm this.

Moreover, you need to check the Notes description regarding the permission.


1691566249601.png (24.7 KiB)
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.

Thanks @Jirapongse. One question can we also request REST api in other directions ?

The other directions:

1) Request Ticker und getting ISIN and CUSIP as response

2) Request CUSIP and getting Ticker and ISIN as response


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.