Expirated Date in REST API

Hello @Carlos.solano ,

From my testing, requesting one of these instruments via EOD template returns result with Expiration date that is not populated. Please also see this previous discussion thread for a relevant discussion of the same, this may have to do with the instrument type being requested.

I find, that with Terms and Conditions request type:

{{protocol}}{{host}}{{api}}Extractions/ExtractWithNotes
{
    "ExtractionRequest": {
        "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
        "ContentFieldNames": [
           "RIC", "CUSIP", "ISIN", "SEDOL", "Issuer OrgID", "Currency Code","Expiration Date","Issuer PermID", "Maturity Date",
"Underlying Contract Expiry Date"
        ],
        "IdentifierList": {
            "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [

                 { "Identifier": "TFMBMc1", "IdentifierType": "Ric", "Source":"*" }

            ]
        }
    }
}

I see in the results "Underlying Contract Expiry Date" that appears to be the expiry date that you are looking for:

{
    "@odata.context": "https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#DataScope.Select.Api.Extractions.ExtractionRequests.ExtractionResult",
    "Contents": [
        {
            "IdentifierType": "Ric",
            "Identifier": "TFMBMc1",
            "RIC": "TFMBMc1",
            "CUSIP": null,
            "ISIN": null,
            "SEDOL": null,
            "Issuer OrgID": null,
            "Currency Code": "EUR",
            "Expiration Date": null,
            "Issuer PermID": null,
            "Maturity Date": null,
"Underlying Contract Expiry Date": "2022-06-29"
        }
    ],
...

However, to verify if this is the optimal field to request, or there is another recommended approach to requesting the content that you are interested in, suggest to contact Refinitiv content experts directly, via Refinitiv Helpdesk Online -> Content -> DSS

Hope that this information is of help