JSON TYPE BEST APPROACH

[gudge25]

hi community
I have a JSON API
from where I need to request data per day

so I created
1-JSON Query
url: "https://IP/stats/rest/index.php?entity=reports/answered_calls_detail&start=2024-01-01"

after in order to. present this data on a dashboard I need
2-to create another Query

SELECT
  json_extract(value, '$.datetime') AS datetime,
  json_extract(value, '$.queue') AS queue,
  json_extract(value, '$.agent') AS agent,
  json_extract(value, '$.callerid') AS callerid,
  json_extract(value, '$.event') AS event,
  json_extract(value, '$.waitTime') AS waitTime,
  json_extract(value, '$.ringTime') AS ringTime,
  json_extract(value, '$.callTime') AS callTime,
  json_extract(value, '$.agentName') AS agentName,
  json_extract(value, '$.queueName') AS queueName,
  --json_extract(value, '$.recording') AS recording,
  --json_extract(value, '$.uniqueid') AS uniqueid,
  --json_extract(value, '$.callflow') AS callflow,
  json_extract(value, '$.did') AS did
FROM
  cached_query_2,   --  LINK to JSON from Step 1
  json_each(cached_query_2.rows) AS json_row;

SO i have data for one day FINALLY

QUESTION
i need to to request data per each day and then create a dashboard with data per day (NOT SUMMARY)

PLEASE ADVICE BEST APPROACH