question

Upvotes
Accepted
Pro1997 avatar image
1 ●3 ●1 ●0

Query using TRTH REST API

b <- list(

ExtractionRequest = list(

odata.type = "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TickHistoryTimeAndSalesExtractionRequest",

ContentFieldNames = list(

"Trade - Price",

"Trade - Volume",

"Trade - Exchange Time"

),

IdentifierList = list(

odata.type = "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",

InstrumentIdentifiers = list(list(

Identifier = 'AAPL.O',

IdentifierType = 'Ric'

))

),

Condition = list(

MessageTimeStampIn = "GmtUtc",

ReportDateRangeType = "Range",

QueryStartDate = "2017-09-29T00:00:00.000Z",

QueryEndDate = "2017-09-29T12:00:00.000Z"

)

)

)

url <- "https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractRaw"

r <- httr::POST(url,add_headers(prefer = "respond-async",Authorization = token),content_type_json(),body = b,encode = "json")


Response [https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractRaw]

Date: 2020-09-10 09:49

Status: 400

Content-Type: application/json; charset=utf-8

Size: 176 B


This is the response, I got for running the above code. I think there is something wrong, not sure what exactly that is. Could someone please help out ?





tick-history-rest-apirest-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.

Gurpreet avatar image Gurpreet

I have moved this question into TRTH category

moragodkrit.chumsri_1 avatar image   moragodkrit.chumsri_1

@Pro1997

Thank you for your participation in the forum.


Is the reply below satisfactory in resolving your query? If so please can you click the 'Accept' text next to the appropriate reply.


This will guide all community members who have a similar question.


Thanks,

AHS

wasin.w avatar image   wasin.w

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,


AHS


1 Answer

· Write an Answer
Upvotes
Accepted
Gurpreet avatar image
22.1k ●59 ●14 ●21

Hi @Pro1997, Your query and endpoints look correct and I am able to get data from it. I used python and here is my request and response:

Request JSON:
{
 "ExtractionRequest": {
  "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TickHistoryTimeAndSalesExtractionRequest",
  "ContentFieldNames": ["Trade - Price", "Trade - Volume", "Trade - Exchange Time"],
  "IdentifierList": {
   "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
   "InstrumentIdentifiers": [{
     "Identifier": "AAPL.O",
     "IdentifierType": "Ric"
    }
   ]
  },
  "Condition": {
   "MessageTimeStampIn": "GmtUtc",
   "ReportDateRangeType": "Range",
   "QueryStartDate": "2017-09-29T00:00:00.000Z",
   "QueryEndDate": "2017-09-29T12:00:00.000Z"
  }
 }
}

Response:
{
 "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#RawExtractionResults/$entity",
 "JobId": "0x073ea4868f96d724",
 "Notes": ["Extraction Services Version 14.2.41795 (d0fe3ba7b1b1), Built Aug 27 2020 18:51:42 *****"]
}

#RIC,Domain,Date-Time,GMT Offset,Type,Price,Volume,Exch Time
AAPL.O,Market Price,2017-09-29T08:00:00.051760533Z,-4,Trade,153.11,10,08:00:00.009000000
AAPL.O,Market Price,2017-09-29T08:00:00.051760533Z,-4,Trade,153.11,1,08:00:00.009000000
AAPL.O,Market Price,2017-09-29T08:00:00.051760533Z,-4,Trade,153.11,6,08:00:00.009000000
AAPL.O,Market Price,2017-09-29T08:00:00.103591325Z,-4,Trade,153.27,100,08:00:00.088000000


I am not familiar with R programming, but you can see an example of it being used in this question. I can't see from your question, if you have used Auth token as Token + space + actual token

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.