24/7 Support: 800.608.6482

Navigation


CustomerPointTransactionList_Load_Query

This function allows you to load a list of point transactions for a specific customer.

See the List Load Functions Overview guide to get started.

Search Filter Columns

dtstamp user_id order_id
cust_id pending descrip
points user_name

Sort Columns

dtstamp user_id order_id
pending descrip points

Request Body Parameters

count Type:
Number
Title:
Count
Count is used to tell Miva how many records you want returned. If for example you are querying thousands of records you'll want to set the count to limit how many you get back in a single request.
offset Type:
Offset
Title:
Number
Used in conjunction with the Count parameter for paginating results of large datasets. Default is 0 whcih is no offset.
sort Type:
String
Title:
Sort
Field to sort results by. Avaiilable sorting fields listed above. Use - prefix for a decending sort.
Filter Type:
Object
Title:
Filter
Array of Object containing search filters. See usage here: List Load Query Overview
Customer_ID Type:
Number
Title:
Customer ID
Id of customer to load
Customer_Login Type:
String
Title:
Customer Login
Login of customer to load
Edit_Customer Type:
String
Title:
Customer Login
Login of customer to load

Response Parameters

total_count Type:
Number
Title:
Total Product Count
total_count is the total number of records that match your search criteria. Note: this is not always the total products returned. Based on the Count and Offset parameters passed, the number of records returned could be different than the total_count.
start_offset Type:
Number
Title:
Start Offset
Number number of the starting offset number of products to return. Used in conjunction with the Count parameter for paginating results of large datasets.
id Type:
Number
Title:
Transaction ID
The ID of the Point Transaction List
user_id Type:
Number
Title:
User Id
The Id of the Admin user who added the transcation. 0 if not placed by an Admin user
cust_id Type:
Number
Title:
Customer ID
The Id of the Customer for the transaction list
order_id Type:
Number
Title:
Order Id
The Order ID the transcation references. If no order, it is 0
pending Type:
Boolean
Title:
Pending
If pending is 0, the points have been added. If it is 1, the points have yet to be added.
descrip Type:
String
Title:
Description
The description for the transaction list
points Type:
Number
Title:
Points
The amount of points for the transcation
dtstamp Type:
Date Timestamp
Title:
Date / Timestamp
The timestamp for when the transaction took place
user_name Type:
String
Title:
Admin Username
The User name of the admin user if it was added by an Admin. If no admin, the string returns empty.

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 – 2023 Miva©, Miva Merchant©, MivaPay©, MivaCon©, Camp Miva ℠, Miva, Inc. All Rights Reserved.