How many crm records can be fetched to creator

How many crm records can be fetched to creator (for example: from Leads module), from this link: https://help.creator.zoho.com/Fetching-records-from-CRM.html, seems like we can't use WHERE clause, and we can only get Max 200 records from crm.

Is that still the case? if it is, why should I still use the functions? am I missing something there?

(oh, may be I can use ZOHO CRM API to get the records by Conditions or WHERE clause, is that correct?)

Thanks.