-
Limit search results through API - DSS Rest API
Hello Team, Is there a way to limit results through API just like we can do in the GUI?? PFA screenshot - Thank you, Trisha Gehlot
-
UiPath and DataScope API
I am looking to connect to DataScope API via UiPath using their HTTP Request activity. UiPath is a 3rd party RPA software that automates processes with out of the box "low code" activities. The HTTP Request activity allows me to set API end point and attach/configure parameters in a user friendly Wizard box. So I can't see…
-
Treasury futures level 2 historical nanosecond data access on-demand via Python API
Hello, I am looking trying to find the specification for pulling the level 2 data for treasury futures contracts, i.e. TYU24, for all best bid and best ask as well as each of the respective volumes for each of the levels. I would like to receive a response with the most granular intraday timing for a specified date (I…
-
Instrument search - "PreferredIdentifierType": "OrgId"
By using the API for an Instrument Search [below request payload] the identifier type in the output is "NONE", this seems wrong and should be 'OrgId' as: - the request has OrgID as preferred identifier - identifier is an OrgID in the output API Request – URL -…
-
host='selectapi.datascope.refinitiv.com', port=443 Error
Hello Team I am getting this error, could you please help on the same- requests.exceptions.ProxyError: HTTPSConnectionPool(host='selectapi.datascope.refinitiv.com', port=443): Max retries exceeded with url: /RestApi/v1/Authentication/RequestToken (Caused by ProxyError('Cannot connect to proxy.', RemoteDisconnected('Remote…
-
Condtion used in bond report tempate in DSS
why below condition is used in Datascope API , "Condition": { "BondScheduleTypeCodes": [ "UOPH" what does UOPH stands for ? do we have list of such codes . and can several Option Codes be used simultaneously in a single request?
-
Null Value First Notice Day for Future Contract and TermsAndCondition Template
requestUrl = r"https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractWithNotes" # requestUrl = r"https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractRaw" requestHeaders = { "Prefer": "respond-async", "Content-Type": "application/json; odata=minimalmetadata", "Authorization": "token " +…
-
RIC code is getting null for all the attached list of CUSIP identifiers.
We are getting ric code null when we call EndOfDayPricingExtractionRequest with CUSIP. List of CUSIP's are printed below as I am not able to attach the file Can any one quickly guide me on how to get RIC code not null for CUSIPs identifier., CSP,53945CKX7 CSP,802437FY4 CSP,13063DUD8 CSP,296385AT4 CSP,617403ES5…
-
Retrieve RIC codes from ISIN and Exchange in instrument search
I am currently working on retrieving RICs for instruments using the Refinitiv API, given an ISIN and exchange. I am using the endpoint: https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/InstrumentSearch. My goal is to obtain the specific RIC for a given exchange and ISIN from the search results. For example, I am…
-
ExtractWithNotes returns different ISIN results than the one requested
https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractWithNotes returns some other ISIN than the one requested for. This could be due to the underlying ISIN combinations. But we're expecting that the API returns correct response with the requested ISIN.
-
Does Refinitiv provides any algorithm like MD5 validation in DSS API Response?
We are under going audit and as per audit requirement we have to demonstrate that data we receive from Refinitiv is complete. To do that we need to validate checksum/md5/hash( or any equivalent algorithm ) that is sent by source along with response. So we wanted to know if Refinitiv apis provide any of the above…
-
What is the Validation option to be used for "Exclude Null Codes For Universal Close Price" in DSS R
I tired to fetch all the User Preference setting validation options from the link https://selectapi.datascope.refinitiv.com/RestApi/v1/Users/UserPreferences(9015484). However, I couldn't find anything related to "Exclude Null Codes For Universal Close Price".
-
DSS Extraction Request for Terms&Conditions
Hi, I have a customer start playing with Datascope Select REST API and would like to be sure if the request she build using method ExtractWithNotes to extract data using Terms&Conditions template is well done. Could you please confirm if below code is OK or if something is missed? { "ExtractionRequest": { "@odata.type":…
-
How to extract field COMM_LAST from datascope REST API?
How to extract field COMM_LAST (default returned from refinitiv.data.get_history) from datascope REST API? I can pull COMM_LAST from the refinitiv.data.get_history, but the same ric is returned as not found in datascope InstrumentListValidateIdentifiers. def validate_instrument(token, ins_list): url =…
-
Extractions/ExtractWithNotesResult does not honor timeout headers.
While Extractions/Extract* honors wait values passed in the Prefer header, Extractions/Extract*Result always lingers for 30 seconds. We use a serverless architecture for requesting extractions, and we're billed per second of runtime. I would prefer not to have instances alive and waiting for no reason. NOTE: I am aware of…
-
Tracking/limiting the API calls on DataScope REST API
Hello all, Is there a way to track or limit the API calls on DataScope REST API (e.g. via a function that can be implemented)?
-
DSS API error urllib3.exceptions.ReadTimeoutError: HTTPSConnectionPool(host='selectapi.datascope.re
We tried out the request below but unfortunately now we get a timeout error. Could you check the error message on your side and what the issue is about: Our request: {'ExtractionRequest': {'@odata.type': '#DataScope.Select.Api.Extractions.ExtractionRequests.LegalEntityDetailExtractionRequest', 'ContentFieldNames': ['ID',…
-
Derivative Ric resolution
What is the best way to resolve a Ric for a derivative (OPTION/FUTURE)? I know there is a mechanism to do this using SFTP, but is there a way using an http api. Thanks.
-
How to call count API Hits In DSS
Hello Team, We want a better way to count API call hits, as One call, calls one more API call(As if Request_Url/nextlink is sent along with the result) We use - https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractWithNotes &…
-
DSS REST API Delect Instrument from a InstrumentList
In DSS REST API Tree, there's no example about how to delete a Instrument from a Instrument List by 'InstrumentListItemKeys' so can you share the sample REST call to delete dummy item key , 'VjF8MHgwOGY3NTQyZTA1ODlmMmU2fDI'? '0x08f7542e0589f2e6', dummy IL. Two attempts below but failed. * POST…
-
Find all Rics in a chain
Hi, Can someone point me in the right direction please. I have a ChainRIC "1WSURF11" When I use DSS portal I can see all the consistuents for 1WSURF under the Open Access Constituents tab How would I find the same using the REST API? tnx in advance, Brian
-
"Extractions/ExtractWithNotes" - 429 Error
Hello Team, We are running "Extractions/ExtractWithNotes" with ON Demand Approach for End of Day Pricing data. As per the Document BEST PRACTICES & FAIR USAGE POLICY(DOCUMENT VERSION 7.0) we can run 2 concurrent runs for this API and 30 hits to the API in a minute. But then too its giving 429 Status code, after few chunks…
-
PKIX Path building failed for refinitiv API
Caused by: org.springframework.web.client.ResourceAccessException: I/O error on POST request for "https://selectapi.datascope.refinitiv.com/RestApi/v1/Authentication/RequestToken": PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested…
-
Composite Accrual Field
I'm currently using the composite on demand extraction to get the daily accrual of a Mutual Fund. I'm currently using the 'Accrual' field to get the daily dividend accrual and I have a few questions: Question1: Can we change the precision of the accrual returned? Increasing/Decreasing it through the API? Question2: Is…
-
Extracting fields from 2 or more reports in DSS using API
Hello, I have 16 K list of RICs that i need to pull data for a month from 3 DSS templates. Can you tell me how I can do this via REST API (postman code) Field DSS Template Bid Elektron Timeseries Ask Elektron Timeseries Universal Ask Price Composite Universal Bid Price Composite Universal Close Price Composite Close Price…
-
How to retrieve data for all RICs under an ISIN via DSS REST API?
DSS API Source query.jpg Hello, how can I retrieve e.g. Intraday pricing data for all RICs under a given ISIN? I tried this command but "*" in Source field does not work (it does in DSS GUI): { "Identifier": "DE0005190003", "IdentifierType": "Isin", "Source": "*" }
-
Searched for Futures and Options unsuccessfully with status code 502 in between of multiple long run
DSS Rest API Domain - https://selectapi.datascope.refinitiv.com/RestApi/v1/ URL - https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/FuturesAndOptionsSearch Total instruments for 1 day data - 418788 Details of issue - As more then 400 instruments were giving server busy error, tried querying this above URL in…
-
Error with URL - Search/FuturesAndOptionsSearch
We are getting error while accessing URL - https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/FuturesAndOptionsSearch, through code. Before Friday it was working. On Friday it gave error with Contact support message. PFA the error got today. Please guide if server is down, or something needs to be done from our…
-
Different API Keys for Prod and DEV - Datascope Select
We have a query on the API key being generated when using your API. For background, we are using the API in our production environment everyday but we also very periodically test pulling data into our dev environment too. At the moment, it appears both have the same API key which we are a bit worried about. Ideally, we…
-
DSS API 503 Error faced by the customer
Details shared by the Customer: We are still receiving the 503 errors and I am unable to provide you the query as we are not logging the payload we send. The error will return a message such as: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN""http://www.w3.org/TR/html4/strict.dtd"> <HTML><HEAD><TITLE>Service…
-
Best Practices to handle number of instruments greater than its limit
Hello team, We need your guidance with the handling the number of instruments greater than its limit. For example - instrument count is 385909 and as per our understanding limit for EOD pricing data is 75000. And going forward, through the underlying RIC, instrument will get expanded and will increase. So If you can help…
-
Issue with DSS API validation option
I am trying to add the validation option “RequireOfferingCodeMatch" in my DSS API Query , but my result is showing as a bad request. Ideally, I am trying to use the below preferences in my DSS API query. API result: Below is the API query which we are tying to run , please help us what should be the right query to add…
-
/Extractions/InstrumentListImportFromBytes Information
Refinitiv customer support recommended me to use /Extractions/InstrumentListImportFromBytes. I cannot find much information in the REST API Reference tree or in the Q&A Forum. It would be great if you could please provide me with information about what the API does and examples for the input and output. These are the steps…
-
API to pull all Futures RIC Root for global exchange?
Is there any API via DSS that can provide the complete list of Futures RIC Root that client can use to pull the details? Client is after the RIC ROOT and associated description for the future along with exchange code / name for all the exchanges. DSS GUI limit search to 5000 RIC root only.
-
Data Scope Selelct TermsAndConditionsExtractionRequest
request_body = { "ExtractionRequest": { "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest", "ContentFieldNames": [ "RIC", "CUSIP", "ISIN", "SEDOL" ], "IdentifierList": { "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",…
-
How to add instruments to the instrument list from the extraction response of Search for a Future or
Hi Team, Can you please confirm if there is any API code to add the instruments to the instrument list from the response received in API query of 'Search for a Future or Option' API Query: { "SearchRequest": { "FileCodes": null, "CurrencyCodes": null, "ExchangeCodes": null, "IdentifierType": "Ric", "Identifier": null,…
-
Is there is some header we need to set, as we might have triggered some kind of recompression during
Hi all. We are consuming the https://selectapi.datascope.refinitiv.com RestApi/v1. Methods I am calling are: - [1] StandardExtractions/UserPackages - [2] StandardExtractions/UserPackageDeliveries - [3] StandardExtractions/UserPackageDeliveryGetUserPackageDeliveriesByPackageId The process is fine and we are getting the file…
-
TTF Option Settlement prices via DSS
I want to get the settlement price for a specific identifier. I have tried with the following request, but this returns a response code of 400. What am I doing wrong? * { * "ExtractionRequest": { * "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.IntradayPricingExtractionRequest", * "ContentFieldNames":…
-
Unable to download data via DSS REST API
I am using the DSS UI and have successfully able to download the data as shown However, when I try to get this data via the REST API, I get the error I have generated my token successfully as shown below. Please can you help? Regards Sumit
-
How to extract adjusted BPV for FGBLc1=CTD using python api from DSS
hi, I would like to download the daily BPV time-series for * FGBLc1=CTD * FGBSc1=CTD * FGBMc1=CTD * FGBLc1=CTD How can I do that via a python api? Regards Sumit