Not getting any content when using ExtractRaw api for Tick history time and sales data

Hi All,
I am trying to use selectapi to get on demand tick history time and sales data but in the api response i only get the notes not the actual content. This is my request payload to ExtractRaw post endpoint
{
"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TickHistoryTimeAndSalesExtractionRequest",
"ContentFieldNames": [
"Trade - Ask Price",
"Trade - Bid Price",
"Trade - Ask Size",
"Trade - Bid Size",
"Trade - Exchange Time",
"Trade - Volume",
"Trade - Price"
],
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{ "Identifier": "IBM.N", "IdentifierType": "Ric" }
],
"ValidationOptions": null,
"UseUserPreferencesForValidationOptions": false
},
"Condition": {
"QueryStartDate": "2021-06-01T00:00:00.000Z",
"QueryEndDate": "2021-06-02T00:00:00.000Z",
"MessageTimeStampIn": "GmtUtc",
"ApplyCorrectionsAndCancellations": false,
"ReportDateRangeType": "Range",
"DisplaySourceRIC": false
}
}
}
and this is the response that i get as response
{
"@odata.context": "https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#RawExtractionResults/$entity",
"JobId": "0x0794b634781cae59",
"Notes": [
"Extraction Services Version 14.5.42294 (xxx), Built Apr 8 2021 13:43:46\\nUser ID: 9028436\\nExtraction ID: xxx\\nSchedule: xxx (ID = xxx)\\nInput List (1 items): (ID = xxx) Created: 06/04/2021 10:44:29 Last Modified: 06/04/2021 10:44:29\\nReport Template (1 fields): xxx (ID = xxx) Created: 06/04/2021 10:42:54 Last Modified: 06/04/2021 10:42:54\\nSchedule dispatched via message queue (xxx), Data source identifier (xxx)\\nSchedule Time: 06/04/2021 10:42:54\\nProcessing started at 06/04/2021 10:42:54\\nProcessing completed successfully at 06/04/2021 10:44:29\\nExtraction finished at 06/04/2021 14:44:29 UTC, with servers: xxx, TRTH (83.786 secs)\\nInstrument <RIC,IBM.N> expanded to 1 RIC: IBM.N.\\nTotal instruments after instrument expansion = 1\\nQuota Message: INFO: Tick History Cash Quota Count Before Extraction: 99999; Instruments Approved for Extraction: 1; Tick History Cash Quota Count After Extraction: 99999, 94.5213333333333% of Limit; Tick History Cash Quota Limit: 75000\\nManifest: #RIC,Domain,Start,End,Status,Count\\nManifest: IBM.N,Market Price,2016-11-21T14:30:09.874048747Z,2016-11-22T21:05:12.598883333Z,Active,86928\\n"
]
}
am i missing something in the request payload ?
Best Answer
-
Hello @gurbakhshish.singh,
What if you check status of this jobId:
{{protocol}}{{host}}{{api}}Extractions/ExtractRawResult(ExtractionId='{{jobId}}')
what status result do you get?
If the status is 200, what if you request result/get data:
{{protocol}}{{host}}{{api}}Extractions/RawExtractionResults('{{jobId}}')/$value
Please let @Gurpreet and me know how this works on your side?
0
Answers
-
I ran your exact query and was able to get data. Looking at your extraction notes, I notice this -
Quota Message: INFO: Tick History Cash Quota Count Before Extraction: 99999; Instruments Approved for Extraction: 1; Tick History Cash Quota Count After Extraction: 99999, 94.5213333333333% of Limit; Tick History Cash Quota Limit: 75000\
Manifest: #RIC,Domain,Start,End,Status,CountSeems like you have reached the limit of extraction quota allowed. Please contact your Refinitiv account manager to check your subscription tier and possibly increase if required.
0 -
@Gurpreet i replaced the actual numbers in the notes before posting the question, the actual numbers are as following
INFO: Tick History Cash Quota Count Before Extraction: 70891; Instruments Approved for Extraction: 1; Tick History Cash Quota Count After Extraction: 70891, 94.5213333333333% of Limit; Tick History Cash Quota Limit: 75000
0 -
i am able to get the data from RawExtractionResults but not with polling location in headers of ExtractRaw response
0 -
Hello @gurbakhshish.singh,
Would be helpful to better understand what you see.
What result/status do you get for status check of your jobId:
{{protocol}}{{host}}{{api}}Extractions/ExtractRawResult(ExtractionId='{{jobId}}')
200? 202? 404? Other?
Thanks
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
- 690 Datastream
- 1.4K DSS
- 629 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
- 559 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
- 25 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 279 Open PermID
- 45 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 23 RDMS
- 2K Refinitiv Data Platform
- 716 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
- 95 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛