Apologies if my query has been answered elsewhere, but I haven't been able to find a relevant article / direction so far.
I have an API source that is drawn into VDP as a JSON format. The API accepts dates as input parameters.
Based on the dates entered, the number of JSON registers returned are different.
For example, start_date='2020-01-01' and end-date='2020-02-28' returns 125 registers.
That is for the above date range, my base view has the following structure:
I'd need flatten each of those registers, but do no want to repeat these manually as I do not know how many registers (and sometimes in thousands) I will have before the dates are input.
Each of the registers have the same field for example: hours and I should be able to project the "hours" from all the registers into a single view. Is this possible with Denodo?
Any direction is appreciated.