- Using Prime Infrastructure v2.2 REST API ClientSessions, working on pulling all the data. When running the query - /webacs/api/v1/data/ClientSessions.json?.full=true&.maxResults=1000&.firstResult=0 in Postman saw 890K records but, was able to retrieve only 1000 records. How to retrieve all the records and also,is there a date parameter to use with this.
1000 records is the maximum page size. You can get all of the client sessions by paging through the results; to do this, increment .firstResult by the value of .maxResults. So here you need to use -with .maxResults=1000, start .firstResult at 0, then 1000, 2000, 3000, etc.
You can also combine this with filtering. Since a client session that's finished is unlikely to be updated, finished sessions that you've already captured don't need to be fetched again. So you could filter with sessionStartTime to look for sessions that have started since the last time you polled for sessions, and/or filter with sessionEndTime to look for sessions that have ended since the last time you polled for sessions.
- The sessionStartTime is UNIX date format, So it should be filtered using the same format .
It's pretty close to Unix format; whereas Unix format is seconds since 00:00:00 Jan 1, 1970 UTC-0, our representation is in milliseconds. So if you are using a standard long to String converter, divide the value by 1000 before converting.