For a deeper look into our DataScope Select REST API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
23 0 1 2

Get the exchange rates list by Instrument List Id

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.

dss-rest-apidssdatascope-selectapiricsforex
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hi @Sergey,

Can you share the screenshot of data on DSS GUI including the steps to get the exchange Rate?

Hi @veerapath.rungruengrayubkul,

I have managed to make it work by changing the URL to https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractWithNotes

The ticket may be closed.

Thank you!

1 Answer

Upvotes
Accepted
23 0 1 2

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"
        }
    }
}
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@Sergey,

Thank you for the update and sharing the solution. Glad to know that the issue is resolved.

Thanks,

Veerapath