API issue - response has no data although client is getting 200 OK
in DSS
I'm trying to download data for EURUSD, but I get no data my query are:
requestUrl = 'https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractRaw'
requestBody = {
"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TickHistoryTimeAndSalesExtractionRequest",
"ContentFieldNames": [
"Trade - Price",
"Trade - Volume",
"Trade - Exchange Time"
],
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{ "Identifier": "EUR=", "IdentifierType": "Ric" }
]
},
"Condition": {
"MessageTimeStampIn": "GmtUtc",
"ApplyCorrectionsAndCancellations": False,
"ReportDateRangeType": "Range",
"QueryStartDate": "2015-09-29T00:00:00.000Z",
"QueryEndDate": "2015-09-29T12:00:00.000Z",
"DisplaySourceRIC": True
}
}
}
after 200 at Location a do the get at:
requestUrl = f"https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/RawExtractionResults('{job_id}')/$value"
with job_id = JobId
but a get no row just header
same thing when I do:
requestUrl = 'https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractRaw'
requestBody = {
"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TickHistoryMarketDepthExtractionRequest",
"ContentFieldNames": [
"Ask Price",
"Ask Size",
"Bid Price",
"Bid Size",
"Number of Buyers",
"Number of Sellers",
],
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{ "Identifier": "EUR=", "IdentifierType": "Ric" }
]
},
"Condition": {
"View": "NormalizedLL2",
"NumberOfLevels": 10,
"MessageTimeStampIn": "GmtUtc",
"ReportDateRangeType": "Range",
"QueryStartDate": "2016-09-29T09:00:00.000Z",
"QueryEndDate": "2016-09-29T12:00:00.000Z",
"DisplaySourceRIC": True
}
}
}
what I'm doing wrong?
Tagged:
0
Best Answer
-
You need to check the notes. You get the notes in the body of an HTTP response when an HTTP response is 200.
I used the same request and got the following notes.
{
...
"Notes": [
"Extraction Services Version 15.2.42847 (ee8959b2766d), Built Oct 19 2021 09:36:41\nUser ID: 9008895\nExtraction ID: 2000000329933071\nCorrelation ID: CiD/9008895/AAAAAA.07c9c2101d2d5019/RA\nSchedule: 0x07c9c2101d3d5019 (ID = 0x0000000000000000)\nInput List (1 items): (ID = 0x07c9c2101d3d5019) Created: 11/16/2021 10:08:09 Last Modified: 11/16/2021 10:08:09\nReport Template (6 fields): _OnD_0x07c9c2101d3d5019 (ID = 0x07c9c2101d6d5019) Created: 11/16/2021 10:07:28 Last Modified: 11/16/2021 10:07:28\nSchedule dispatched via message queue (0x07c9c2101d3d5019)\nSchedule Time: 11/16/2021 10:07:32\nProcessing started at 11/16/2021 10:07:32\nProcessing completed successfully at 11/16/2021 10:08:09\nExtraction finished at 11/16/2021 10:08:09 UTC, with servers: x03q13\nInstrument <RIC,EUR=> expanded to 1 RIC: EUR=.\nTotal instruments after instrument expansion = 1\n\n(RIC,EUR=,RCT) row suppressed for lack of 'Distribution Rights - Tick History never allowed for PE 0' permission.\nReport suppressed because no instruments are permitted\n"
]
}It shows that "... row suppressed for lack of 'Distribution Rights - Tick History never allowed for PE 0' permission".
1
Answers
-
there was a problem with the refinitiv ecosystem
Refinitiv Tick History Custom Extractions were disrupted for customers globally between 08:00 and 12:14 GMT owing to an issue at Refinitiv. Customers were getting an error message as row suppressed for lack of Distribution Rights - Tick History never allowed for PE permission or Report suppressed because no instruments are permitted. Service was restored at 12:14 GMT on 16-Nov-21 after Refinitiv resolved the issue. Affected Platforms: GUI (Custom) and REST API
now I have a new message:
Instrument <RIC,EUR=> expanded to 1 RIC: EUR=.\nTotal instruments after instrument expansion = 1\n\nManifest: #RIC,Domain,Start,End,Status,Count\nManifest: EUR=,Market Price,,,Inactive,0\n'
0
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛