Hello @Carlos.solano ,

I suggest to contact Refinitiv content support directly, to help verify if the relevant contact can be requested with permissions that you have in place, via Refinitiv Helpdesk Online -> Help with content.

There can be another way of requesting the same information, that content experts for the product will be able to confirm.

However, if it is not available, please contact your Refinitiv account team, for help with permissions.

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

Hi, @zoya faberov

Thanks for your answer!

As you said, It looks like the "Underlying Contract Expiry Date" is the information we're looking for, however, we don't have permission to export this field.

Please, could you give us access to the "TermsAndConditionsExtractionRequest" template in order to see this field?

Thanks in advantage!

Regardss,