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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
11 1 3 3

DSS API Query

We are now getting a record back for the CNY rate, but the record does not contain the “Closing Price” value. Please see below:

Response:

<ExtractResult>

<RowCount>23</RowCount>

<Columns>

<ExtractionColumn>

<Name>RIC</Name>

<DataType>String</DataType>

<Values>

<string>AUD3MFSR=</string>

<string>AUPRIME=</string>

<string>CAD3MFSR=</string>

<string>CAPRIME=</string>

<string>CHF3MFSR=</string>

<string>CHPRIME=</string>

<string>DKK3MFSR=</string>

<string>ECBMRO=</string>

<string>EUR3MFSR=</string>

<string>GBP3MFSR=</string>

<string>GBPRIME=</string>

<string>HKPR=</string>

<string>JPPRIME=</string>

<string>JPY3MFSR=</string>

<string>NOUTL=</string>

<string>NZD3MFSR=</string>

<string>NZPRIME=</string>

<string>SEK3MFSR=</string>

<string>SERP=</string>

<string>SHICNY3MD=</string>

<string>USD3MFSR=</string>

<string>USPRIME=</string>

<string>ZAPRIME=</string>

</Values>

</ExtractionColumn>

<ExtractionColumn>

<Name>Trade Date</Name>

<DataType>DateOnly</DataType>

<Values>

<empty />

<date>2017-09-29</date>

<empty />

<date>2017-09-29</date>

<date>2017-09-29</date>

<date>2017-09-29</date>

<empty />

<date>2017-09-29</date>

<date>2017-09-29</date>

<date>2017-09-29</date>

<empty />

<date>2017-09-29</date>

<date>2017-09-29</date>

<date>2017-09-29</date>

<date>2017-10-02</date>

<empty />

<date>2017-09-29</date>

<empty />

<date>2017-09-29</date>

<date>2017-10-02</date>

<date>2017-09-29</date>

<date>2017-09-29</date>

<date>2017-09-29</date>

</Values>

</ExtractionColumn>

<ExtractionColumn>

<Name>Close Price</Name>

<DataType>Double</DataType>

<Values>

<empty />

<double>1.5</double>

<empty />

<double>3.2</double>

<double>-0.726</double>

<double>0.5</double>

<empty />

<double>0</double>

<double>-0.37943</double>

<double>0.335</double>

<empty />

<double>5</double>

<double>1</double>

<double>-0.05121</double>

<double>1.5</double>

<empty />

<double>1.75</double>

<empty />

<double>-0.5</double>

<empty />

<double>1.33389</double>

<double>4.25</double>

<double>10.25</double>

</Values>

</ExtractionColumn>

</Columns>

You will notice that for all other instruments, the request returns a value for the 29th however SHICNY3MD= is looking for a value for today?

Do they need to adjust their API request?

dss-rest-apidatascope-selectdss
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.

1 Answer

Upvotes
Accepted
13.7k 26 8 12

@preshan.govinder

For data content query like this one, the best and speediest way to receive an answer is to open a content-related enquiry via My Account or to call the Thomson Reuters Help Desk directly.

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.

Click below to post an Idea Post Idea