Collection of field names, conditions, and values used to filter the query
See Filters and Conditions Reference for help.
List of field names accepted:
- method   (in, nin, eq, ne)
 
- enrollmentStatus   (in,nin, eq, ne)
 
- status   (in, nin, eq, ne)
 
- vendorNumber  (ct, nct, eq, ne)
 
- name   (ct, nct, eq, ne)
 
- ein   (ct, nct, eq, ne)
 
- phone   (ct, nct, eq, ne)
 
- email   (ct, nct, eq, ne)
 
- address   (ct, nct, eq, ne)
 
- city   (ct, nct, eq, ne)
 
- state   (ct, nct, eq, ne)
 
- country   (ct, nct, eq, ne)
 
- zip   (ct, nct, eq, ne)
 
- mcc   (ct, nct, eq, ne)
 
- locationCode   (ct, nct, eq, ne)
 
- paypointLegal  (ne, eq, ct, nct)
 
- paypointDba  (ne, eq, ct, nct)
 
- parentOrgId (ne, eq, nin, in)
 
- orgName  (ne, eq, ct, nct)
 
List of comparison accepted - enclosed between parentheses:
- eq or empty => equal
 
- gt => greater than
 
- ge => greater or equal
 
- lt => less than
 
- le => less or equal
 
- ne => not equal
 
- ct => contains
 
- nct => not contains
 
- in => inside array separated by ”|”
 
- nin => not inside array separated by ”|”
 
List of parameters accepted:
- limitRecord : max number of records for query (default=“20”, “0” or negative value for all)
 
- fromRecord : initial record in query
 
Example: netAmount(gt)=20  return all records with netAmount greater than 20.00