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?
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.
@veerapath.rungruengrayubkul Thanks , Would ExtractWithNotes help instaead of ExtractRaw in most cases?
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.
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/datascope-select-dss/datascope-select-rest-api/learning?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
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
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')
");