How to get exchanges rates using instrumentation list name and report template name?
I have DSS user account and I have created one instrumentation list & EOD Pricing report template. I want to develop one api in my project which calls Thomson DSS Rest API to get the conversion rates for all the currencies & crosses mentioned in the instrumentation list (I have 161 currencies in instrumentation list). I don't want to create any schedules, don't want to use immediate extraction functionalities as I don't want any extracted file. I want response as list of all exchange rates. Please help me ASAP.
Best Answer
-
@gurukrishna.santosh.kumar.ippili
On the screenshot, the response status is 202 Accept which means that the request is accepted but the extracted data is not available within timeout interval (30 seconds by default). You will have to send another HTTP GET request to get status of the extraction, using the location URL that was delivered in the HTTP 202 Response header. Once the extraction is completed, the request to location URL will return extracted data.
In Postman, below is the sample of "Header" tab of the response.
0
Answers
-
Hi @gurukrishna.santosh.kumar.ippili,
You can extract data using the On Demand extraction where extraction is created on the fly and extracted data can be received in JSON format. For more information about On Demand extraction, please see this guide.
Please follow the instructions in the On Demand End of Day Extraction tutorial.
Moreover, if you have an InstrumentList created on DSS server, you can also create On Demand extraction which uses existing instrument list as input identifier list.
Below is the sample of request.
POST
https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractWithNotes
{
"ExtractionRequest": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.EndOfDayPricingExtractionRequest",
"ContentFieldNames": [
"Ask Price",
"Bid Price",
"High Price",
"Low Price",
"Trade Date",
"Universal Close Price"
],
"IdentifierList": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentListIdentifierList",
"InstrumentListId": "0x05e64a4b0f5b2f96"
},
"Condition": null
}
}The Instrument List ID can be retrieved from the URL in the DSS GUI.
0 -
Hi , Thanks for your response. I have tried the same request in postman but didn't get any response. Please find the attached snapshot.
Note: My instrumentation list contains 161 currencies.
0 -
@veerapath.rungruengrayubkul I have few questions: 1) Is there any chance to increase the timeout of the request (more than 30 secs) so that we no need to make another request?
2) Is the ExtractionId will be different every time or same?
3) Just to inform that we are calling from .Net. Can we create two lists each contains (80 curriences) to overcome timeout problem?
0 -
Hi @gurukrishna.santosh.kumar.ippili,
Sorry. I have not seen your questions. Please see the answers below.
1) Is there any chance to increase the timeout of the request (more than 30 secs) so that we no need to make another request?
You can change the timeout value by specifying "wait" in the "Prefer" header of the ExtractionRequest message. Below is the sample of 120 seconds timeout. For more information, please see Key Mechanisms.
Prefer: respond-async, wait=120
2) Is the ExtractionId will be different every time or same?
The ExtractionId is unique identifier for each extraction, so it should be different for each extraction request.
0 -
Thanks for your response.
I have used the approach you suggested by taking the value in the location header and make get request.
Sometimes content property value is null. What is the reason? Any solution for this?
0 -
Thanks for your response.
I have used the approach you suggested by taking the value in the location header and make get request. It is working as expected but sometimes content property value is null. What is the reason? Any solution for this?
0 -
Hi @gurukrishna.santosh.kumar.ippili,
Could you share the request message and output which includes Notes information? There could be various reasons i.e. content not available, invalid instrurment).
0 -
Thanks for your response.
I have attached the document which contains success and failure scenarios with request message and extraction notes.
Request:
@{"ExtractionRequest":{"@odata.type":"#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.EndOfDayPricingExtractionRequest","ContentFieldNames":["Trade Date","Base Currency Code","Currency Code","Universal Close Price","FXIR Scaling Factor"],"IdentifierList":{"@odata.type":"#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentListIdentifierList","InstrumentListId":"0x06e4d6a06de133b0"},"Condition":null}}
Failed Case:
Regards,
Santosh Ippili
0 -
0
-
Please find the notes info in success case:
0 -
Hi @gurukrishna.santosh.kumar.ippili,
I have seen the "The operation has timed out" exception error. It is possible that the HTTP request operation you use has its own timeout interval and the response time exceeded the timeout. You may try increasing the timeout value. This depends on the library you used for HTTP request. For example, WebRequest.Timeout property.
0 -
I have already increased my RestSharp request timeout value. Do we need to increase Prefer header timeout value? Currently I am using respond-async, wait=120 value.
Regards,
Santosh Ippili
0 -
@gurukrishna.santosh.kumar.ippili,
Could you share the snippet code used for sending request and increasing timeout? I will try to replicate the issue.
0 -
I am using RestSharp Library to make rest request to DSS.
Please find the methods in the attached file for your reference.
If the content property null in the initial request I am using location header value to make other request.
0 -
Hi @gurukrishna.santosh.kumar.ippili,
I have tried the code but cannot replicate the issue on my environment. The extraction is on large instrument list. Also, I have tried to change the_restRequest.Timeout to low value to verify scenario that response was received after request timeout. The application returns different error message; "The request timed-out", so the issue should not be related to the response time.
According to the code, it seems that your application is on Azure environment. It is possible that the issue is related to the environment. Could you please modify the application to test on other environment outside of Azure?
Also, you can enable logging on your application to get more information by modifying the app.config file as attached.App.zip
0 -
Hi @gurukrishna.santosh.kumar.ippili,
Yes the application is deployed in azure environment but when I test in my laptop also issue is replicated.
We have enabled azure application insights where we can see all the logs.
Can we connect once so that I can replicate the issue?
Regards,
Santosh Ippili
0 -
Hi @@veerapath.rungruengrayubkul,
Yes the application is deployed in azure environment but when I test in my laptop also issue is replicated.
We have enabled azure application insights where we can see all the logs.
Can we connect once so that I can replicate the issue?
Regards,
Santosh Ippili
0 -
Hi @veerapath.rungruengrayubkul,
Yes the application is deployed in azure environment but when I test in my laptop also issue is replicated.
We have enabled azure application insights where we can see all the logs.
Can we connect once so that I can replicate the issue?
Regards,
Santosh Ippili
0 -
Hi @veerapath.rungruengrayubkul,
I have tested in postman for calling GET request to location header value. Below is the response.
Please find the attached snapshot. I am unable to attach my instrument list. Please let me know how to provide my instrument list
0 -
Hi @gurukrishna.santosh.kumar.ippili,
Please export the instrument list to a CSV file with the 'Export' button on the Instrument List Web GUI.
Also on the Postman call, please add the "Client-Session-Id" with unique identifier in the header of request message and provide "Request-Execution-Correlation-Id" header of the response message. For more information, please refer to the Diagnostic Header page.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
- 621 Eikon COM
- 5.2K Eikon Data APIs
- 11 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 4 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
- 669 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
- 48 中文论坛