ArcGIS API for Python; arcgis.features.FeatureLayer().query() troubleshooting

[TylerT]

Hello,

I am having an issue with the FeatureLayer query where not all results are returned.  For example the following:

…
flayer.query(where=my_where, as_df=True, return_all_records=True)

returns a dataframe with 2503 records.

and

…
flayer.query(where=my_where, return_count_only=True)

returns integer 3503.

So, I’m missing 1000 known records.  My sense is the rest API is limiting returns someway, but it seems like the return_all_records=True parameter would overcome that limit with recall. 

(docs for return_all_records)

Any thoughts on how I can retrieve all records that satisfy my where clause would be appreciated.

Thank you,

Tyler

ArcGIS Pro 3.3