Author Topic: API only returning 25 records - really URGENT (Read 5509 times)

xavier · December 12, 2011, 04:40:12 am

What version are you using ?

the api explorer is under /civicrm/api/explorer (check out on demo)

X+

Eileen · December 12, 2011, 11:55:05 am

So, the 3 formats currently around are

$params['rowCount'] = 400;
$params['option.limit'] = 400;
$params['options'] = array('limit' => 400);

One of those should work!

Note that groupContact may not return smart group contacts (I'd have to check status with ColemanW on that)

trevorwood · December 22, 2011, 02:47:59 am

Thanks for this. groupContact doesn't appear to return smartgroup contacts so I've written some custom code to get round the problem. I'll revisit it when time permits.

xavier · December 23, 2011, 06:14:01 am

Quote from: trevorwood on December 22, 2011, 02:47:59 am

Thanks for this. groupContact doesn't appear to return smartgroup contacts so I've written some custom code to get round the problem. I'll revisit it when time permits.

It would be useful to get it in the API IMO. Can you share the code?

X+

trevorwood · December 27, 2011, 02:20:49 am

As soon as things quieten down I intend to put up any useful code and documentation.

Basically it works like this. The smart group consists of contacts (individuals & organizations) that are members of a group and have a specific tag. I retrieve the members of the group and then check to see if the tag is set. Cluncky but it works

kengle3 · January 01, 2012, 04:51:14 pm

Is there any way to make it iterate through all the Contacts? I'm running into this problem with get contacts, but I can't figure out a way to then pull 26-50, 51-75, 76-100, etc.

I need to iterate over roughly three thousand contacts and counting, but I can't find a way to make the API loop and pull the next group of contacts.

Is there a way to iterate over all my contacts without having to maintain my own API functions, or perform a query for each individual contact?

Eileen · January 01, 2012, 05:13:01 pm

So, you have $rowCount & $offSet as parameters - you'd need your own loop though

Yaco · February 02, 2014, 07:09:03 am

Just for the record:

Using 4.4.3, it is possible to get all the records by simply setting "rowCount" to 0 (zero).

In my case, I do:

civicrm_api('Contact','Get',array('group' => array(4 => 1), 'version' =>3, 'rowCount' => 0 ))

Eileen · February 02, 2014, 12:20:32 pm

Hmm - that's good I think & good to know - I don't think there is a test on it to 'lock it in' though.

TwoMice · February 20, 2014, 09:34:35 am

Eileen:

Quote

you have $rowCount & $offSet as parameters

I wasn't aware of $offSet. Is there a wiki page where that's documented, or to which I could add it?

Thanks!
- Allen

Eileen · February 20, 2014, 11:54:16 am

It's here

http://wiki.civicrm.org/confluence/display/CRMDOC/Using+the+API#UsingtheAPI-Options

We should add a test 'locking in' the behaviour of $options['limit'] = 0 & document it there - generally 'rowCount' is less preferred than $options['limit']

CiviCRM Community Forums (archive)

News: