question

Upvotes
Accepted
darshpatel avatar image
16 ●2 ●1 ●4

Identifier invalid in Tick Hist Raw template

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"

}

]

}

tick-history-rest-api
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

· Write an Answer
Upvotes
Accepted
Jirapongse avatar image
78.6k ●248 ●52 ●74

@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
        }
    }
}
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.

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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