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
Best Answer
-
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.
0
Answers
-
Hi,
Thanks for checking.
When I do this,
@{"@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.
0 -
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
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.
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 689 Datastream
- 1.4K DSS
- 625 Eikon COM
- 5.2K Eikon Data APIs
- 11 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 255 ETA
- 558 WebSocket API
- 39 FX Venues
- 15 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 277 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 23 RDMS
- 1.9K Refinitiv Data Platform
- 695 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 106 UPA
- 194 TREP Infrastructure
- 229 TRKD
- 918 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 93 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛