I tired to fetch all the User Preference setting validation options from the link https://selectapi.datascope.refinitiv.com/RestApi/v1/Users/UserPreferences(9015484). However, I couldn't find anything related to "Exclude Null Codes For Universal Close Price".
For a deeper look into our DataScope Select REST API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials
1
●0 ●0 ●1
What is the Validation option to be used for "Exclude Null Codes For Universal Close Price" in DSS REST API EOD Template?
24.3k
●62 ●15 ●21
Hi @sowmya.vt,
Please attach the complete URL and the request message that you are sending.
This is the correct JSON request format:
{
"UserPreferenceId": *****USER_ID****,
"ContentSettings": {
"FiGlobalSnapshotPricesForPpxUs3Pm4PmEnabled": false,
"IgnoreFinr": false,
"ImportOfDuplicateInstrumentsAllowed": false,
"ImportOfDuplicateLegalEntitiesAllowed": false,
"ImportOfExpiredInstrumentsAllowed": false,
"ImportOfOpenAccessRicsAllowed": true,
"ImportOfUnsupportedInstrumentAllowed": false,
"IncludeDelistedRicsForFileCodeExpansion": false,
"PartialEmbargoedReportsEnabled": false,
"IntermediateReportsEnabled": false,
"DeltaReportsEnabled": false,
"ReturnLastTradingDayPriceOnNonTradingDays": false,
"ReturnNullCodeValuesInExtractionPricingFields": false,
"RicMaintenanceReportsEnabled": false,
"PreferredIdentifier": "RIC",
"UseDseOverLipper": false,
"DefaultToUsExchange": false,
"UseConsolidatedQuoteSourceForUsa": false,
"UseConsolidatedQuoteSourceForCanada": false,
"AllowHistoricalInstruments": false,
"UseDebtOverEquity": false
},
"UiSettings": {
"LongTimeFormatString": "HH:mm:ss",
"ShortTimeFormatString": "HH:mm",
"LongDateFormatString": "MMMM dd, yyyy",
"ShortDateFormatString": "dd/MM/yyyy",
"DateSeparator": "-",
"TimeSeparator": ":",
"DecimalSeparator": ",",
"GroupSeparator": ",",
"TimeZone": "Eastern Standard Time"
}
}
You can also set this preference in the DSS GUI - under the User Preferences:
315
●2 ●2 ●4
Hi @sowmya.vt
All options can be found in the API Reference Tree: selectapi.datascope.refinitiv.com/RestApi.Help/Context/Entity?ctx=Users&ent=UserPreference
I believe the option you want is: ReturnLastTradingDayPriceOnNonTradingDays
Best regards,
Gareth
1
●0 ●0 ●1
Hi Gareth,
Thank you for looking into the request.
When i use "ReturnLastTradingDayPriceOnNonTradingDays": false in validation condition, i get below error message. Kindly advise.
{
"error": {
"message": "Malformed request payload: For the property name \"ReturnLastTradingDayPriceOnNonTradingDays\" in the JSON request the value could not be parsed successfully. Please check the casing or spelling of the property."
}
}
