Skip to content

`PriceGroupCustomerList_Load_Query`#

Description#

This function allows you to look up customers assigned to a specific price group.

Request 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
`pricegroup_id` `pricegroup_code` `edit_pricegroup`	Number String String	ID of the Price Group. Price Group code Price Group code

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 records to return.
`id`	Number	Customer Id
`account_id`	Number	Business Account Id
`login`	String	Customer Login
`pw_email`	String	Forgot Password Email
`ship_id`	Number	Address Book Shipping Address ID
`ship_res`	Boolean	Boolean flag used to determine if commercial or residential rates are returned.
`ship_fname`	String	Shipping First Name
`ship_lname`	String	Customer 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_login`	Unix Timestamp	Date Time of Last Login
`credit`	Number	Customer Account Credit
`formatted_credit`	String	Currency Formatted Customer Account Credit
`business_title`	String	Name of Business Account customer is assigned to
`assigned`	Boolean	Flag to indicate customer is assigned to the Price Group passed in as a parameter

Example Requests#

{
    "Store_Code": "{{Store_Code}}",
    "Miva_Request_Timestamp": "{{$timestamp}}",
    "Function": "PriceGroupCustomerList_Load_Query",
    "PriceGroup_Name": "Wholesale",
    "Offset": 0,
    "Count": 0,
    "Sort": ""
}

Example Response#

{
    "success": 1,
    "data": {
        "total_count": 1,
        "start_offset": 0,
        "data": [
            {
                "id": 1,
                "account_id": 0,
                "login": "bheyde",
                "pw_email": "bheyde@miva.com",
                "ship_id": 0,
                "ship_res": true,
                "ship_fname": "",
                "ship_lname": "",
                "ship_email": "",
                "ship_comp": "",
                "ship_phone": "",
                "ship_fax": "",
                "ship_addr1": "",
                "ship_addr2": "",
                "ship_city": "",
                "ship_state": "",
                "ship_zip": "",
                "ship_cntry": "US",
                "bill_id": 0,
                "bill_fname": "",
                "bill_lname": "",
                "bill_email": "",
                "bill_comp": "",
                "bill_phone": "",
                "bill_fax": "",
                "bill_addr1": "",
                "bill_addr2": "",
                "bill_city": "",
                "bill_state": "",
                "bill_zip": "",
                "bill_cntry": "",
                "note_count": 0,
                "dt_created": 1565210855,
                "dt_login": 0,
                "credit": 0.0,
                "formatted_credit": "$0.00",
                "business_title": "",
                "assigned": true
            }
        ]
    }
}