Skip to content

`CustomerList_Load_Query`#

Description#

This function allows you to load a list of customer records from Miva.

Request Body Parameters#

Parameter	Type	Description
`count`	Number	Maximum lines of data allowed to be returned in the response. This limit is used to prevent excessive amounts of data return
`filter`	String	A string for filtering returned data
`offset`	Number	Used with the Count parameter for paginating results of large datasets. Default 0 is no offset.
`sort`	String	The order for sorting returned data

On Demand Columns#

Column Name	Description
`CustomField_Values:*`	See custom field usage here: List Load Query Overview
#customfield_values)

Response Parameters#

Parameter	Type	Description
`total_count`	Number	total_count is the total number of records that match your search criteria.
`start_offset`	Number	Number of the starting offset number of customers to return. Used in conjunction with the Count parameter for paginating results of large datasets.
`id`	Number	Customer Id
`account_id`	Number	Business Account Id
`login`	String	Customer Login
`pw_email`	String	Customer Forgot Password Email
`ship_id`	Number	Shipping Address ID
`ship_res`	Boolean	Customer Ship Residential Flag
`ship_fname`	String	Shipping First Name
`ship_lname`	String	Shipping Last Name
`ship_email`	String	Shipping Email Address
`ship_comp`	String	Shipping Company
`ship_phone`	String	Shipping Phone Number
`ship_fax`	String	Shipping Fax Number
`ship_addr1`	String	Shipping Address 1
`ship_addr2`	String	Shipping Address 2
`ship_city`	String	Shipping City
`ship_state`	String	Shipping State. 2 digit state code
`ship_zip`	String	Shipping Zip Code
`ship_cntry`	String	Shipping Country. 2 digit country code
`bill_id`	Number	Billing Address Id
`bill_fname`	String	Billing First Name
`bill_lname`	String	Customer Last Name
`bill_email`	String	Billing Email Address
`bill_comp`	String	Billing Company
`bill_phone`	String	Billing Phone Number
`bill_fax`	String	Billing Fax Number
`bill_addr1`	String	Billing Address 1
`bill_addr2`	String	Billing Address 2
`bill_city`	String	Billing City
`bill_state`	String	Billing State. 2 digit state code
`bill_zip`	String	Billing Zip Code
`bill_cntry`	String	Billing Country. 2 digit country code
`note_count`	Number	Number of Notes assigned to customer record
`dt_created`	Unix Timestamp	Unix timestamp of the date account was created.
`dt_Updated`	Unix Timestamp	Unix timestamp of the date account was last updated.
`dt_login`	Unix Timestamp	Date Time of Last Login
`credit`	Number	Customer Account Credit
`formatted_credit`	String	Currency Formatted Customer Account Credit
`CustomField_Values`	Object	Object containing custom field modules
`customfield`	Object	Object containing custom field name value pairs
`business_title`	String	Business Account Title/Name

Example Request#

{
    "Store_code": "beta",
    "Function": "CustomerList_Load_Query",
    "Count": 0,
    "Offset": 0
}

Example Response#

{
    "success": 1,
    "data": {
        "total_count": 5,
        "start_offset": 4,
        "data": [
            {
                "id": 3,
                "account_id": 0,
                "login": "test",
                "pw_email": "bheyde@miva.com",
                "ship_id": 2,
                "ship_res": true,
                "ship_fname": "Brennan",
                "ship_lname": "Heyde",
                "ship_email": "bheyde@miva.com",
                "ship_comp": "Miva, Inc",
                "ship_phone": "555-555-5555",
                "ship_fax": "555-555-5555",
                "ship_addr1": "123 abc",
                "ship_addr2": "apt 123",
                "ship_city": "San Diego",
                "ship_state": "CA",
                "ship_zip": "92127",
                "ship_cntry": "US",
                "bill_id": 2,
                "bill_fname": "Brennan",
                "bill_lname": "Heyde",
                "bill_email": "bheyde@miva.com",
                "bill_comp": "Miva, Inc",
                "bill_phone": "555-555-5555",
                "bill_fax": "555-555-5555",
                "bill_addr1": "123 abc",
                "bill_addr2": "apt 123",
                "bill_city": "San Diego",
                "bill_state": "CA",
                "bill_zip": "92127",
                "bill_cntry": "US",
                "note_count": 0,
                "dt_created": 1538609652,
                "dt_Updated": 1538609652,
                "dt_login": 0,
                "credit": 0.0,
                "formatted_credit": "$0.00",
                "CustomField_Values": {},
                "business_title": ""
            }
        ]
    }
}