Anyone getting periodically 0 results back from the REST/SuiteQL; where before not even 30 minutes earlier we had results? We have some ETL workloads failing because every hour we pull transactions and get a 0 results sometimes.

I haven't seen this when executing exactly the same query, but I have seen some queries return empty results. For example IIRC if you

select * on transaction

it will bail and return nothing. However, if you specify specific columns it returns results. Maybe not related, maybe is?

We noticed a ~4000 row query typically will end early at 1000 rows indicating theres no more rows to retrieve, so far weird. We added a "if query returns less rows that we already have" logic to our ETL process just in case.