Identifier invalid in Tick Hist Raw template

darshpatel

hello, i tried the below query on Postman and it gives me an error "All identifiers were invalid. No extraction performed." However if I use the same RIC (FGBLc2=CTD)on GUI, RTH raw template, it works

Sharing the query below:

{

"ExtractionRequest": {

"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TickHistoryRawExtractionRequest",

"IdentifierList": {

"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",

"InstrumentIdentifiers": [{

"Identifier": "FGBLc2=CTD",

"IdentifierType": "Ric"

}]

},

"Condition": {

"MessageTimeStampIn": "GmtUtc",

"ReportDateRangeType": "Range",

"QueryStartDate": "2022-01-24T00:00:00.000Z",

"QueryEndDate": "2022-01-24T23:59:59.000Z",

"ExtractBy": "Ric",

"SortBy": "SingleByRic",

"DomainCode": "MarketPrice",

"DisplaySourceRIC": true

}

}

}

Response was as below:

{

"@odata.context": "https://selectapi.datascope.refinitiv.com/restapi/v1/$metadata#RawExtractionResults/$entity",

"JobId": "0x07e6b2f7810d94d5",

"Notes": [

"All identifiers were invalid. No extraction performed."

],

"IdentifierValidationErrors": [

{

"Identifier": {

"@odata.type": "#DataScope.Select.Api.Content.InstrumentIdentifier",

"Identifier": "FGBLc2=CTD",

"IdentifierType": "Ric",

"Source": ""

},

"Message": "Not found"

}

]

}

Jirapongse

@darshpatel

You need to add the AllowHistoricalInstruments validation option in the request message, as shown below.

{
    "ExtractionRequest": {
        "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TickHistoryRawExtractionRequest",
        "IdentifierList": {
            "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
                {
                    "Identifier": "FGBLc2=CTD",
                    "IdentifierType": "Ric"
                }
            ],
            "ValidationOptions": {
                "AllowHistoricalInstruments": true
            }
        },
        "Condition": {
            "MessageTimeStampIn": "GmtUtc",
            "ReportDateRangeType": "Range",
            "QueryStartDate": "2022-01-24T00:00:00.000Z",
            "QueryEndDate": "2022-01-24T23:59:59.000Z",
            "ExtractBy": "Ric",
            "SortBy": "SingleByRic",
            "DomainCode": "MarketPrice",
            "DisplaySourceRIC": true
        }
    }
}

darshpatel

https://community.developers.refinitiv.com/discussion/comment/90528#Comment_90528

thank you so much @Jirapongse , this helps. please close the query (i cant see any option here apart from reply)