Query using TRTH REST API

Options
Pro1997
Pro1997 Newcomer
in TRTH

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&quot;

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 ?





Tagged:

Best Answer

  • Gurpreet
    Gurpreet admin
    Answer ✓

    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

Answers

Categories