REST API GET data on last day in month through the year

[Espen Haldorsen 3]

Hi

I have a REST API to get aggregated values by date.

In the GET request the aggregated date is specified in the header of the request.

During a year I need to get aggregated values fromend of each month and gather all the data in the same table for analytic purpose in Spotfire.

What is the best solution do do this in TDV

One alternative is to use another service where I do not need to specify the date, and the date is then set by request date. Then I need to cache this in end of each month (start of mont for previous month)and somehow merge this with previsou gathered data...

Any ideas on how to do this best case in TDV