Hi, currently i am querying the API using ExtractRaw. This returns date format in 'YYYY/MM/DD' in...

...stead of the date format we wanted 'YYYY-MM-DD'. Is there any way we can extract information in the correct format?
Hi, currently i am querying the API using ExtractRaw. This returns date format in 'YYYY/MM/DD' instead of the date format we wanted 'YYYY-MM-DD'. Is there any way we can extract information in the correct format? The current date format in the account i am using is already in the correct date format 'YYYY-MM-DD'.
Is there any way to set the date format in the 1st Query API (ExtractRaw) to the format from the 2nd result (What I want is “2000-11-23” )
Body:
{
"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
"ContentFieldNames": [
"RIC",
"Asset Type",
"First Trade Date"
],
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{ "Identifier": "SGXL.SI", "IdentifierType": "Ric"}
]
}
}
}
Query API I used: https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractRaw
Results:
Query API: https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractWithNotes
Results:
Best Answer
-
Hi @Sushil.Purohit,
Unfortunately there is no means to specify a different date format in any of the Extraction requests. You should be able to convert this programmatically in your application though.
What I see is that ExtractRaw provides the raw data as it was captured, and the ExtractWithNotes does some minimal data processing like formatting the date value and fill in null for a blank value etc.
0
Answers
-
You can't specify the Date Format with on-demand extractions. However, you can specify the Date Format with schedule extractions.
For example, you can use the DSS Web GUI or REST API to create a TermsAndConditions report template that contains the "First Trade Date" field with the "yyyy-MM-dd" format.
The REST API request looks like this:
{
"ShowColumnHeaders": true,
"Name": "TermsAndConditions1",
"Headers": [],
"Trailers": [],
"ContentFields": [
{
"FieldName": "RIC"
},
{
"FieldName": "Asset Type"
},
{
"FieldName": "First Trade Date",
"Format": {
"@odata.type":"ContentFieldDateFormat",
"DateFormat": "yyyy-MM-dd"
}
}
],
"Condition": null
}Then, you can use an immediate schedule extraction to extract the data. The output looks like this:
For more information, you can refer to the REST API Tutorial 10: GUI control calls: immediate extract tutorial on the Developers Portal Website.
0 -
Thanks0
-
Thanks0
Categories
- All Categories
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 33 Data Model Discovery
- 682 Datastream
- 1.4K DSS
- 613 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 248 ETA
- 552 WebSocket API
- 37 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.8K Refinitiv Data Platform
- 622 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
- 26 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 191 TREP Infrastructure
- 228 TRKD
- 915 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 83 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛