REST API error message for ISIN DU00000COCHA reflecting as ISIN DU00000COCH3

Hi,
Wanted to check on the below issue where using DSS REST API for ISIN DU00000COCHA, getting the error message reflecting as ISIN DU00000COCH3 not found under Terms and Conditions Report Template.
I am using DSS Rest API extraction and Identifier List is having ISIN as DU00000COCHA which is a Dummy ISIN, however in the output error message I should be getting the same ISIN, Instead DSS Rest API is returning error message as ISIN DU00000COCH3 not found. I have tried using different permutation and combinations replacing ISIN values with B, C, D and also replacing it by 1,2, 4, 5, 6 all error message is returning the value of ISIN DU00000COCH3 not found.
This seems quite weird when we send ISIN DU00000COCHA to an enpoint of Rest API (given below) and the response is that DU00000COCH3 is not found.
Is it a normal behavior, is there any business rule behind?
Here is the Rest API code and error message:
body:
{
"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
"ContentFieldNames": [
"ISIN"
],
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{
"Identifier": "DU00000COCHA",
"IdentifierType": "Isin"
}
]
}
}
}
… and response (HTTP 200 OK):
{
"@odata.context": https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#DataScope.Select.Api.Extractions.ExtractionRequests.ExtractionResult,
"Contents": [
{
"IdentifierType": "Isin",
"Identifier": "DU00000COCH3",
"Error": "Not found"
}
],
"Notes": [
"All identifiers were invalid. No extraction performed."
]
}
Best Answer
-
I found that if I set the AllowHistoricalInstruments to True.
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{
"Identifier": "DU00000COCHA",
"IdentifierType": "Isin",
"UserDefinedIdentifier": "DU00000COCHA"
}
],
"ValidationOptions": {
"AllowHistoricalInstruments": true
}
}The response will contain "DU00000COCHA".
"Contents": [
{
"IdentifierType": "Isin",
"Identifier": "DU00000COCHA",
"Error": "Not found",
"UserDefinedIdentifier": "DU00000COCHA"
}
],However, you need to contact the DSS support team directly to verify this behavior.
0
Answers
-
Thank you for reaching out to us.
I checked and found that the final number of the ISIN code is called a “single check-digit”. For more information, please refer to this website.
I also checked this ISIN (DU00000COCHA) on this website and it showed the following.
Therefore, that last digit of that ISIN is incorrect.
0 -
Hello @Jirapongse,
Thanks a lot for the above response, however when we enter any ISIN on the API code, it should respond back with the same queried ISIN or will the DSS API rectify as stated above and provide the correct ISIN, even though we enter an Incorrect ISIN. Is this how the response functions for all incorrect ISIN's.
Also if this is the normal behavior, or is there any business rule behind this?
Regards,
Raghunath.K.P.
0 -
@raghunath.puttarangaiah0
According to the response, the current behavior is DSS will correct the ISIN codes.
To confirm if it is the normal behavior, please contact the DSS support team directly via MyRefinitiv.
0 -
If you need to get the incorrect ISIN in the reponse, you can use the UserDefinedIdentifier field.
{
"Identifier": "DU00000COCHA",
"IdentifierType": "Isin",
"UserDefinedIdentifier":"DU00000COCHA"
}The reponse will look like this:
{
"IdentifierType": "Isin",
"Identifier": "DU00000COCH3",
"Error": "Not found",
"UserDefinedIdentifier": "DU00000COCHA"
}0 -
@Jirapongse,
Thanks for the above information, but does DSS API always correct and display the ISIN if its incorrect and does this apply for all ISIN.
0 -
@Jirapongse,Hello
Thanks a lot for the above work around, guess this answers the question. Appreciate your help and quick response on the query.
Have a nice day ahead and Happy weekend!!
Regards,
Raghunath.K.P.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 685 Datastream
- 1.4K DSS
- 616 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 252 ETA
- 557 WebSocket API
- 38 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 654 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 193 TREP Infrastructure
- 229 TRKD
- 917 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛