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)
- parentOrgId (ne, eq, nin, in)
- paypointDba (ne, eq, ct, nct)
- 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