Query using TRTH REST API

Pro1997

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 ?

Find more posts tagged with

rest-api

tick-history-rest-api

Accepted answers

Gurpreet

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

All comments

Gurpreet

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

Gurpreet

I have moved this question into TRTH category

EXPLORE OUR SITES