List Load Query Overview

Overview

Anytime you want to pull a list of data from the API including Orders, Customers, Products, Categories, etc you will be using a List Load Query Function. These functions are spcifically designed to give you maximum control over which data is returned and how much is returned. There are advanced filters which give you granular control over the response. If you would like Miva to keep track of new and updated changes to orders please see Order Workflows, Product Workflows and Customer Workflows.

Filter List Parameters

All xxxList_Load_Query functions accept the following common parameters:

Filter	Optional search/display filter that is applied to results. See below.
Sort	Column name to sort the results, may be preceded by "-" for a descending sort.
Count	Number of records to return, if 0, return all records (defaults to 0)
Offset	0-based offset of the first record to return (defaults to 0)

List Filter Parameters

Filter is an array of filter structures. The required fields for a filter structure depend on its "name" property.

Valid operators are:

EQ	"field" equals "value" (generally case insensitive)
GT	"field" is greater than to "value"
GE	"field" is greater than or equal to "value"
LT	"field" is less than "value"
LE	"field" is less than or equal to "value"
CO	"field" contains "value"
NC	"field" does not contain "value"
LIKE	"field" matches "value" using SQL LIKE semantics
NOTLIKE	"field" does not match "value" using SQL LIKE semantics
NE	"field" is not equal to "value"
TRUE	"field" is true
FALSE	"field" is false
NULL	"field" is null
IN	"field" is equal to one of a set of comma-separated values taken from "value"
NOT_IN	""field" is not equal to any of the set of comma-separated values taken from "value"

To perform an AND search, use multiple top-level search filters:

To perform an OR search, use multiple values inside a single search filter:

Parenthetical comparisons can be accomplished using the "SUBWHERE" operator and special field names "search", "search_AND" and "search_OR":

A field of "search" or "search_AND" combines its child expressions with OR and the overall results with its parent using AND. A field of "search_OR" combines its child expressions with "AND" and the overall results with its parent using "OR".

In the example above, the resulting WHERE clause is:

WHERE
ship_lname EQ 'Bchmore' OR ( ship_fname EQ 'Ryan' AND ship_lname EQ 'Guisewite' )

On Demand Columns

ondemandcolumns filter

Many lists return certain columns only when they are explicitly requested. This may be because the column is expensive to load (payment module) or includes a large amount of data that is not always needed (custom fields, product descriptions). These fields can be requested using the ondemandcolumns

Specific on-demand columns will be called out on a function by function basis below. Product, category, customer and order functions all support custom fields, which are retrieved in the following way:

"CustomField_Values:<module code>:<field code>"	Includes that specific field in the output
"CustomField_Values:<module code>:*"	Includes all fields for the specified module in the output
"CustomField_Values:*"	Includes all custom fields in the output

Sample Response

All xxxList_Load_Query functions output data (on success) in the following format:

Function Reference

List_Load_Query Functions