question

Upvotes
Accepted
3 0 0 0

Not able to reciever more thatn 1 day of data using trth rest api

Hi,

I am trying to use trth rest api. But when I try to TickHistoryRawExtractionRequest for multiple daya, I reciever data for only first day. ITs working for single day but not for multiple.


I have added the body of request below. Could someone please help? Thanks.


ExtractionRequest:

@odata.type : #ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TickHistoryRawExtractionRequest

Condition :

DisplaySourceRIC : 1

DomainCode : MarketPrice

ExtractBy : Ric

Fids : 25,31,22,30,5

MessageTimeStampIn : GmtUtc

QueryEndDate : 2016-09-29T00:00:00.000Z

QueryStartDate : 2016-09-27T00:00:00.000Z

ReportDateRangeType: Range

SortBy : SingleByRic

IdentifierList:

@odata.type : #ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList

InstrumentIdentifiers:

[ 0] = Identifier : CARR.PA

IdentifierType: Ric


tick-history-rest-api
icon clock
10 |1500

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

Upvotes
Accepted
23k 22 9 14

Hello @shubham.x.kumar,

Tested, I believe, the same request via Postman tool:

{
                {protocol}}{
                {host}}{
                {api}}Extractions/ExtractRaw 
{
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TickHistoryRawExtractionRequest",
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",  
      "InstrumentIdentifiers": [{
        "Identifier": "CARR.PA",
        "IdentifierType": "Ric"
      }]
    },
    "Condition": {
      "MessageTimeStampIn": "GmtUtc",
      "ReportDateRangeType": "Range",
      "QueryStartDate" : "2016-09-27T00:00:00.000Z",
      "QueryEndDate" : "2016-09-29T00:00:00.000Z",
      "ExtractBy": "Ric",
      "SortBy": "SingleByRic",
      "DomainCode": "MarketPrice",
      "DisplaySourceRIC": true
    }
  }
}

The result is pretty sizeable, 10.84M, so instead of "Send" button on the tool, I choose "Send and Download", and load it as a separate file.

The result includes two days of data, 27th and 28th and looks valid.

Suggest to try this request with Postman on your side, if you have not used Postman before, you may find Tutorials REST API Tutorials Introduction and REST API Tutorial 8: On Demand raw data extraction of help to review, the first one explains how to install and use Postman, the second on TickHistoryRawExtractionRequest, just modify the request that is part of the downloadable collection to your dates.

icon clock
10 |1500

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

Upvotes
3 0 0 0

Hi,


Thanks for checking.


When I do this,

https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractRawResult(ExtractionId='0x07576bb7c877120d')

{"@odata.context":"https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#RawExtractionResults/$entity","JobId":"0x07576bb7c877120d","Notes":["Extraction Services Version 14.3.41935 (052f652420ba), Built Sep 4 2020 17:13:46\nUser ID: 9015812\nExtraction ID: 2000000201367162\nSchedule: 0x07576bb7c877120d (ID = 0x0000000000000000)\nInput List (1 items): (ID = 0x07576bb7c877120d) Created: 2020-11-26 07:24:18 Last Modified: 2020-11-26 07:24:18\nReport Template: _OnD_0x07576bb7c877120d (ID = 0x07576bb7c897120d) Created: 2020-11-26 07:23:14 Last Modified: 2020-11-26 07:23:14\nSchedule dispatched via message queue (0x07576bb7c877120d), Data source identifier (543CCB31AAA84094B2061A5596FC4FAD)\nSchedule Time: 2020-11-26 07:23:16\nProcessing started at 2020-11-26 07:23:16\nProcessing completed successfully at 2020-11-26 07:24:19\nExtraction finished at 2020-11-26 07:24:19 UTC, with servers: tm04n01, TRTH (47.643 secs)\nInstrument expanded to 1 RIC: CARR.PA.\nTotal instruments after instrument expansion = 1\nQuota Message: INFO: Tick History Cash Quota Count Before Extraction: 3; Instruments Approved for Extraction: 1; Tick History Cash Quota Count After Extraction: 3, 3% of Limit; Tick History Cash Quota Limit: 100\nManifest: #RIC,Domain,Start,End,Status,Count\nManifest: CARR.PA,Market Price,2016-09-27T01:25:00.679542394Z,2016-09-28T15:36:26.286749914Z,Active,192324\n"]}

Shows 192324 rows.


But this has only 67511 rows.

https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/RawExtractionResults('0x07576bb7c877120d')/$value

icon clock
10 |1500

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

Upvotes
23k 22 9 14

Hello @shubham.x.kumar,

Have you had a chance to confirm the size of the original request you have asked about, that I have verified for the exact response size? Did it match my result size?

---

For the last request, with the job id, if you would like to include the complete request, I will test it on my side.

If you would like to verify correctness by jobId, the moderators of the developers forum do not have access to client-run requests by jobId. But as a customer, you can verify the correctness of Tick History result content with Refinitiv product content experts, by opening a support case with Refinitiv Helpdesk Online -> Tick History

icon clock
10 |1500

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

Upvotes
3 0 0 0

Hi,

I did check and its matching the results. I used a different rest api to query data and it worked.

Thanks for all the help and time.

icon clock
10 |1500

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

Click below to post an Idea Post Idea