Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

API filter use
 
aligard
Jr. Member
 
Total Posts:  1
Joined:  2009-03-09
 

I’m trying to get a list of all customers without a certain field defined (Null)

$filters = array(’taxvat’ => array(’null’=>’’));

$api_result = $this->magento_api_call(’customer.list’, array($filters));

However this does not return anything.

Has anyone else had any success with this using the array filter of the API calls.

I found this from another post but have not had success with several of the options listed:

Parameters you can pass to a Magento API filter
from returns rows that are after this value (datetime only)
to returns rows that are before this value (datetime only)
eq returns rows equal to this value
neq returns rows not equal to this value
like returns rows that match this value (with % as a wildcard)
nlike returns rows that do not match this value (with % as a wildcard)
in returns rows where the value is in this array (pass an array in)
nin returns rows where the value is not in this array (pass an array in)
is unsure
null returns rows that are null
notnull returns rows that are not null
moreq unsure
gt returns rows greater than this value
lt returns rows less than this value
gteq returns rows greater than or equal to this value
lteq returns rows less than or equal to this value
finset unsure

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top