Filtering using query parameters

Some Nexio API endpoints allow the use of query parameters as a way to filter (or limit) the results returned from the request. You can also use query parameters to request that those specific parameters be included in the response.

Path parameters that you include in a regular endpoint request already act like a filter for the response. But, there is an additional method for creating a filter for the Payments endpoint of View card tokens, the Reporting endpoints of Transactions and Chargebacks and the Payouts endpoint of View recipients.

For these endpoints in the Payments, Reporting, or Payouts API, you can also filter query parameters by specifying the desired parameter to filter on, an equals ( = ) sign, and the value to use for the filter. For parameters in an object, use the object name, a dot, and the parameter name before the equals. You can combine multiple filters by including an ampersand (&) between each one.

Use this feature, along with requesting additional response parameters, to limit the scope of the response and to get back the specific parameters that you want.

For example, the following request returns all transactions (made in the Nexio Payment API) for the specified zip code where the gateway status is 'Approved' and where the response includes all the default parameters plus the content for the customer and gateway objects.

curl -X GET https://api.nexiopaysandbox.com/transaction/v3?customer.postalCode=12345&gateway.message=Approved \
  -H 'Accept: application/json' \
  -H 'Authorization: Basic [Base64_encoded_login]'

As another example, the following searches for a transaction made in the Nexio Payment API with the to-be-specified payment ID, and also includes its Kount information in the results.

curl -X GET https://api.nexiopaysandbox.com/transaction/v3?kount.&plugin.originalId={payment_ID} \
  -H 'Accept: application/json' \
  -H 'Authorization: Basic [Base64_encoded_login]'

Reference tables

The following tables show all the fields that you can use for filtering with the additional query parameters. (The default fields can also be used for filtering. See the API reference documentation for each endpoint for details).

Payments filtering parameters

For information about each field, see the specific endpoint in the Payments API Reference .

NameFiltering Field
Merchant IDmerchantId or merchantIds
Customer reference numbercustomerRef
Card typecardType
Card holder namecardHolderName
Card first six numbersfirstSix
Card last four numberslastFour
Card expiration monthexpirationMonth
Card expiration yearexpirationYear
Created atcreatedAt
Updated atupdatedAt
Should update card flagshouldUpdateCard
Account Updater statusaccountupdaterstatus
Last update from Account UpdaterlastAccountUpdaterUpdate

Payouts filtering and additional parameters

For information about each field, see the specific endpoint in the Payouts API Reference.

NameQuery ParameterFiltering Field
Recipient ID NumbersrecipientIdNumbers.governmentId
passportId
driversLicenseId
employerIId

Transactions filtering and additional parameters

For information about each field, see the specific endpoint in the Reporting API Reference .

NameAdditional ParameterFiltering Field
Customercustomer.id
firstName
lastName
postalCode
phone
email
company
customerRef
Kountkount.id
status
rules
refNumber
merc
score
ruleCount
warningCount
counterCount
wasDeviceFingerprinted
mode
velo
vmax
Bank TransferbankTransfer.id
account
routing
checkNumber
Pluginplugin.id
originalId
invoice
orderNumber
description
userId
pluginType
paymentOptionTag
Foreign Processing CurrencyforeignProcessingCurrency.id
amount
currencyId
Gatewaygateway.id
merchantId
batchRef
refNumber
additionalRefNumber
trackingCode
gatewayType
message
Processorprocessor.id
transactionRef
batchRef
originalId
processorType
Customer AddressescustomerAddresses.id
billingAddressOne
billingAddressTwo
billingCity
billingState
billingPostalCode
billingCountry
billingPhone
shippingAddressOne
shippingAddressTwo
shippingCity
shippingState
shippingPostalCode
shippingCountry
shippingPhone
Transaction DetailstransactionDetails.id
description
clientIp
userName
shoppingCart
customFields
retryCount
paymentType
paymentToken
Subscriptionsubscription.id
remainingBalance
initialBalance
interval
intervalCount
subscriptionRef
accountId
scheduleType