Search customers

This request searches for customers within your account.

   Click here to learn more about this request

Secure Payments' search functionality is customizable to allow for broad and narrow search queries. Here's what you need to know about searches:

Customer social security numbers are not returned in these results; as such, you cannot search for customer's via their social security number.

The "fields" array holds values that the query value will search through. The usable values in this array are customer information fields. Here's a list of available values:

primary_zipcodeemail
first_namephone_number
mail_address1mail_address
generation_codeupdated
primary_address1created
middle_namecompany_name
primary_addressmail_zipcode
mail_stateprimary_address2
primary_citymail_city
primary_countrymail_country
contact_nameid
mail_address2last_name
user_idgender
driver_licenseprimary_state
credit_limit
{
    "search": {
        "size": 100,
        "from": 0,
        "query": {
            "query_string": {
                "query": "*John*",
                "default_operator": "OR",
                "fields": [
                    "first_name",
                    "middle_name",
                    "last_name",
                    "email"
                ]
            }
        }
    }
}
{
    "search": {
        "size": 100,
        "from": 0,
        "query": {
            "query_string": {
                "query": "*60602*",
                "default_operator": "OR",
                "fields": [
                    "primary_zipcode",
                    "mail_zipcode"
                ]
            }
        }
    }
}
{
    "search": {
        "size": 100,
        "from": 0,
        "query": {
            "query_string": {
                "query": "8348928",
                "default_operator": "OR",
                "fields": [
                    "id"
                ]
            }
        }
    }
}

Results

Returns customer information, matching the search query, on a success. An export set to false will include all customer information, excluding the customer's ssn (social security number), and be returned in the response.

An export set to true will send a report (.csv file) containing the search results to the associated agent's email address. This report will include less customer information, returning the values for first_name, middle_name, last_name, generation_code, email, company_name, contact_name, credit_limit, created date, and updated date.

A 404 Not Found error may occur if the request is missing the export boolean.

Language
Credentials
Click Try It! to start a request and see the response here!