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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
sergey_deprecated_0 avatar image
23 ●0 ●0 ●1

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-apidatascope-selectdssapiricsforex
icon clock
10 |1500

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

veerapath.rungruengrayubkul avatar image veerapath.rungruengrayubkul

Hi @Sergey,

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

sergey_deprecated_0 avatar image sergey_deprecated_0 veerapath.rungruengrayubkul

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
sergey_deprecated_0 avatar image
23 ●0 ●0 ●1

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 5.0 MiB each and 10.0 MiB total.

veerapath.rungruengrayubkul avatar image veerapath.rungruengrayubkul
@Sergey,

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

Thanks,

Veerapath

Click below to post an Idea Post Idea