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:

imageimage001.png

Query API: https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractWithNotes

Results:

image002-2.png

Best Answer

  • Gurpreet
    Gurpreet admin
    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.

Answers