developer:soap-1.4:methods:searchcustomers

Soap API v1.4

searchCustomers

Search for customers.

Description

This method allows you to search the customer database using flexible search terms. This method searches the customer database (aka recurring billing) not the transactions history. To search the transaction history for a specific customer, use either the searchTransactions or getCustomerHistory method.

Use as many or as few search terms as you like. With MatchAll set to “true,” all terms must match to return a result. If the search does not yield the desired results, try broadening your search by eliminating terms, or change MatchAll to “false.”

Valid field names for search and sort are:

  • BillingAddress.FirstName
  • BillingAddress.lastname
  • BillingAddress.Company
  • BillingAddress.Street
  • BillingAddress.Street2
  • BillingAddress.City
  • BillingAddress.State
  • BillingAddress.Zip
  • BillingAddress.Country
  • BillingAddress.Phone
  • BillingAddress.Fax
  • BillingAddress.Email
  • Amount
  • CustNum
  • CustomerID
  • Created
  • Description
  • Enabled
  • Failures
  • Modified
  • Start
  • Next
  • Notes
  • NumLeft
  • OrderID
  • ReceiptNote
  • Schedule (1=Daily,2=Weekly,3=Bi-Weekly,4=Monthly,5=Bi-Monthly,6=Quarterly,7=Bi-Annually,8=Annually,9=First of Month, 10=Last Day of Month)
  • SendReceipt
  • Source
  • Tax
  • User

See also searchcustomerscustom, searchcustomerscount, searchCustomerID

Syntax

CustomerSearchResult searchCustomers ( ueSecurityToken Token, SearchParam Search, boolean MatchAll, integer Start, integer Limit, string Sort)

Arguments

Type Name Description
ueSecurityToken Token Merchant security token: used to identify merchant and validate transaction.
SearchParam Search Array of search parameters.
boolean MatchAll If set to “true,” only results matching all search criteria will be returned, if set to “false,” results matching any of the search criteria will be returned.
integer Start Start position, defaults to 0 (first customer found).
integer Limit Maximum number of customers to return in result.
string Sort Field name to sort the results by

Return Value

CustomerSearchResult Returns results of customer search based on parameters set.

Examples

PHP

For directions on how to set up the WSDL link, create “$token” and “$client”, go to PHP Soap How-to.

<?php 
 
try { 
 
  $search=array( 
    array( 
      'Field'=>'amount',  
      'Type'=>'gt', 
      'Value'=>'8.00'), 
 
    array( 
      'Field'=>'failures',  
      'Type'=>'gt',  
      'Value'=>'0') 
    ); 
  $start=0; 
  $limit=10; 
  $matchall=true; 
  $RefNum=1009411;
  $Sort = "fname"; 
 
  $res=$client->searchCustomers($token,$search,$matchall,$start,$limit,$Sort); 
  print_r($res); 
 
  $this->assertTrue($res->CustomersMatched>0 && $res->CustomersReturned>0); 
 
} 
 
catch (SoapFault $e) { 
 
  die("Search Customers failed :" .$e->getMessage()); 
 
} 
 
?> 

.NET VB

Dim matchAll As Boolean
        matchAll = True
 
        Dim search(0) As usaepay.SearchParam
 
        search(0) = New usaepay.SearchParam()
 
        search(0).Field = "Created"
        search(0).Type = "Contains"
        search(0).Value = "2010-09-09"
 
        Dim response As usaepay.CustomerSearchResult = New usaepay.CustomerSearchResult
 
        response = client.searchCustomers(token, search, matchAll, "0", "10", "fname")
        MsgBox(response.CustomersMatched)

.NET C#

For directions on how to set up the WSDL link and create the “token” and “client” variables, go to the C Sharp .Net Soap How-to.

Boolean matchAll;
            matchAll = true;
 
            usaepay.SearchParam[] search = new usaepay.SearchParam[2];
            search[0] = new usaepay.SearchParam();
 
            search[0].Field = "Created";
            search[0].Type = "Contains";
            search[0].Value = "2010-08-10";
 
            usaepay.CustomerSearchResult response = new usaepay.CustomerSearchResult();
 
            try
            {
                response = client.searchCustomers(token, search, matchAll, "0", "10", "fname");
 
                MessageBox.Show(response.CustomersMatched);
 
            }
 
 
            catch (Exception err)
            {
                MessageBox.Show(err.Message);
            }

Change History

Version Change
1.2 Added Sort Parameter
1.1 Soap 1.1 Release
developer/soap-1.4/methods/searchcustomers.txt · Last modified: 2010/11/01 12:05 by irina

Page Tools