bheyde
8/17/2018 - 9:23 PM

CustomerList_Load_Query

CustomerList_Load_Query

Supported search filter columns:
		id
		login
		pw_email
		ship_fname
		ship_lname
		ship_email
		ship_comp
		ship_phone
		ship_fax
		ship_addr1
		ship_addr2
		ship_city
		ship_state
		ship_zip
		ship_cntry
		ship_res
		bill_fname
		bill_lname
		bill_email
		bill_comp
		biull_phone
		bill_fax
		bill_addr1
		bill_addr2
		bill_city
		bill_state
		bill_zip
		bill_cntry
		business_title
		note_count
		dt_created
		dt_login
		tax_exempt

	Supported sort columns:
		id
		login
		pw_email
		ship_fname
		ship_lname
		ship_email
		ship_comp
		ship_phone
		ship_fax
		ship_addr1
		ship_addr2
		ship_city
		ship_state
		ship_zip
		ship_cntry
		ship_res
		bill_fname
		bill_lname
		bill_email
		bill_comp
		biull_phone
		bill_fax
		bill_addr1
		bill_addr2
		bill_city
		bill_state
		bill_zip
		bill_cntry
		business_title
		note_count
		dt_created
		dt_login
		tax_exempt
		
	Example Output:
		{
			"success": 1,
			"data": {
				"total_count": 1,
				"start_offset": 0,
				"data": [
					{
						"id": 18,
						"account_id": 10,
						"login": "ccc",
						"pw_email": "ccc@test.com",
						"ship_id": 25,
						"ship_res": true,
						"ship_fname": "aaa",
						"ship_lname": "bbb",
						"ship_email": "ccc@miva.com",
						"ship_comp": "ddd",
						"ship_phone": "333-555-5555",
						"ship_fax": "333-555-1212",
						"ship_addr1": "111 Shoreham Pl",
						"ship_addr2": "",
						"ship_city": "bbb",
						"ship_state": "DK",
						"ship_zip": "22127",
						"ship_cntry": "EE",
						"bill_id": 26,
						"bill_fname": "fff",
						"bill_lname": "bbb",
						"bill_email": "ccc@miva.com",
						"bill_comp": "eee",
						"bill_phone": "333-555-5555",
						"bill_fax": "222-555-1212",
						"bill_addr1": "444 Shoreham Pl",
						"bill_addr2": "",
						"bill_city": "fff",
						"bill_state": "BF",
						"bill_zip": "52127",
						"bill_cntry": "CC",
						"tax_exempt": false,
						"note_count": 5,
						"dt_created": 1522713391,
						"dt_login": 1522713395,
						"credit": 24,
						"formatted_credit": "$24.00",
						"CustomField_Values": {
							"customfields": {
								"fielda": "The wombat softly sighs"
							}
						},
						"business_title": "eee"
					}
				]
			}
		}