What is the force Trigger API

Sohail_Khokhawala
Sohail_Khokhawala Newcomer
edited February 21 in DSS

Does anyone know the force trigger API for DSS?

Thanks

Sohail Khokhawala

Tagged:

Best Answer

Answers

  • Gurpreet
    Gurpreet admin

    Hello @Sohail_Khokhawala

    I have not heard that term. Could it be referring to the On Demand Extractions, vs the Scheduled Extractions.

  • Sohail_Khokhawala
    Sohail_Khokhawala Newcomer

    Yes. What I want is the instrument list that we have created i need to force execute the data extraction using that list.

  • Gurpreet
    Gurpreet admin
    https://community.developers.refinitiv.com/discussion/comment/124162#Comment_124162

    See the On Demand EOD extraction tutorial on the dev portal. Same principles can be applied to other extraction types as well. These examples are also available in the Postman collection in the downloads tab.

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    @Sohail_Khokhawala

    If you know its InstrumentListId, you can use it in the on-demand extraction request. 

    {
    
    "ExtractionRequest": {
    
        "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
    
        "ContentFieldNames": [
    
            "Issuer Name",
    
            "Domicile",
    
            "Issuer OrgID",
    
            "GICS Industry Code",
    
            "Security Description",
    
            "Currency Code",
    
            "PILC",
    
            "Exchange Code",
    
            "Asset Type",
    
            "Asset SubType",
    
            "Asset Category",
    
            "Is Asset Active Flag",
    
            "Round Lot Size",
    
            "File Code",
    
            "Tag",
    
            "Underlying RIC",
    
            "Underlying Security Description",
    
            "RIC",
    
            "Ticker"
    
        ],
          "IdentifierList": {
    
            "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentListIdentifierList",
    
            "InstrumentListId": "0x08a2eb09d0e91cd7"
    
        }
    
    }
    
}

    If you know an instrument name, you can use the following request to get its InstrumentId.

    GET https://selectapi.datascope.refinitiv.com/RestApi/v1//Extractions/InstrumentListGetByName(ListName='EmbargoedTestInstrumentList')

    The output is:

    {
    
    "@odata.context": "https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#InstrumentLists/$entity",
        "ListId": "0x08a2eb09d0e91cd7",
    
    "Name": "EmbargoedTestInstrumentList",
    
    "Count": 5,
    
    "Created": "2023-09-22T03:25:51.383Z",
    
    "Modified": "2023-09-22T03:25:59.553Z"
    
}
  • Sohail_Khokhawala
    Sohail_Khokhawala Newcomer

    Can you paste the API here for demand i was able to get the Instrument ID

  • Jirapongse
    Jirapongse ✭✭✭✭✭

    @Sohail_Khokhawala

    You can refer to the Postman example or tutorials.

    In the request message, you need to change the IdentifierList to the following. 

    {
…
 "IdentifierList": {

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

    
            "InstrumentListId": "0x08a2eb09d0e91cd7"

    
        },
…
  • Sohail_Khokhawala
    Sohail_Khokhawala Newcomer

    My payload is below

    {
    "ExtractionRequest": {
    "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.EndOfDayPricingExtractionRequest",
    "ContentFieldNames": [
    "Trade Date",
    "Universal Close Price",
    "Universal Bid Ask Date",
    "Security Description"
    ],
    "IdentifierList": {
    "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
    "InstrumentListId": "0x08a2eb09d0e91cd7"
    },
    "Condition": null
    }
    }

    but getting error

    {    "error": {        "message": "Malformed request payload: For the property name \"InstrumentListId\" in the JSON request the value could not be parsed successfully. Please check the casing or spelling of the property."    }}

    Can you help whats wrong with with my payload

Categories