Get the exchange rates list by Instrument List Id

unknown

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.

unknown

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"
        }
    }
}