Dynatrace REST API pagination issue on pageOffset and pageSize

[EVENTDEV]

Following query returned 503023 as record count:

query = SELECT count(*) from usersession
startTimestamp = 1641513600000
endTimestamp = 1641520800000

But then when I ran following with pageOffset and pageSize, no results returned: 

query = SELECT * from usersession
startTimestamp = 1641513600000
endTimestamp = 1641520800000
pageSize = 100
pageOffset = 502000

 I'm expecting entries from 502000 -> 502100. 

What am I doing wrong?

[EVENTDEV · Accepted solution]

pageOffset shouldn't exceed 5000, generally speaking. I don't know if this is a hard limit, but as good practice it's wise to limit this to few thousands. That means narrowing down the start and end timestamps to, say, 5 minutes. 

Job worked as expected with these new parameters.