Get the exchange rates list by Instrument List Id

Unknown
Unknown
in DSS

Hi Support Team,

On the DSS GUI, I can open my instrument, get any CSV file (for example, the latest one) from the history, parse it and get exchange rates.

Could you please clarify how can I get the same data by API call?

I'm trying to use the following request:

https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractRaw

{
    "ExtractionRequest":{
        "@odata.type":"#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.IntradayPricingExtractionRequest",
        "ContentFieldNames":[
            "Currency Code",
            "Base Currency Code",
            "Mid Price",
            "Price Decimals",
            "Trade Date",
            "Trade Time",
            "Last Update Time",
            "Instrument Snap Time",
            "Security Description"
        ],
        "IdentifierList":{
            "@odata.type":"#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentListIdentifierList",
            "InstrumentListId":"0x0717b0b53c418b55"
        },
        "Condition":{
            "ScalableCurrency":"true"
        }
    }
}


Thanks in advance.

Tagged:

Best Answer

  • Unknown
    Unknown
    Answer ✓

    Hi @veerapath.rungruengrayubkul,

    I have managed to make it work by using the following request and the body.

    URL: https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractWithNotes 

    {
        "ExtractionRequest": {
            "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.IntradayPricingExtractionRequest",
            "ContentFieldNames": [
                "Currency Code",
                "Base Currency Code",
                "Mid Price",
                "Price Decimals",
                "Trade Date",
                "Trade Time",
                "Last Update Time",
                "Instrument Snap Time",
                "Security Description"
            ],
            "IdentifierList": {
                "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentListIdentifierList",
                "InstrumentListId":"0x0000000000000000"
            },
            "Condition": {
                "ScalableCurrency": "true"
            }
        }
    }

Answers

Categories