Requesting more than one SEDOL at a time

When I try this:
{
"Request": {
"Identifier": "BD8DS52",
"IdentifierType": "Sedol",
"Range": {
"Start": "2017-09-11T00:00:00.000Z",
"End": "2017-09-11T23:59:59.999Z"
}
},
"Request": {
"Identifier": "BDH44M5",
"IdentifierType": "Sedol",
"Range": {
"Start": "2017-09-11T00:00:00.000Z",
"End": "2017-09-11T23:59:59.999Z"
}
}
}
I get an error "The request JSON is malformed. Duplicate keys
found". Is it possible to request Identifier for multiple Sedols/Isins in one POST request? The reference document is a little bit conflicting about it.
Best Answer
-
I understand that you are using HistoricalSearch. The message, you are using, seems not correct, so the error was received. Anyway, the HistoricalSearch supports only one identifier at a time.
In this case, you can also use the HistoricalReferenceExtraction to retrieve reference data for multiple identifiers at a time.
POST https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/Extract
{
"ExtractionRequest": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.HistoricalReferenceExtractionRequest",
"ContentFieldNames": [
"RIC","Exchange Code"
],
"IdentifierList": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{
"Identifier": "BD8DS52",
"IdentifierType": "Sedol"
},
{
"Identifier": "BDH44M5",
"IdentifierType": "Sedol"
}
],
"ValidationOptions": {"AllowHistoricalInstruments": true},
"UseUserPreferencesForValidationOptions": false
},
"Condition": {
"StartDate": "2017-09-11T00:00:00.000Z",
"EndDate": "2017-09-11T23:59:59.999Z"
}
}
}Output:
{
"IdentifierType": "Sedol",
"Identifier": "BD8DS52",
"RIC": "SANT1.VI",
"Exchange Code": "VIE"
},
{
"IdentifierType": "Sedol",
"Identifier": "BDH44M5",
"RIC": "MSBT.VI",
"Exchange Code": "VIE"
}0
Answers
-
Thank you, that's very helpful. I wish this was a part of REST API Use Cases Reference document.
While playing with it, I've been getting a lot of intermittent errors "No JSON object could be decoded". In my recent example, I ran the same 200-sedol message 5 times in a row Got the error 4 times, and successful completion once. I'm keen on getting this addressed, so I am attaching the message in question.in.txt
0 -
It seems to be a timeout issue. The message either completes in under 30sec or fails with the error above. Any way to increase timeout from 30sec?
0 -
This should expected behavior for asynchronous request, where the "Prefer: respond-async" specified in header of request.
If extraction is complete within an amount of time (30 seconds by default), the server will return 200 response with data. Otherwise, the server responds with a 202 (accepted), indicating that the request was accepted. The 202 response includes a monitor URL in the "Location" header. Application needs to send GET http request against the monitor URL to retreive data. However, if the response still is not available, another 202 response will be sent.
For more information, please see the Async Key Mechanisms and "Request accepted, but with a timeout" in the REST API Tutorial 10: On Demand Histo Reference extraction tutorial.
Regarding your question, if you don't want to handle the asynchronous mechanism, you may:
- change the request to synchronous by removing the "Prefer: respond-sync" header. Synchronous requests will keep the connection open until the requested work has been completed or the request fails. This method is not recommend for extraction of huge amount of data.
- increase timeout by adding "wait" in Prefer header. For example, "Prefer: respond-async, wait=120".
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
- 687 Datastream
- 1.4K DSS
- 622 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
- 254 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
- 276 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
- 676 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
- 918 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
- 48 中文论坛