question

Upvotes
Accepted
7 2 2 2

"Historical reference request" is not returning any data

I'm trying to do an historical reference request but I'm getting nothing returned. This is happening with every product code I'm trying. It stopped working yesterday. I'm the only one running the extraction, so it's not because there's more than one request being made at a time. My request code is below. Just for reference, the Product ric I'm using at the moment is LCOmmV1.


requestHeaders={

"Prefer":"respond-async",

"Content-Type":"application/json",

"Authorization": "token " + token

}

HistRefUrl = 'https://selectapi.datascope.refinitiv.com/RestApi/v1//Extractions/ExtractWithNotes'

requestBody={

"ExtractionRequest": {

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

"ContentFieldNames": [

"RIC",

"Start date",

"Change Date",

"Expiration Date"

],

"IdentifierList": {

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

"InstrumentIdentifiers": [

{

"Identifier": "LCOmmV1",

"IdentifierType": "Ric"

}

],

"ValidationOptions": {

"AllowHistoricalInstruments": 'true'

},

"UseUserPreferencesForValidationOptions": 'false'

},

"Condition": {

"StartDate": "2015-01-01T00:00:00.000Z",

"EndDate": todaysDate + "T" + "00:00:00.000Z"

}

}

}

tick-history-rest-api
icon clock
10 |1500

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

Upvotes
Accepted
7 2 2 2

Thanks for your reply Zoya. I think the problem has been that I've not been re-polling the response from the server. It seems to be working now.

icon clock
10 |1500

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

Upvote
23k 22 9 14

Hello @sanchezTJUK .

Try:

{
    "ExtractionRequest": {
        "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.HistoricalReferenceExtractionRequest",
"ContentFieldNames": [
    "RIC",
    "Start date",
    "Change Date",
    "Expiration Date"
],
"IdentifierList": {
    "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
    {"Identifier": "LCOmmV1", "IdentifierType": "Ric" }
],
    "ValidationOptions": {
        "AllowHistoricalInstruments": true
    },
    "UseUserPreferencesForValidationOptions": false
    },
    "Condition": {
        "StartDate": "2000-01-01T00:00:00.000Z",
        "EndDate": "2021-08-25T00:00:00.000Z"
    }

}

}

From my testing, this results in:

RIC,Start date,Change Date,Expiration Date,User Defined Identifier,User Defined Identifier2,User Defined Identifier3,User Defined Identifier4,User Defined Identifier5,User Defined Identifier6
LCOmmV1,,2021/05/02,2021/08/31,,,,,,RIC|LCOmmV


icon clock
10 |1500

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

Click below to post an Idea Post Idea