nwSkipTotal = false is limiting out at 100,000 when true result is higher

I’m making an inbound :fetch call to the Nextworld API and passing "nwSkipTotal": false in the body of the payload.

In the response, it’s telling me the total number of records is "total": 100000, but this is not true, I know from making an aggregate call the result is higher.

Is it possible to get the actual number returned somehow?

When I checked the Endpoint Documentation, this parameter is mentioned but I didn’t see any information about how it behaves:

When doing a data fetch with ”nwSkipTotal”: false the platform will return the record count in the pageData section of the response up to a certian value. This is done due to the overhead cost of counting the rows in some very large tables. When the record count returned in pageData has been capped the moreRecords field in the response will be set to true.

The get the full record count, regardless of the cap, use the aggregate endpoint you mentioned above.

2 Likes