How to Update a SinglePriceHistory Report Template using REST API?

mathieu.comandini

Hello,

I can't seem to succeed to update the Endate of my SinglePriceHistory ReportTemplate using REST API. I always get this error :

{"error":{"message":"Validation Error:\r\n\r\nInternal constraint \"ReportTemplate.InvalidFieldsForAdjustedPrices\" execution failure: message='Value cannot be null.\r\nParameter name: source' / exid='356ee8c2-6d52-4f19-a885-0223874fd7e4'"}}

The body I send is :

{
    "@odata.type": "#DataScope.Select.Api.Extractions.ReportTemplates.SinglePriceHistoryReportTemplate",
    "ShowColumnHeaders": true,
    "Name": "MyTemplateName",
    "Condition":{
        "EndDate": "2022-05-31T00:00:00.000Z",
        "AdjustedPrices": false,
        "LastEntityOnly": false
    }
}

I use a PUT query as stated in the API Documentation with this url :

https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/SinglePriceHistoryReportTemplates('MyTemplateIdIsHere')'

As you can see in my content body, the parameter AdjustedPrices is set. So how can I solve the error "ReportTemplate.InvalideFieldsForAdjustedPrices"?

Also do you see any other error in my query ?

Thanks in advances,

Mathieu

Jirapongse

@mathieu.comandini

I checked and found that to avoid the error, I need to specify the content fields in the request message. I got the content fields from the GET method of the /Extractions/SinglePriceHistoryReportTemplates('reportTemplateID') endpoint.

mathieu.comandini

Thank you, I can make it work with that