List subscriptions by paypoint

Max number of records to return for the query. Use 0 or negative value to return all records.

Collection of field names, conditions, and values used to filter the query.

See Filters and Conditions Reference for more information.

Accepted field names:

• startDate (gt, ge, lt, le, eq, ne)
• endDate (gt, ge, lt, le, eq, ne)
• nextDate (gt, ge, lt, le, eq, ne)
• frequency (in, nin, ne, eq)
• method (in, nin, eq, ne)
• totalAmount (gt, ge, lt, le, eq, ne)
• netAmount (gt, ge, lt, le, eq, ne)
• feeAmount (gt, ge, lt, le, eq, ne)
• status (in, nin, eq, ne)
• untilcancelled (eq, ne)
• subscriptionType (eq, ne, in, nin). Filters by subscription type. Accepts Regular or BalanceDriven. Case-insensitive. Example: subscriptionType(in)=Regular|BalanceDriven.
• payaccountLastfour (nct, ct)
• payaccountType (ne, eq, in, nin)
• payaccountCurrency (ne, eq, in, nin)
• customerFirstname (ct, nct, eq, ne)
• customerLastname (ct, nct, eq, ne)
• customerName (ct, nct)
• customerId (eq, ne)
• customerNumber (ct, nct, eq, ne)
• customerCompanyname (ct, nct, eq, ne)
• customerAddress (ct, nct, eq, ne)
• customerCity (ct, nct, eq, ne)
• customerZip (ct, nct, eq, ne)
• customerState (ct, nct, eq, ne)
• customerCountry (ct, nct, eq, ne)
• customerPhone (ct, nct, eq, ne)
• customerEmail (ct, nct, eq, ne)
• customerShippingAddress (ct, nct, eq, ne)
• customerShippingCity (ct, nct, eq, ne)
• customerShippingZip (ct, nct, eq, ne)
• customerShippingState (ct, nct, eq, ne)
• customerShippingCountry (ct, nct, eq, ne)
• orgId (eq)
• paypointId (ne, eq)
• paypointLegal (ne, eq, ct, nct)
• paypointDba (ne, eq, ct, nct)
• orgName (ne, eq, ct, nct)
• externalPaypointId (ct, nct, ne, eq)
• subId (eq, ne)
• idPmethod (eq, ne, ct, nct, in, nin). Filters by the subscription’s linked stored method identifier (the value returned in StoredMethod.IdPmethod). Case-insensitive. Subscriptions without a linked stored method are excluded from matches. Example: idPmethod(eq,6edcbb56-9c0e-4003-b3d1-99abf149ba0e).
• orderDescription (ct, nct)
• cycles (eq, ne, gt, ge, lt, le)
• leftcycles (eq, ne, gt, ge, lt, le)
• createdAt (eq, ne, gt, ge, lt, le)
• updatedOn (eq, ne, gt, ge, lt, le)
• invoiceNumber (ct, nct)
• additional-xxx (ne, eq, ct, nct) where xxx is the additional field name

Accepted comparison operators:

• 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
• nin => not inside array

The field name to use for sorting results. Use desc(field_name) to sort descending by field_name, and use asc(field_name) to sort ascending by field_name.