24/7 Support: 800.608.6482

Navigation


AvailabilityGroupCustomerList_Load_Query

This function loads a list of customers by Availability Group.

Request Parameters

store_code Type:
String
Title:
Store Code
Store code to run the function against. Found in the Miva Admin under Settings > Store Details
function Type:
String
Title:
Coupon Customer List Load Query
The name of the function being executed
assigned Type:
Boolean
Title:
Assigned
Boolean value indicating if the query returns assigned customer
availabilitygroup_id Type:
Number
Title:
Availability Group ID
The id number of the availability group
count Type:
Number
Title:
Count
Maximum lines of data allowed to be returned in the response. This limit is used to prevent excessive amounts of data return
filter Type:
String
Title:
Filter
A string for filtering returned data
offset Type:
Number
Title:
Offset
Used with the Count parameter for paginating results of large datasets. Default 0 is no offset.
sort Type:
String
Title:
Sort
The order for sorting returned data
unassigned Type:
Boolean
Title:
Unassigned
Boolean value indicating if the query returns unassigned customers

Response Parameters

success Type:
Boolean
Title:
Status Response
Boolean value indicating if the api request was successful
total_count Type:
Number
Title:
Total Count
the number of customers returned
start_offset Type:
Number
Title:
Start Offset
the offset starting point for pagination of return data
id Type:
Number
Title:
Customer ID
customer id
account_id Type:
Number
Title:
Account ID
account id associated with the customer
login Type:
String
Title:
Login
The login name of the customer
pw_email Type:
String
Title:
Password Email
The email for the customer password
ship_id Type:
Number
Title:
Ship_ID
Shipping id associated with the customer
ship_res Type:
Boolean
Title:
Ship Residential
Boolean value indicating if the shipping address is residential
ship_fname Type:
String
Title:
Shipping First Name
The first name of the customer
ship_lname Type:
String
Title:
Shipping Last Name
The last name of the customer
ship_email Type:
String
Title:
Shipping Email
The shipping email address for the customer
ship_comp Type:
String
Title:
Shipping Company Name
The company name of the customer
ship_phone Type:
String
Title:
Shipping Phone Number
The shipping phone number of the customer
ship_fax Type:
String
Title:
Shipping Fax Number
The shipping fax number of the customer
ship_addr1 Type:
String
Title:
Shipping Address Field 1
The first shipping address field
ship_addr2 Type:
String
Title:
Shipping Address Field 2
The second shipping address field
ship_city Type:
String
Title:
Shipping City
The city of the shipping address
ship_state Type:
String
Title:
Shipping State
The state of the shipping address
ship_zip Type:
String
Title:
Shipping Zip Code
The zip code of the shipping address
ship_cntry Type:
String
Title:
Shipping COuntry
The country of the shipping address
bill_id Type:
Number
Title:
Billing ID
billing id of the customer
bill_fname Type:
String
Title:
Billing First Name
The first name of the customer
bill_lname Type:
String
Title:
Billing Last Name
The last name of the customer
bill_email Type:
String
Title:
Billing Email
The shipping email address for the customer
bill_comp Type:
String
Title:
Billing Company Name
The company name of the customer
bill_phone Type:
String
Title:
Billing Phone Number
The billing phone number of the customer
bill_fax Type:
String
Title:
Billing Fax Number
The billing fax number of the customer
bill_addr1 Type:
String
Title:
Billing Address Field 1
The first billing address field
bill_addr2 Type:
String
Title:
Billing Address Field 2
The second billing address field
bill_city Type:
String
Title:
Billing City
The city of the billing address
bill_state Type:
String
Title:
Billing State
The state of the billing address
bill_zip Type:
String
Title:
Billing Zip Code
The zip code of the billing address
bill_cntry Type:
String
Title:
Billing COuntry
The country of the billing address
tax_exempt Type:
Boolean
Title:
Status Tax Exempt Customer
Boolean value indicating if the customer is tax exempt
order_cnt Type:
Number
Title:
Customer Order Count
The number of orders the customer has placed
order_avg Type:
Number
Title:
Customer Order Average
Average order total for the customer
formatted_order_avg Type:
String
Title:
Currency Formatted Order Average
Currency formatted average order total for the customer
order_tot Type:
Number
Title:
Order Total
Total amount of all orders for the customer
formatted_order_tot Type:
String
Title:
Currency Formatted Order Total
Currency formatted total amount of all orders
note_count Type:
Number
Title:
Note Count
Total number of notes for the customer
dt_created Type:
Number
Title:
Customer Creation Date
Unix timestamp for the customer creation date
dt_login Type:
Number
Title:
Login Date
Unix timestamp for the customer's most recent login date
dt_pwchg Type:
Number
Title:
Password Change Date
Unix timestamp for the date the customer changed their password
credit Type:
Number
Title:
Customer Credit
Amount of any customer credit on file
formatted_credit Type:
String
Title:
Currency Formatted Customer Credit
Currency formatted amount of any customer credit on file
business_title Type:
String
Title:
Customer Business Title
The customer's business title
assigned Type:
Boolean
Title:
Assigned
Boolean value indicating if the customer is currently assigned to the availability group

Example Request

Example Response

This website uses cookies to identify visitors, track visitors to our website, store login session information and to remember your user preferences. By continuing to use this site you agree to our use of cookies. Learn More.

This website uses cookies. By continuing to use this site you agree to our use of cookies. Learn More.

Accept

Copyright © 1997 – 2022 Miva©, Miva Merchant©, MivaPay©, MivaCon©, Camp Miva ℠, Miva, Inc. All Rights Reserved.