Expirated Date in REST API

Options
Carlos.solano
Carlos.solano Newcomer
edited November 2024 in DSS

Hi,

We are trying to export via API the formula we currently export via Excel from Eikon ((@TR(G$3:BO$3;"EXPIR_DATE";"CH=Fd RH=IN")) in order to get the ExpirateDate.

Could you please help us to know how we can get this information through REST API? As you can see in the attached file, we get as NULL this field.

Example ExpirationDate NULL.pdf

Tagged:

Best Answer

  • zoya faberov
    zoya faberov ✭✭✭✭✭
    Answer ✓

    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.



Answers

  • zoya faberov
    zoya faberov ✭✭✭✭✭

    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,

  • I'm sorry! The usser we are testing with is 9027518.

    Thank you!