Is there an API call that can list tracks played in the last X hours? I am trying to replace the following SQL call in a script we have with an API call.
SELECT items.idx, playlistlog.starttime
FROM items
JOIN playlistlog ON playlistlog.item = items.idx
WHERE items.type = 'Music'
AND playlistlog.starttime >= DATEADD(hour, -2, CONVERT(DATETIME,GETDATE() AT TIME ZONE (SELECT CURRENT_TIMEZONE_ID()) AT TIME ZONE 'GMT Standard Time'))
AND items.artist = ?
ORDER BY playlistlog.starttime DESC
(The script just changes the color, icon, and comment of a file depending on track/artist/artist group rotation policy so presenters know whether it can be played)