Bug in Version 3 Contact Count API

[Mohit Thakral]

Please execute following API request result is 25, where is total count of sample contacts is 102.

http://drupal.demo.civicrm.org/?q=civicrm/ajax/doc/api#/civicrm/ajax/rest?json=1&sequential=1&debug=1&&entity=Contact&action=getcount

Regards
Mohit Thakral

[Eileen]

It's not a bug - although it makes less sense in 'getcount' than in other functions.

There is a parameter 'limit' which by default is set to 25. It might make sense to change that limit on the getcount function (which is actually just the get function with a different return format) but I think making it unlimited (e.g. 'limit' => 10,000,000) could be a problem as sometimes people have huge DBs & it they choose a bad combo of params it can  result in hammering the DB, Having said that we could also modify the return properties when getcount is called which would mitigate that somewhat.

[Mohit Thakral]

But, getcount is the function to be used to return the number of the records. So, it is suppose to return the count of records. Thats y it is not returning any records as such. It should return the exact count.

[Eileen]

Yes, you can log that as an issue if you'd like.

To get yourself going now you can just set $params['limit'] => 1000000000 or similar

[Mohit Thakral]

I am using Rest API , and using .Net to consume these reset services. Can you please help how can I pass limit 100000000000000 in Rest

[Eileen]

You should be able to add &limit=1000000 to your url

[Mohit Thakral]

I tried putting limit param in demo. It didn't work.

 http://drupal.demo.civicrm.org/?q=civicrm/ajax/doc/api#/civicrm/ajax/rest?json=1&sequential=1&debug=1&&entity=Contact&action=getcount

Regards
Mohit Thakral

[Eileen]

sorry - try 'rowCount'

[Mohit Thakral]

thanks a ton.. super awesome it worked

[ChrisChinchilla]

How do I get similar results with…

/civicrm/ajax/rest?json=1&sequential=1&debug=1&&entity=GroupContact&action=get&group_id=19

Again, limits to 25 results, I want to return the amount of members in a group?

[xavier]

Try
/civicrm/ajax/rest?json=1&sequential=1&debug=1&entity=Contact&action=get&group=19&rowCount=42

[Eileen]

Try option.limit or option_limit (can't remember which)

[ChrisChinchilla]

Thanks guys, will give it a go next time I have a moment…

[ChrisChinchilla]

option_limit worked, thanks!