When grabbing data from the DataService API I thought at the end near RowsAffected there was a total of all records that meet the search. I have isPageable": true. But I do not see the total anymore. Is it gone or am I not remembering correctly?
I am my querying a lot of records, but only want to return 1000 at a time
Thank you
Like
Hi Keith,
Indeed, there is the RowsAffected in the SelectQuery result for example:
If you need to select some number of records you need to use the "RowCount" and "RowsOffset" which stand for "how many records" and "from which record to start":
Best regards,
Oscar
I see that, but what ever I put for row count is what is returned. Should be 32,000 records
I 
keith schmitt,
Right, it should return 1000 records since this is a value specified in the "RowCount" parameter. If you need 32 000 records then you need to use 32 000 in the "RowCount".
Best regards,
Oscar
ok, So I may be asking the wrong Question. If I have 32,234 rows (found from GUI). I am limited to 20,000 per call. I only want to do 1000 per call. How can know from an API call the total numbers of rows? Or do I just have to keep calling untill rowsAffected is less than rowCount