For a deeper look into our DataScope Select REST API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials
Hi.
I am connecting to the API with REST and I could generate a token and get some information with PHP cURL. I need to know which is the endpoint to obtain the sovereign bonds and provincial bonds of Argentina. Any information or Postman example would be helpful! I do not know if I should generate a report template. Here you can see an example implemented by a site: http://gruposbs.com/api/reuters/chain/SOBE (json response)
Thank you!
Hi @rodrigo.cataffo
I just tested the following request:
POST https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/Extract HTTP/1.1
Prefer: respond-async
Content-Type: application/json
Authorization: Token <your token>
{
"ExtractionRequest": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.EndOfDayPricingExtractionRequest",
"ContentFieldNames": [
"RIC",
"Ticker",
"Universal Ask Price",
"Universal Bid Ask Date",
"Universal Bid Price",
"Universal Close Price",
"Volume"
],
"IdentifierList": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentListIdentifierList",
"InstrumentListId": "0x05bd566fe9fb3026"
},
"Condition": null
}
}
Note that my list "0x05bd566fe9fb3026" contains "VZ.N, MCD.N and DIS.N" RICs.
And this is the result I got:
HTTP/1.1 200 OK
Content-Type: application/json; charset=utf-8
X-Request-Execution-Correlation-Id: c2788aab-1039-483c-843a-a25805fc1637
X-App-Id: Custom.RestApi
X-App-Version: 11.3.544.64
Date: Wed, 24 Jan 2018 03:17:19 GMT
Connection: close
{"@odata.context":"https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Collection(ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ExtractionRow)","value":[{"IdentifierType":"Ric","Identifier":"VZ.N","RIC":"VZ.N","Ticker":"VZ","Universal Ask Price":53.23,"Universal Bid Ask Date":"2018-01-23","Universal Bid Price":53.22,"Universal Close Price":53.23,"Volume":7141651},{"IdentifierType":"Ric","Identifier":"MCD.N","RIC":"MCD.N","Ticker":"MCD","Universal Ask Price":176.84,"Universal Bid Ask Date":"2018-01-23","Universal Bid Price":176.82,"Universal Close Price":176.81,"Volume":798702},{"IdentifierType":"Ric","Identifier":"DIS.N","RIC":"DIS.N","Ticker":"DIS","Universal Ask Price":110.43,"Universal Bid Ask Date":"2018-01-23","Universal Bid Price":110.41,"Universal Close Price":110.41,"Volume":1897303}]}
You request looks fine but the issue is related to your account's permission issue.
Hi @rodrigo.cataffo
You can find the tutorials here.
Basically, the endpoint is
https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/Extract
You don't have to generate a new report template, but you have to specify one of the default report templates, list of fields and list of instruments in your POST body.
For pricing data, there are; End of Day, Intraday, and Time Series pricing report templates. REST API Tutorial 2 to 4 should show you how to request each pricing reports.
A Postman collection and environment of the tutorials are available in the downloads.
Thank you very much for your help
Is not necessary to create a list of instruments in dss dashboard?
@rodrigo.cataffo, there are 2 ways to extract data, described here:
Warat is referring to an On Demand extraction.
thank you very much for your help!
I executed the following request:
Endpoint
https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/Extract
Body
{
"ExtractionRequest":{
"@odata.type":"#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.EndOfDayPricingExtractionRequest",
"ContentFieldNames":[
"RIC",
"Ticker",
"Universal Ask Price",
"Universal Bid Ask Date",
"Universal Bid Price",
"Universal Close Price",
"Volume"
],
"IdentifierList":{
"@odata.type":"#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentListIdentifierList",
"InstrumentListId":"0x0602dfc25d2b3016"
}
}
}
Response
{
"error": {
"message": "No permission for template \"EndOfDayPricingReportTemplate\"."
}
}
why?
