For a deeper look into our DataScope Select REST API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
srinivas.sivakumar avatar image
3 ●0 ●0 ●1

DSS REST API TickHistoryRaw not working

Hi All,

I am trying to migrate to the new API and I am having some trouble with creating Tick History Raw report templates.
I keep getting a 400 error while trying to create this report.

I checked the allowed parameters for THR and the response from the server is as below

GET https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/GetValidContentFieldTypes(ReportTemplateType=DataScope.Select.Api.Extractions.ReportTemplates.ReportTemplateTypes'TickHistoryRaw')
{"@odata.context":"https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#ContentFieldTypes","value":[]}

To check if this endpoint was working I tried with another report template

GET https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/GetValidContentFieldTypes(ReportTemplateType=DataScope.Select.Api.Extractions.ReportTemplates.ReportTemplateTypes'EndOfDayPricing') 
{"@odata.context":"https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#ContentFieldTypes","value":[{"Code":"EOD.3 Month High","Name":"3 Month High","Description":"Instrument's highest price over the last 3 months.","FormatType":"Number","FieldGroup":" "},{"Code":"EOD.3 Month Low","Name":"3 Month Low","Description":"Instrument's lowest price over the last 3 months.","FormatType":"Number","FieldGroup":" "},{"Code":"EOD.3 Month Percent Change","Name":"3 Month Percent Change","Description":"Percentage change in price over the last 3 months.","FormatType":"Number","FieldGroup":" "},{"Code":"EOD.52 Week High","Name":"52 Week High","Description":"Fund's 52-week high price represented in the fund's default currency.","FormatType":"Number","FieldGroup":"....},

Seems like the TickHistoryRaw report endpoint isn't setup/working properly. Unfortunately I cannot download postman in my enterprise, will try to get a tool to log my requests.


Any help would be appreciated, thanks!

dss-rest-api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

· Write an Answer
Upvote
Accepted
zoya faberov avatar image
32.2k ●40 ●11 ●20

Hello @srinivas.sivakumar ,

Have you had a chance to work through DSS Quickstart, are you able to run the same request (authenticate + get all fields) with your DSS credentials using DSS GUI example?

Are you successful in obtaining the valid token?

Are you including the obtained token within headers as you submit Get Available Fields request?

Please see REST API Tutorial 2: On Demand End of Day Extraction for the complete details to End Of Day request.

It is indeed very convenient to test with Postman, however, if is that is not an option for you, the alternative approach is testing with curl, the same sequence of steps will be required, please see Refinitiv Tick History REST API with CURL for the details.

Hope this information helps


icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
srinivas.sivakumar avatar image
3 ●0 ●0 ●1

hi @zoya faberov

Thanks for the help. Using the DSS quickstart tool helped and I found out I just had some additional json parameters which was causing the issue.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.