DSS Rest API request/response

Hi,
Please provide an example of the DSS Rest API request/response results for the attached list of instruments. I can access the data via teh GUI but struggling to get it via the API.
Thanks
Best Answer
-
Thanks to your report template I now see you want to retrieve an intraday price snapshot.
Getting the bid and ask prices for your list of RICs in the screenshot
This request body delivers the bid and ask price for all RICs in capture1.jpg:
{
"ExtractionRequest": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.IntradayPricingExtractionRequest",
"ContentFieldNames": [
"RIC", "Ask Price", "Bid Price", "Currency Code", "Exchange Code",
"Instrument ID", "Instrument ID Type", "Trade Date", "Volume"
],
"IdentifierList": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{ "Identifier": "XS1452710962=BARL", "IdentifierType": "Ric" },
{ "Identifier": "XS1452800797=BARL", "IdentifierType": "Ric" },
{ "Identifier": "XS1452801175=BARL", "IdentifierType": "Ric" },
{ "Identifier": "XS1471949195=BARL", "IdentifierType": "Ric" },
{ "Identifier": "XS1471949864=BARL", "IdentifierType": "Ric" },
{ "Identifier": "XS1471975430=BARL", "IdentifierType": "Ric" },
{ "Identifier": "XS1471993763=BARL", "IdentifierType": "Ric" },
{ "Identifier": "XS1511977875=BARL", "IdentifierType": "Ric" },
{ "Identifier": "XS1511977958=BARL", "IdentifierType": "Ric" }
],
"ValidationOptions": { "AllowOpenAccessInstruments": true }
},
"Condition": { "ScalableCurrency": true }
}
}Note that I specified a validation option:
"ValidationOptions": { "AllowOpenAccessInstruments": true }
If you set that to false (or do not set it) then you get a "Not Found" error for all these instruments.
I am not a data specialist, I cannot explain why these RICs qualify as Open Access instruments. For data content query like this one, the best and speediest way to receive an answer is to open a content-related enquiry via My Account or to call the Thomson Reuters Help Desk directly.
ISIN XS1068108932
I tried changing the instrument list in the query above, to test the RICs you listed:
{ "Identifier": "XS1068108932=BARL", "IdentifierType": "Ric" },
{ "Identifier": "XS1068108932", "IdentifierType": "Ric" },
{ "Identifier": "GB106810893=BARL", "IdentifierType": "Ric" },
{ "Identifier": "GB106810893=", "IdentifierType": "Ric" },
{ "Identifier": "XS1068108932", "IdentifierType": "Isin" }Results:
- RIC XS1068108932=BARL: prices are delivered.
- RIC XS1068108932: not found
- RICs GB106810893=BARL and GB106810893=: null prices.
- ISIN XS1068108932: null prices.
I did a search for RICs corresponding to ISIN XS1068108932, it delivers the 2 RICs you mention, the 3rd result is the ISIN itself, not a RIC:
That is why RIC XS1068108932 is not found.
I cannot tell you why the search for RIC XS1068108932=BARL returned the message "No securities found.". For that, and to understand why some of these instruments have null prices, please open a content-related enquiry via My Account or call the Thomson Reuters Help Desk directly.
Note: converting ISINs to RICs can be tricky. I suggest you read this article, it should help you understand what API calls and searches you can use, depending on your use case.
Side note
Please try to start a new thread for each new query (without duplicating queries), that will help everyone find related things.
0
Answers
-
@preshan.govinder, your screenshot only shows a list of RICs, with Bid and Ask price. What are you trying to achieve ? Is this to get a snapshot of the latest of these values, or something else ? Please describe your use case so we can help you out. Alternatively, tell us how you got this through the GUI.
0 -
Hi Christiaan,
I'm trying to replicate the results in the screenshot via the REST API.
Thus for the instruments in the screenshot, I would like to get the data via an API call however when I conduct the API call the system doesn't recognize the RIC, however the data is available when I conduct an extraction via the GUI,
0 -
As
you can see, there is quite a bit of information provided, but alas, no Bid or
Ask prices to be seen. Furthermore, the search for RIC=XS1068108932=BARL
returned the message "No securities found." (this was within the
Datascope Select "Instrument Search" console). HOWEVER, the
search for Isin= XS1068108932 does return a few options in the Datascope
Select "Instrument Search" console, but these have RIC codes as
follows:–
GB106810893=–
GB106810893=BARL–
XS1068108932None
of these Instruments, however, were able to return any Bid or Ask prices when
included in the report. Sorry for all of the issues here, hopefully we
can have this resolved soon.Here
are the definitions for the Instrument List and for the Report Template:halointraday-rpt-definition.txt0 -
@preshan.govinder Hi Preshan, not sure if my response in: https://community.developers.refinitiv.com/questions/33872/dss-rest-api-requestresponse-2.html helps/helped at all with this?
0 -
Duplicate of this thread.
0 -
Hi,
This worked perfectly! Really Appreciate the help.
0 -
Hi Gareth, yes this did help. The most important part was setting the validation option "allowOpenAccessinstruments" = True
0 -
Glad it worked :-)
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 167 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 688 Datastream
- 1.4K DSS
- 624 Eikon COM
- 5.2K Eikon Data APIs
- 11 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 255 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
- 692 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
- 105 UPA
- 194 TREP Infrastructure
- 229 TRKD
- 918 TRTH
- 5 Velocity Analytics
- 10 Wealth Management Web Services
- 91 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛