REST API GUI control calls: change dates range in historical template

pragazzini

Hi, I'm using REST API for GUI control calls. In particular, I’m performing a PUT call to change the “Condition” in a historical report template so that I can modify the dates range. The request is working without errors (result code 204), but after that I don't see any change in the template available in the GUI.

The Call is structured as follow:

1. Sending a PUT request to: https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ReportTemplates(‘template_id’)
2. Using the following json body:

• {

• "@odata .type":"#DataScope.Select.Api.Extractions.ReportTemplates.PriceHistoryReportTemplate",

• "ReportTemplateId":"template_id",

• "ShowColumnHeaders":false,

• "CompressionType":"None",

• "Name":"fake_template",

• "OutputFormat":"CommaSeparatedValues",

• "ReportFieldCount":4,

• "Delimiter":"None",

• "DeliveryType":"None",

• "Destination":"",

• "TemplateTypeCode":"ET2",

• "Headers":[

• ],

• "Trailers":[

• ],

• "ContentFields":[

• {

• "FieldName":"ISIN",

• "Justification":"Left",

• "Label":" ",

• "Width":-1,

• "WidthStyle":"VariableWidth",

• "Format":{

• "@odata .type":"#DataScope.Select.Api.Extractions.ReportTemplates.ContentFieldTextFormat",

• "Capitalization":"None"

• }

• },

• {

• "FieldName":"RIC",

• "Justification":"Left",

• "Label":" ",

• "Width":-1,

• "WidthStyle":"VariableWidth",

• "Format":{

• "@odata .type":"#DataScope.Select.Api.Extractions.ReportTemplates.ContentFieldTextFormat",

• "Capitalization":"None"

• }

• },

• {

• "FieldName":"Universal Close Price",

• "Justification":"Left",

• "Label":" ",

• "Width":28,

• "WidthStyle":"VariableWidth",

• "Format":{

• "@odata .type":"#DataScope.Select.Api.Extractions.ReportTemplates.ContentFieldNumberFormat",

• "DecimalPlaces":9,

• "DecimalSeparator":"Period",

• "IntegerPlaces":18,

• "UseLeadingZero":false,

• "NegativeSignPosition":"Before",

• "ThousandSeparator":"Comma",

• "UseThousandSeparator":false,

• "UseTrailingZero":false

• }

• },

• {

• "FieldName":"Trade Date",

• "Justification":"Left",

• "Label":" ",

• "Width":-1,

• "WidthStyle":"VariableWidth",

• "Format":{

• "@odata .type":"#DataScope.Select.Api.Extractions.ReportTemplates.ContentFieldDateFormat",

• "DateFormat":"yyyy-MM-dd"

• }

• }

• ],

• "Condition":{

• "ReportDateRangeType":"Range",

• "QueryStartDate":"2023-04-04T00:00:00Z",

• "QueryEndDate":"2024-01-01T00:00:00Z",

• "AdjustedPrices":false,

• "LastEntityOnly":false

• }

• }

No error returned and the result code is 204, but the template is not updated.

Could you please advise if any change is required in this PUT?

Many thanks for your help.

Pietro

Jirapongse

@pragazzini

Thank you for reaching out to us.

It is a PriceHistoryReportTemplate report template so you may need to use this endpoint with the HTTP PUT method.

PUT https://selectapi.datascope.lseg.com/RestApi/v1/Extractions/PriceHistoryReportTemplates('<report_template_id')

FYI: The domain of the DSS REST API has been changed to selectapi.datascope.lseg.com. For more information, please refer to this discussion.