-
How to do scheduled extraction for every end of month?
Hi Team, I am trying to do scheduled extraction for every month as part of it, I have created the instrument list and using ListID called 'InstrumentListAppendIdentifiers' and then called 'EndOfDayPricingReportTemplates' to get 'ReportTemplateId' and with 'ListId' and 'ReportTemplateId' called 'Schedules' to get scheduled…
-
SSIS issue EndOfDayPricing odata
HI we added odata source in ssis package, for both option we faced error as below 1- we use webservice root as source: "https://selectapi.datascope.refinitiv.com/RestApi/v1" and for authentication we use basic, so test connection is success. but we we use this connection as source we face error as "unable to load" as…
-
Terms & Condition Reference Data
We are migrating to "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.PriceHistoryExtractionRequest" from "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.ElektronTimeseriesExtractionRequest" Although the API End Point :…
-
DSS Immediate Schedule Stuck in "Queued" Status
I created a Immediate DSS Schedule. It has had Status = "Queued" for about an hour now. I found some references to the extraction queue in the DSS User Guide, but I don't know what causes this issue. Can anyone help out here?
-
Getting CUSIP/ISIN for stock RIC code
Hi Team, I have a list of RIC codes and I'm trying to get the corresponding CUSIP/ISIN and the dates for which the mapping is valid using RTH Python. I use the following code, but the CUSIP field always returns a null value. Not sure about the corresponding field for the Bloomberg ticker. instrument_list = [{'Identifier':…
-
usage of the RawExtractionResults when I tried to call it I got error
usage of the RawExtractionResults when I tried to call it I got error { "error": { "message": "Cannot get all RawExtractionResult entities. Please provide an ID with the request." } }
-
DSS ElektronTimeseries Latency
Hello, I am using DSS ElektronTimeseriesExtractionRequest to get end of day (EOD) quotes for various RICs. I was wondering: How long does it take, after the market closes, for each of the following fields to be updated? ["Open", "High", "Low", "Settlement Price", "Volume", "Open Interest", "Trade Date"] I understand that…
-
Retrieving RIC Contract Year and Month
Hello, I was wondering if there are "ContentFieldNames" for contract year and month? Using [second last, last] characters in the RIC for [month, year] is sometimes unreliable for me, since I have instruments that expire in 10+ years (e.g. NGZ34 for natural gas December 2034). I would prefer not to implement my own parsing…
-
"/Extractions/Extract" vs. "/Extractions/ExtractRaw"
Hello. I am new to DSS REST API. What is the difference between "/Extractions/Extract" and "/Extractions/ExtractRaw"? I made an ExtractionRequest using both of them, without the "Prefer: respond-async" arg in the header, and with the following payload: {"ExtractionRequest": {…
-
Can't pull data for expired contracts - do I need to specify AssetStatus?
Hi - I am trying to pull data for an expired contract. My extraction request looks like this: requestBody = { "ExtractionRequest": { "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TickHistoryIntradaySummariesExtractionRequest", "ContentFieldNames": [ "Close Ask", "Close Bid", "High", "High Ask", "High…
-
CDS Curve APPS & TOOLS Extraction
Bonjour, j'aimerai extraire les données de la courbe CDS via python (cf image ci-dessous). Quels sont les fields pour Tenor, Recovery rate et Default prob ?
-
Getting Latest Extraction Steps
I have a report template (FXMain) with a daily schedule (FXDaily). I am looking to use Microsoft Flow to get the latest extract for the report. In the API documentation, it makes it seem as though I have to jump through numerous hoops to get to that data. None of those hoops seem to rely on the basic information I already…
-
API issue - response has no data although client is getting 200 OK
I'm trying to download data for EURUSD, but I get no data my query are: requestUrl = 'https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractRaw' requestBody = { "ExtractionRequest": { "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TickHistoryTimeAndSalesExtractionRequest",…
-
API issue - response has no data although client is getting 200 OK
I'm trying to download data for EURUSD, but I get no data my query are: requestUrl = 'https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractRaw' requestBody = { "ExtractionRequest": { "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TickHistoryTimeAndSalesExtractionRequest",…
-
TickHistoryRaw Rest API received response not formatted
I am using TickHistoryRaw Rest API while providing few Fids in the extraction request. I am using Python and used the same tutorial logic provided in Refinitiv tutorials. The response i am saving in gzip format and then unzipping it which is csv file. Below is my Python file: Python_TickHistoryRaw.txt When i opened csv its…
-
TickHistoryRawExtractionRequest REST API throws an error using Curl
I have followed below steps using curl: 1) get the authentication token which is working and generated token: OdiOSCommand "-OUT_FILE=/home/oracle/Documents/OutFile/refinitiv_file.txt" "-CAPTURE_OUT_STREAM=ON_ERROR,10,50" "-CAPTURE_ERR_STREAM=ON_ERROR,10,50" curl -H "Content-Type: application/json" -H "Prefer:…
-
In EOD Pricing based on data availability, why there are two extractions after a holiday?
Hi Team, To understand more, i will give an example: If 20-01-2021 is an holiday, there are no extractions on the same day, which is expected. But on 21-01-2021, there are two extractions, one for 19-01-2021 with the published rates in MONY market and 20-01-2021 with blank field. Why so? Is there any option to keep the…
-
Intraday request format for partial response
Hi Team, Can you please help with the IntradayPricingExtractionRequest format. We are currently facing issues for some isins where embargo time is >15 mins. Request sent by our system receives a 202 response even if one isin out of the list sent has embargo time greater. Our system is currently configured to try for max 15…
-
Intraday Embargoed data problem C# app
Hi, I tried to get the Intraday embargoed data via C# Console app(RESTAPI) . I can get the data 15 mins delay via postman app but on my C# app(RESTAPI) no data returns. Does it have any tricks to get the data on code? I increased the timeout but nothing has changed.
-
Long Running Requests Return no Progress Update - DSS C# SDK
I have a question around the extractwithnotes async call. When running short requests I have no issue seeing the progress of the job on the callback method however when there is a larger request there is no progress or status update (as far as I can tell). The application awaits the aysnc result but it never actually…
-
How to Fix, TRTH On Demand Raw Data Extraction Errors
Hello , I am working on setting up a python downloader for “On Demand Raw Data Extraction” using the documentation provided here (https://developers.refinitiv.com/en/api-catalog/refinitiv-tick-history/refinitiv-tick-history-rth-rest-api/tutorials#rest-api-tutorial-8-on-demand-raw-data-extraction) I’m running into an issue…
-
REST API GET Request sometimes returns 204 for latest scheduled extraction
Hi Refinitiv, We are calling the REST API to retrieve the latest extraction for a schedule (HTTP GET request to /Extractions/Schedules('0x078e2339d14c9177')/LastExtraction). On rare occasions we are receiving a HTTP 204 response (NO CONTENT). This is not documented as a potential response for this type of request. Would…
-
Reference data for a RIC has no 'First Trading Date', but has a Change Date - what does this mean?
When I make a query to the API for the historical reference data for a number of RICs, some return with no First Trading Date e.g. { "IdentifierType": "ChainRIC", "Identifier": "0#ALSI:", "Instrument ID": "0#ALSI:", "Ticker": "ALSI", "Trading Status": 1, "First Trading Date": null, "Last Trading Day": "2020-06-18",…
-
"Historical reference request" is not returning any data
I do this extraction every day and there tends to be difficulties often. I'm not sure what I'm doing wrong. I put the extraction in a try/catch loop and it normally takes a few go's for it to return the data I want but today it's just stuck returning nothing. I'm the only one running the extraction, so it's not because…
-
hosted.datascopeapi.reuters.com:443 failed to respond
We get the following error: hosted.datascopeapi.reuters.com:443 failed to respond when trying to extract data from Tick History API. We only saw this error 3 times, for 3 requests that occured at approx. the same time. We are not keeping any client session ID in the requests.
-
How to extract LIBOR 3M swap curve (over 12 months) by sending request to DSS REST API?
1) which kind of request should be used to do so ? EndOfDayPricingExtractionRequest or PriceHistoryExtractionRequest or IntradayPricingExtractionRequest ? 2) what content field names should be used if I want to extract currency code, close price, trade date, security description, RIC and value date of 3M swap curve of…
-
Dss extraction marketDepth, format errors
Hi Im using Dss to extract market depth data. It seems to work fine until after many successful batches of data received, format errors occur. please have a look at the logoutput: [15:57:54 DBG] Dss ReadRawExtractionResponse line read: "DEBYF1,Market Price,2020-01-08T07:26:20.019568103Z,+1,Normalized…
-
Data Extraction issue with Reuters DSS C# API
We are not able to extract EOD data for few expired contracts as per the defined start & end dates using C# .NET DSS API. And we are successfully able to extract data from Reuters DSS (User interfaces) for the same expired contract. I have checked the Developer forum but didn't get any positive response. Below expired…
-
Error: Max retries exceeded with url: /RestApi/v1/Authentication/RequestToken
I am getting the below error while trying to get token from DSS REST API, Even after using verify = False , I am getting the same error requests.exceptions.ConnectionError: HTTPSConnectionPool(host='hosted.datascopeapi.reuters.com', port=443): Max retries exceeded with url: /RestApi/v1/Authentication/RequestToken (Caused…
-
TRTH / DSS Timeseries Extraction 10-Year Bond 'Close Yield' Column is Empty
Hi, I'm noticing that when I try to retrieve 10 year treasury bond yield data for various countries, including the US (RIC: US10YT=RR), that the 'Close Yield' field (and the 'Universal Close Price' for that matter) is empty. In answering a related question about TRTH bond pricing, @nick.zincone.1 has illustrated exactly…
-
DSS SOAP Extract from SAP
How can I call the extract webservice from SAP for eod-pricing? In the sample for the eod-pricing is the type "InstrumentExtractionRequestEndOfDay", but in SAP I can't fill in the type. The import-structure in SAP is only with the "OutputFields" The errorr-message: "Server was unable to read request. > There is an error in…
-
We are trying to extract fundamental fields from eikon API to come in a specific format per screensh
-
Duplicate dates with different & wrong prices
Hi The following endpoint : https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractWithNote returns duplicated dates with both correct and wrong prices for all dates between 2016-10-18 and 2019-10-03. Example: Body : { "ExtractionRequest": { "@odata.type":…
-
. I would like it to save the extracted file in a certain location on my network drive everyday. How
I would like it to save the extracted file in a certain location on my network drive everyday. How can I configure this destination for the extracted file, there is a business week schedule. For TRTH
-
Extract Govt 10 year yield using API
I need yields for govt issued 10 year bonds I am using the following request body which returns empty data. { "ExtractionRequest": { "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ElektronTimeseriesExtractionRequest", "ContentFieldNames": [ "Yield" ], "IdentifierList": { "@odata.type":…
-
get_timeseries doesn't start from the date I put - Eikon API python
I only get data from 4/2/2019 to today, but I was asking for data from 1/1/2007 to today. this is my code: iso =['AT','BE','BG','CH','CY','CZ','DE','DK','EE','ES','FI','FR','GB','GE','GR','HR','HU','IE','IS','IT','LT','LU','LV','MT','NL','NO','PL','PT','RO','RS','RU','SE','SI','SK','TR','UA'] iso[:]=[x + "5YT=RR" for x in…
-
https://api.thohttps://api.thomsonreuters.com/permid/calaismsonreuters.com/permid/calais
Dear Sir or Madam, since morning early I have 502 error in my demo application for one of Microservices of my master thesis. please inform me if the url is changed or how can I fix that problem because I have presentation in one week. :-S java.io.IOException: Server returned HTTP response code: 502 for URL:…
-
Detect securities unknown to Reuters
When requesting data for a security through its ISIN over the DSS REST API, I find out very late that actually that security is "not in the dictionary". This happens only through a bad error that I trap when trying to get the row.DynamicProperties.Item(<field name>). It suddenly tells me that the row object is not defined…
-
AWS File Extraction not working properly
I try to get the stream file of my schedule task, and read it into python, using the rest api call, using the following headers: headers = {'Authorization': 'Token %s' % auth, 'Prefer': 'respond-async', 'Accept-Charset': 'UTF-8', 'Content-Type': 'application/json',"X-Direct-Download":"true"} When i do not include…
-
Extracting relationships alongwith Entities using Opencalais
We are working on a business problem in which we have to extract entities alongwith proper mapping/relationship in free form email text. Here is one of the sample email: Hi, As per recent information, client John Smith, Walter Hoien and Paul Kauer have changed organizations. John and Walter joined GiriTech Inc. while Paul…