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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
3 1 1 3

DSS API issue - response has no data although client is getting 200 OK

Client is trying to download the

EOD Data Extraction For 0#CL+ , but client receives 200 OK but we cannot see any data through the link below

https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/RawExtractionResults('0x07021d41f71167e7')/$value

can you please check?

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.

Upvotes
Accepted
11.3k 25 8 13

Hi @Raghava.B S,

The ExtractRaw endpoint possibly can return 200 OK even there is no data generated. For example, there is no valid instrument in the request or no permission issue. Client can find more information in the Notes field of response.

Below is the sample.

{
    "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#RawExtractionResults/$entity",
    "JobId": "0x070314452a716a04",
    "Notes": [
        "Extraction Services Version...Processing completed successfully at 09/03/2020 17:54:17\nExtraction finished at 09/03/2020 10:54:17 UTC, with servers: x02q13\nInstrument <RIC,FCX8^0> expanded to 0 RICS.\nReport suppressed because there are no instruments\n"
    ]
}


For further question, please provide the entire request and response sent/received in the client's application.

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 Thanks , Would ExtractWithNotes help instaead of ExtractRaw in most cases?

@Raghava.B S,

Sorry, I miss your comment. I understand that both ExtractWithNotes and ExtractRaw endpoints provide the same data but different format. I think changing the endpoint could not help.

Upvotes
1 0 0 0

Hello,

I'm having the same isssue, no data return with ExtractRaw end point.
Changing to ExtractWithNotes returns correct data.

I've followed the example from the Tutorial: https://developers.refinitiv.com/en/api-catalog/datascope-select/datascope-select-rest-api/tutorials?content=51922&type=learning_material_item

Everything works fine, but I'm not getting any content on last step (compressed or not).

I'm using a test account (9025720), maybe this is the issue?

https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractRaw
  
                
200 0x071a954e53a193bb
object(stdClass)#2 (3) { ["@odata.context"]=> string(89) "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#RawExtractionResults/$entity" ["JobId"]=> string(18) "0x071a954e53a193bb" ["Notes"]=> array(1) { [0]=> string(1569) "Extraction Services Version 14.0.41655 (18a2bf29b489), Built Apr 13 2020 21:47:36 Processing started at 05/21/2020 10:23:13. User ID: 9025720 Extraction ID: 2000000150551010 Schedule: 0x071a954e53a193bb (ID = 0x0000000000000000) Input List (2 items): (ID = 0x071a954e53a193bb) Created: 05/21/2020 10:23:13 Last Modified: 05/21/2020 10:23:13 Report Template (19 fields): _OnD_0x071a954e53a193bb (ID = 0x071a954e53d193bb) Created: 05/21/2020 10:23:12 Last Modified: 05/21/2020 10:23:12 Schedule dispatched via message queue (0x071a954e53a193bb) Schedule Time: 05/21/2020 10:23:13 Timeseries Date Range: 05/18/2020 to 05/20/2020 Processing completed successfully at 05/21/2020 10:23:14, taking 0.115 Secs. Extraction finished at 05/21/2020 07:23:14 UTC, with servers: x02q16, ETS (0.0 secs), QSHC11 (0.0 secs), QSSHA1 (0.0 secs) Usage Summary for User 9025720, Client 111306, Template Type Price History Base Usage Instrument Instrument Terms Price Count Type Subtype Source Source ------- ----------------------------------- ---------------------------- -------------- ---------------------------------------- 2 Equities N/A N/A ------- 2 Total instruments charged. 0 Instruments with no reported data. ======= 2 Instruments in the input list. No TRPS complex usage to report -- 2 Instruments in the input list had no reported data. " } } https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/RawExtractionResults('0x071a954e53a193bb')
200 object(stdClass)#3 (2) { ["@odata.context"]=> string(89) "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#RawExtractionResults/$entity" ["JobId"]=> string(18) "0x071a954e53a193bb" } Page loaded in 4.093776 seconds
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.

Hi @catalin.prescure,

I have not seen issue in the extraction Notes. Have you call the RawExtractionResults endpoint with /$value to get data? For example:

GET
https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/RawExtractionResults('0x071a954e53a193bb')/$value 
catalin.prescure avatar image catalin.prescure veerapath.rungruengrayubkul

Yes, it seems that is no issue, but no data returned.

I'm using php/curl

curl_setopt($this->curl, CURLOPT_URL, "

https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/RawExtractionResults('0x071a954e53a193bb')

");

@catalin.prescure,

The "/$value" is a part of request URL. Could you try the following code?

curl_setopt($this->curl, CURLOPT_URL, "https://hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/RawExtractionResults('0x071a954e53a193bb')/%24value
");
Show more comments
Click below to post an Idea Post Idea