question

Upvotes
Accepted
1 0 0 1

Unable to get any data from Tick Histroy Raw Extraction

Hi,

I am trying to get data by hitting the Tick History Raw Extraction API, but I don't get the correct response.

This is my request:

{'ExtractionRequest': 
           {'@odata.type': 
                 '#DataScope.Select.Api.Extractions.ExtractionRequests.TickHistoryRawExtractionRequest', 
           'IdentifierList': 
                    {'@odata.type': '#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList', 'InstrumentIdentifiers': 
                       [{'Identifier': 'ICBK.NS', 'IdentifierType': 'Ric'}], 'ValidationOptions': {'AllowHistoricalInstruments': True}}, 'Condition': {'ReportDateRangeType': 'Range', 'QueryStartDate': '2017-06-16T00:00:00', 'QueryEndDate': '2017-06-17T00:00:00', 'ExtractBy': 'Ric', 'SortBy': 'SingleByRic', 'DomainCode': 'MarketByOrder', 'DisplaySourceRIC': True}}}. 


And this is my response:

{'@odata.context': 'https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#RawExtractionResults/$entity', 'JobId': '0x083ab0095f334b5d', 'Notes': ['Extraction Services Version 16.2.44415 (c4ac5f5e8fb7), Built Oct 12 2022 22:13:16\nUser ID: 9019578\nExtraction ID: 2000000469372014\nCorrelation ID: CiD/9019578/AAAAAA.083ab0095f234b5d/RA\nSchedule: 0x083ab0095f334b5d (ID = 0x0000000000000000)\nInput List (1 items):  (ID = 0x083ab0095f334b5d) Created: 11/02/2022 15:53:49 Last Modified: 11/02/2022 15:53:49\nReport Template: _OnD_0x083ab0095f334b5d (ID = 0x083ab0095f434b5d) Created: 11/02/2022 15:53:48 Last Modified: 11/02/2022 15:53:48\nSchedule dispatched via message queue (0x083ab0095f334b5d)\nSchedule Time: 11/02/2022 15:53:48\nProcessing started at 11/02/2022 15:53:48\nProcessing completed successfully at 11/02/2022 15:53:49\nExtraction finished at 11/02/2022 15:53:49 UTC, with servers: x03q11\nInstrument <RIC,ICBK.NS> expanded to 0 RICS.\n\nReport suppressed because there are no instruments\n']}

I am using exactly the same identifier as the example from the Refinitiv API guide. Also, here I would expect a 202 status call, which would then give me the ability to call the Refinitiv API with jobId to fetch the data, once it's ready. What I am doing wrong here?


Cheers,

Ivan

python#technologypython api#contenttrth-rest-apimarket-feed
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
32.2k 39 11 19

Hello @ivan.lovrencic ,

Not all instruments and not at all times are available in MarketByOrder domain. To verify that this is the cause, try switching to:

 "DomainCode": "MarketPrice",

To identify the content that you require, please contact Refinitiv content support directly, for help and advice on this specific content.

icon clock
10 |1500

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

It works now! Thank you for the help @zoya faberov!