Return column name for "DATE_TIME" inconsistent getting historic prices

When getting historic prices from the RDP API and I include the field "DATE_TIME" in my request sometimes I get back "DATE" in the column names and sometime "DATE_TIME". I assume this is because of intraday vs day and greater intervals but the inconsistency is not great when parsing the data:
Best Answer
-
The date format is how the backend service supplies the data and as you observed, is dependent on whether you are requesting for interday vs intraday. Clearly, the intraday you will need the time element. However, there was a design decision to not include the time element within interday as this would be redundant. That being said, you will need account for this when you are processing the response.
0
Answers
-
hi @gordon.konheiser ,
If the endpoints you're using are /data/historical-pricing/v1/views/interday-summaries and /data/historical-pricing/v1/views/intraday-summaries/ . The difference in the responses are because the data are retrieved from the different endpoints (interday, intraday).
If not, could you please provide the endpoint and request body used for further investigation?
0 -
hi @gordon.konheiser ,
are you using RD library or RDP libraries to retrieve this data? if so, could you please provide the library used and its version, please?
0 -
Here you go :
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 中文论坛