Get the exchange rates list by Instrument List Id

Question

Question by sergey_deprecated_0 · May 23, 2020 at 10:14 PM · dss-rest-api datascope-select dss api rics forex

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.

0 Show 2

10 |1500 characters needed characters left characters exceeded

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

REFINITIV

veerapath.rungruengrayubkul ♦♦ · May 25, 2020 at 08:11 AM 0

Share

Hi @Sergey,

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

sergey_deprecated_0 veerapath.rungruengrayubkul ♦♦ · May 25, 2020 at 09:04 AM 0

Share

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!

Answer 1 · 2020-05-25T09:02:56Z

Best Answer

Answer by sergey_deprecated_0 · May 25, 2020 at 09:02 AM

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

0 Show 1 · Share

10 |1500 characters needed characters left characters exceeded

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

REFINITIV

veerapath.rungruengrayubkul ♦♦ · May 25, 2020 at 10:40 AM 0

Share

@Sergey,

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

Thanks,

Veerapath

Get the exchange rates list by Instrument List Id

1 Reply

Watch this question

Related Questions