I have the CiviCRM API REST interface working fine for retrieving Case information for individual cases. But I'd like to use the options features options.limit and options.offset so I can retrieve data page by page from CiviCRM in response to a search. But whatever I try, nothing seems to alter the limit and the offset numbers of the retrieved records. Only the first 25 records are returned, ie the default number. Has anyone else had a similar problem?
The json payload looks like this:
json={
"return":"id,custom_116,custom_16",
"custom_116":{"IS NOT NULL":1},
"options":{"limit":100,"offset":100}
}
This is the REST format suggested by the API explorer (v3).
Am I doing something wrong? The search criterion ("IS NOT NULL") is ignored as above, but searches works correctly when not in object format, eg "custom_116":"StringToSearch". The limit and offset parameters are also ignored. So it seems likely that the problem is to do with the object format for these parameters. Any ideas? Or is there an alternative way of formatting the query json? Thanks.
CiviCRM 5.9.0 Joomla 3.9.1 php 7.0.31
http://path/to/rest.php?entity=Case&action=get&api_key=my_api_key&key=my_site_key&json={"sequential":1,"return":"id,custom_1","custom_1":{"IS NOT NULL":1},"options":{"limit":1}}
Also the IS NOT NULL comment above seems to hold on my local install - if I use"<>":""
instead then it works to exclude blank ones. My install is drupal - I doubt that would make a difference for this though.