The API node query worked But I’m still curious why a simple > operator didn’t work in the Table Get Rows
NB. For others reading this, I used a function block rather than handlerbars markup to calculate the start of the seven day period:
// Calculate start of reporting period in ms since epoch UTC.
// Report includes all samples entered for the previous 7 days
// ending at midnight today (00:00 UTC).
let now = Date.now();
let endOfReport = new Date(now - now % (24 * 60 * 60 * 1000));
let startOfReport = new Date(endOfReport.valueOf() - 7 * 24 * 60 * 60 * 1000);
console.log("Start of Reporting Period: " + startOfReport.toISOString());
payload.data.startOfReport_ms = startOfReport.valueOf(); // payload only supports JSON