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?
Best Answer
-
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.
0
Answers
-
@veerapath.rungruengrayubkul Thanks , Would ExtractWithNotes help instaead of ExtractRaw in most cases?
0 -
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.
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/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/ExtractRaw200 0x071a954e53a193bbobject(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 seconds0 -
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')/$value0 -
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')
");
0 -
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')/$value
");0 -
Wau! Never thought of that. Excelent!
0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 690 Datastream
- 1.4K DSS
- 629 Eikon COM
- 5.2K Eikon Data APIs
- 11 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 255 ETA
- 559 WebSocket API
- 39 FX Venues
- 15 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 24 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 279 Open PermID
- 45 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 23 RDMS
- 2K Refinitiv Data Platform
- 714 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 106 UPA
- 194 TREP Infrastructure
- 229 TRKD
- 918 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 95 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛