Field and Domain changes in the Datascope and Tickhistory products
DataScope Select (DSS) and LSEG Tick History offers a comprehensive data model and supports a variety of asset classes. Recently, due to the creation of LSEG as a separate entity, some aspects of the product will undergo mandatory tech changes. This article intends to summarize these changes, so that existing users of DSS and LSEG Tick History can modify their applications to migrate to the new setup.
These changes are driven by Refinitiv's legal requirements, from the contractual separation between Thomson Reuters and Refinitiv. They affect the following areas of an application:
- The network domain changes
- Request message changes
a. Changes in the request namespace
b. Changes in the Field names - Response message changes
a. Changes in the response namespace
These technology changes effect all the applications of DSS/LSEG Tick History, regardless of weather it is developed using REST API, .NET SDK or using FTP service.
Please see the Product Change Notification for the last date for the cut over to the new system.
Changes in the network domains
The network domain for the DSS and LSEG Tick History products will change from Reuters to Refinitiv, and will omit the hosted sub-domain in the URL.
Platform | Old Domain Name | New Domain Name |
GUI | hosted.datascope.reuters.com | select.datascope.refinitiv.com |
SOAP API | hosted.datascopeapi.reuters.com | selectapi.datascope.refinitiv.com |
REST API | hosted.datascopeapi.reuters.com | selectapi.datascope.refinitiv.com |
FTP/SFTP | hosted.datascope.reuters.com | select.datascope.refinitiv.com |
Using the example above, the DSS/RTH applications, will have to be modified to use the new endpoint at https://selectapi.datascope.refinitiv.com/RestApi/v1.
In addition to the domain name change, some parts of URI will also need to be modified. The URLs which included the Thomson Reuters or abbreviation as the part of URI, which need switching too. For e.g. the context name /AskTrps should be replaced with /EvaluationConnect in request URLs. So for example, the final URL will change from:
OLD URL | datascopeapi.thomsonreuters.com/restapi/v1/AskTrps/ChallengeCreate |
NEW URL | selectapi.datascope.refinitiv.com/RestApi/v1/EvaluationConnect/ChallengeCreate |
The Refinitiv domain will have its own new IP addresses, and the addresses associated with the old domain will no longer be valid. If the organization employs a network firewall or proxy, the new IP addresses will have to be white-listed. See the Migration User Guide for the list of all the static IP addresses.
Changes in the request messages
The OData namespace will change from ThomsonReuters.Dss.Api to DataScope.Select.Api. For e.g: A composite extraction request will now look like:
{
"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.CompositeExtractionRequest",
"ContentFieldNames": [
"RIC Root",
"Security Description",
"Tick Value",
"Strike Price"
],
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [{
"Identifier": "PRUD162109250.U",
"IdentifierType": "Ric"
}
],
"ValidationOptions": null,
"UseUserPreferencesForValidationOptions": false
},
"Condition": null
}
}
In addition the namespace containing AskTrps will change to EvaluationConnect as well. For e.g. the old namespace for creating a Broker Challenge:
@odata.type": "#ThomsonReuters.Dss.Api.AskTrps.BrokerChallengeRequest
will change to -
@odata.type": "#DataScope.Select.Api.EvaluationConnect.BrokerChallengeRequest
Changes in the field names
The field names which contain Thomson Reuters will also change. Reports that contain TR fields occur in all the report templates. Some of these fields and the new ones are:
Old Field Name | New Field Name |
Thomson Reuters Assigned Ticker | Refinitiv Assigned Ticker |
Thomson Reuters Classification Scheme | Refinitiv Classification Scheme |
TRPS Complex Instrument Code | Evaluated Pricing Service Complex Instrument Code |
TRPS Score | Evaluated Pricing Service Score |
Underlying Thomson Reuters Classification Scheme Description | Underlying Refinitiv Classification Scheme Description |
... | ... |
A general rule is, to replace Thomson Reuters with Refinitiv, and replace TRPS with Evaluated Pricing. Please refer to the Migration User Guide to get a complete list of all the fields.
Changes in the returned content
The response body will now return OData namespace of selectapi.datascope.refinitiv.com. For e.g. the above response for the composite extraction request shown earlier will now be:
{
"@odata.context": "https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#RawExtractionResults/$entity",
"JobId": "0x0785e79d65ac76e1",
"Notes": ["Extraction Services Version 14.5.42294 (737b0965c07f), Built Apr 8 2021 13:46:55
Extraction ID: 519626634
.
.
Base Usage
Instrument Instrument Terms Price
Count Type Subtype Source Source
------- ----------------------------------- ---------------------------- -------------- ----------------------------------------
1 Derivatives N/A N/A
-------
1 Total instrument charged.
0 Instruments with no reported data.
=======
1 Instrument in the input list.
No Evaluated Pricing Service complex usage to report -- 1 Instrument in the input list had no reported data.
"]
}
Data:
RIC Root,Security Description,Tick Value,Strike Price
PRU.U,PRU Apr1 92.5 C,1,92.5
In addition to the changes in the namespace, the new requested fields will be returned in the response. For e.g. Evaluated Pricing Service Market Convention Ask Price instead of TRPS Market Convention Ask Price. Please refer to the changes in the field name section above.
Updated SDK
An updated .NET SDK is available for download at the DSS Website. The New SDK already implements all the changes mentioned above in terms of the new domain names etc. The users of SDK will need to recompile their application with new SDK, while scanning their code base for old field names like TRPS, and the use of any old OData namespace. The application should remove all references to the Thomson Reuters DataScope Select SDK and replace them with the same references for the LSEG DataScope Select SDK.
The C# example application has been updated and can be compiled with the new SDK. It incorporates all these changes and can be downloaded from the DSS Website.
Changes in Report Templates
All the reports which contain the reference to Thomson Reuters or TRPS in the field name will now have to be renamed to Refinitiv and Evaluated Pricing respectively. Please refer to the PCN Guide, for step by step screen-shots of how to edit the report templates and fields in the DSS website.
FTP/SFTP changes
In addition to the namespace and field changes mentioned above, the FTP and SFTP domain name will be changed from hosted.datascope.reuters.com to datascope.refinitiv.com. The new IP address of the FTP service will be different from the old IP and will need to be white-listed in the corporate firewall. Refer to PCN Guide linked in the references, for latest static IP addresses.