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?