SearchTransactions
Description
The SearchTransactions method retrieves all transactions matching the search filter criteria.
Syntax
TransactionSearchResult SearchTransactions(SecurityToken securityToken, SearchFilter[] filters, boolean matchAll, boolean countOnly, string start, string limit, string sort)
Arguments
| Type | Name | Req. | Description |
|---|---|---|---|
| SecurityToken | securityToken | R | A unique token that is used to identify a merchant and authenticate the API request. |
| SearchFilter[] | filters | R | Filters transaction objects based on one or more field names, comparison operators, and field values. See supported search parameters below. |
| boolean | matchAll | R | Whether results must match all search filters.Possible Values
|
| boolean | countOnly | R | Whether to only return transaction counts.Possible Values
|
| string | start | O | Index of the first object to return in the array. Note: Default value is 0. Must be ≥ 0. |
| string | limit | O | Maximum number of objects to return. Note: Default value is 1. Must be > 0. |
| string | sort | O | Comma separated list of fields to sort by.Possible Values
|
Supported Search Parameters
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Amount</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>100.25</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>AuthCode</td>
<td>Filters by the transaction authorization code.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>AuthCode</ebiz:FieldName>`
` <ebiz:ComparisonOperator>gt</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>100000</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>AvsResult</td>
<td>Filters by the AVS result code.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>AvsResult</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>Y</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>AvsStreet</td>
<td>Filters by the AVS street address.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>AvsStreet</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>123 Century Rd.</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>AvsZip</td>
<td>Filters by the AVS ZIP code.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>AvsZip</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>92618</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>BatchID</td>
<td>Filters by the batch ID.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>BatchID</ebiz:FieldName>`
` <ebiz:ComparisonOperator>gt</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>50</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Billing\_City</td>
<td>Filters by the billing address city.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Billing_City</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>Irvine</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Billing\_Company</td>
<td>Filters by the the billing address company.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Billing_Company</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>CBS</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Billing\_Country</td>
<td>Filters by the billing address country.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Billing_Country</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>USA</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Billing\_FName</td>
<td>Filters by the first name associated with the billing address.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Billing_FName</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>Rebecca</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Billing\_LName</td>
<td>Filters by the last name associated with the billing address.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Billing_LName</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>Sample</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Billing\_Phone</td>
<td>Filters by the phone number associated with the billing address.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Billing_Phone</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>9492222222</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Billing\_State</td>
<td>Filters by the state associated with the billing address.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Billing_State</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>CA</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Billing\_Street</td>
<td>Filters by the billing street address.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Billing_Street</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>20 Pacifica</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Billing\_Street2</td>
<td>Filters by the billing address street line 2.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Billing_Street2</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>Apt. 3</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Billing\_Zip</td>
<td>Filters by the billing ZIP code.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Billing_Zip</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>92691</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Cardholder</td>
<td>Filters by the name of the cardholder.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Cardholder</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>User</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>CCNum</td>
<td>Filters by credit card number.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>CCNum</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>XXXXXXXXXXXX2224</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>CheckNum</td>
<td>Filters by the check number.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>CheckNum</ebiz:FieldName>`
` <ebiz:ComparisonOperator>gt</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>321</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Clerk</td>
<td>Filters by the clerk associated with the transaction.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Clerk</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>Clerk1</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>ClientIP</td>
<td>Filters by the client's IP address.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>ClientIP</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>11.11.11.11</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Created</td>
<td>Filters by the date and time the transaction was created.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Created</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>2025-10-02 16:23:12</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>CustID</td>
<td>Filters by the customer ID.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>CustID</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>CBS011</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Currency</td>
<td>Filters by the currency type.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Currency</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>840</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>CvcResult</td>
<td>Filters by the card code result code. Reference the `CardCodeResultCode` field in the [TransactionResponse](doc:transactionresponse) object for possible values.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>CvcResult</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>M</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Description</td>
<td>Filters by the description.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Description</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>Sale</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Discount</td>
<td>Filters by the discount applied to the transaction.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Discount</ebiz:FieldName>`
` <ebiz:ComparisonOperator>gt</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>3</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Email</td>
<td>Filters by the billing email address.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Email</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>[email protected]</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>ErrorCode</td>
<td>Filters by the error code.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>ErrorCode</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>37</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Invoice</td>
<td>Filters by the invoice ID.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Invoice</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>B-1011</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>OrderId</td>
<td>Filters by the order ID.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>OrderId</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>123</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>PoNum</td>
<td>Filters by the purchase order number.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>PoNum</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>PO-1234</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>RawAmount</td>
<td>Filters by the raw amount.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>RawAmount</ebiz:FieldName>`
` <ebiz:ComparisonOperator>gt</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>0</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Reason</td>
<td>Filters by the reason for an error.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Reason</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>Transaction amount is required</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>RecCustID</td>
<td>Filters by the customer number (`CustNum`).</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>RecCustID</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>19569729</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Response</td>
<td>Filters by the result code. Reference the `ResultCode` field in the [TransactionResponse](doc:transactionresponse) object for possible values.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Response</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>A</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Rest\_Table</td>
<td>Filters by the REST API table.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Rest_Table</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>1</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>ServerIP</td>
<td>Filters by the server IP address.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>ServerIP</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>11.11.111.111</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Shipping</td>
<td>Filters by the cost for shipping.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Shipping</ebiz:FieldName>`
` <ebiz:ComparisonOperator>gt</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>10</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Shipping\_City</td>
<td>Filters by the shipping address city.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Shipping_City</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>Irvine</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Shipping\_Company</td>
<td>Filters by the shipping address company.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Shipping_Company</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>CBS</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Shipping\_Country</td>
<td>Filters by the shipping address country.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Shipping_Country</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>USA</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Shipping\_FName</td>
<td>Filters by the first name associated with the shipping address.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Shipping_FName</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>Ruth</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Shipping\_LName</td>
<td>Filters by the last name associated with the shipping address.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Shipping_LName</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>Harper</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Shipping\_Phone</td>
<td>Filters by the shipping address phone number.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Shipping_Phone</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>9491231234</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Shipping\_State</td>
<td>Filters by the shipping address state.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Shipping_State</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>CA</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Shipping\_Street</td>
<td>Filters by the shipping street address.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Shipping_Street</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>20 Pacifica</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Shipping\_Street2</td>
<td>Filters by the shipping address street line 2.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Shipping_Street2</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>Apt. 2</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Shipping\_Zip</td>
<td>Filters by the shipping address ZIP code.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Shipping_Zip</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>92691</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Sources.Name</td>
<td>Filters by the name of the transaction source.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Sources.Name</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>api</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Status</td>
<td>Filters by the status code. Reference the `StatusCode` field in the [TransactionResponse](doc:transactionresponse) object for possible values.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Status</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>S</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Subtotal</td>
<td>Filters by the subtotal.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Subtotal</ebiz:FieldName>`
` <ebiz:ComparisonOperator>gt</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>100</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Tax</td>
<td>Filters by the tax amount.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Tax</ebiz:FieldName>`
` <ebiz:ComparisonOperator>gt</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>2</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Tip</td>
<td>Filters by the tip amount.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Tip</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>0</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>TransID</td>
<td>Filters by the transaction ID.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>TransID</ebiz:FieldName>`
` <ebiz:ComparisonOperator>gt</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>0</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>TranTerm</td>
<td>Filters by the terminal associated with the transaction.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>TranTerm</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>Terminal1</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>Type</td>
<td>Filters by the transaction type. Reference the `TransactionType` field in the [TransactionObject](doc:transactionobject) object for possible values.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>Type</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>S</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>User</td>
<td>Filters by the user.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>User</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>auto</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>VCAccount</td>
<td>Filters by the virtual card account number.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>VCAccount</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>XXXXX6789</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>VCChecks.Banknote</td>
<td>Filters by the banknote.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>VCChecks.Banknote</ebiz:FieldName>`
` <ebiz:ComparisonOperator>gt</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>0</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>VCChecks.Effective</td>
<td>Filters by the effective date of the ACH transaction.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>VCChecks.Effective</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>2025-12-15</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>VCChecks.Processed</td>
<td>Filters by the date the ACH transaction is processed.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>VCChecks.Processed</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>2025-12-15</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>VCChecks.Returned</td>
<td>Filters by the ACH returned data.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>VCChecks.Returned</ebiz:FieldName>`
` <ebiz:ComparisonOperator>gt</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>0</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>VCChecks.Settled</td>
<td>Filters by the date the ACH transaction is settled.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>VCChecks.Settled</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>2025-12-13</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
<tr>
<td>VCRouting</td>
<td>Filters by the ACH routing number.</td>
<td>
<pre>
<code>
`<ebiz:SearchFilter>`
` <ebiz:FieldName>VCRouting</ebiz:FieldName>`
` <ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>`
` <ebiz:FieldValue>XXXXX3004</ebiz:FieldValue>`
`</ebiz:SearchFilter>`
</code>
</pre>
</td>
</tr>
Return Value
| Type | Description |
|---|---|
| TransactionSearchResult | On success, returns all transactions matching the search filters. Otherwise, a fault is returned. |
Example Request
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ebiz="http://eBizCharge.ServiceModel.SOAP">
<soapenv:Header/>
<soapenv:Body>
<ebiz:SearchTransactions>
<ebiz:securityToken>
<ebiz:SecurityId>***********4621-b899***********</ebiz:SecurityId>
<ebiz:UserId/>
<ebiz:Password/>
</ebiz:securityToken>
<ebiz:filters>
<!--One or more repetitions:-->
<ebiz:SearchFilter>
<ebiz:FieldName>CustomerId</ebiz:FieldName>
<ebiz:ComparisonOperator>eq</ebiz:ComparisonOperator>
<ebiz:FieldValue>Cbs0001</ebiz:FieldValue>
</ebiz:SearchFilter>
<ebiz:SearchFilter>
<ebiz:FieldName>Amount</ebiz:FieldName>
<ebiz:ComparisonOperator>lt</ebiz:ComparisonOperator>
<ebiz:FieldValue>100</ebiz:FieldValue>
</ebiz:SearchFilter>
</ebiz:filters>
<ebiz:matchAll>true</ebiz:matchAll>
<ebiz:countOnly>false</ebiz:countOnly>
<ebiz:start/>
<ebiz:limit/>
<ebiz:sort/>
</ebiz:SearchTransactions>
</soapenv:Body>
</soapenv:Envelope>var client = new IeBizServiceClient();
SecurityToken securityToken = new SecurityToken
{
SecurityId = "***********4684-4856***********",
UserId = "",
Password = ""
};
bool matchAll = true;
bool countOnly = false;
SearchFilter[] searchFilters = new SearchFilter[]
{
new SearchFilter()
{
FieldName = "created",
ComparisonOperator = "gt",
FieldValue = "2026-01-28"
}
};
var result = client.SearchTransactions(securityToken, searchFilters, matchAll, countOnly, "0", "1000", "");
Console.WriteLine($"Matching Transactions: {result.TransactionsMatched}");function searchTransactions()
{
$client = new SoapClient('End point URL');
$securityToken = array(
'SecurityId' => '***********4757-4567***********',
'UserId' => 'merchant1',
'Password' => 'merchant1'
);
$SearchFilter = array(
'FieldName' => 'CustomerId',
'ComparisonOperator' => 'eq',
'FieldValue' => 1
);
$SearchTransactions = $client->SearchTransactions(
array(
'securityToken' => $securityToken,
'matchAll' => 1,
'countOnly' => 0,
'start' => 0,
'limit' => 1000,
'sort' => 'DateTime',
'filters' => $SearchFilter
))
;
$searchTransactionsResult = $SearchTransactions->SearchTransactionsResult;
}Example Response
<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">
<s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SearchTransactionsResponse xmlns="http://eBizCharge.ServiceModel.SOAP">
<SearchTransactionsResult>
<ErrorsCount>0</ErrorsCount>
<TransactionsMatched>1</TransactionsMatched>
<Transactions>
<TransactionObject>
<DateTime>2025-10-30 11:36:09</DateTime>
<Source>econnect admin portal</Source>
<ShippingAddress>
<City/>
<Company/>
<Country/>
<Email/>
<Fax/>
<FirstName/>
<LastName/>
<Phone/>
<State/>
<Street/>
<Street2/>
<Zip/>
</ShippingAddress>
<ServerIP>11.11.111.111</ServerIP>
<Response>
<CustNum>19558221</CustNum>
<ResultCode>A</ResultCode>
<Result>Approved</Result>
<RemainingBalance>0</RemainingBalance>
<RefNum>******7248</RefNum>
<isDuplicate>false</isDuplicate>
<ErrorCode>0</ErrorCode>
<Error>Approved</Error>
<ConvertedAmountCurrency/>
<ConvertedAmount>0</ConvertedAmount>
<ConversionRate>0</ConversionRate>
<CardCodeResultCode>M</CardCodeResultCode>
<CardCodeResult>Match</CardCodeResult>
<BatchRefNum>498276</BatchRefNum>
<BatchNum>1509</BatchNum>
<AvsResultCode>YYY</AvsResultCode>
<AvsResult>Address: Match & 5 Digit Zip: Match</AvsResult>
<AuthCode>***253</AuthCode>
<AuthAmount>50</AuthAmount>
<Status>Settled</Status>
<StatusCode>S</StatusCode>
</Response>
<LineItems>
<LineItem>
<DiscountRate>0.000</DiscountRate>
<SKU>Invoice-106</SKU>
<CommodityCode>100001</CommodityCode>
<ProductName>Product</ProductName>
<Description>Description</Description>
<DiscountAmount>0.00</DiscountAmount>
<TaxRate>0.000</TaxRate>
<UnitOfMeasure>EA</UnitOfMeasure>
<UnitPrice>50.00</UnitPrice>
<Qty>1.0000</Qty>
<Taxable>false</Taxable>
<TaxAmount>0.00</TaxAmount>
</LineItem>
</LineItems>
<Details>
<NonTax>false</NonTax>
<Tax>0</Tax>
<Table/>
<Subtotal>0</Subtotal>
<Shipping>0</Shipping>
<ShipFromZip>92618</ShipFromZip>
<PONum>PO-123</PONum>
<OrderID>ORD-001</OrderID>
<Invoice>Invoice-106</Invoice>
<Duty>0</Duty>
<Discount>0</Discount>
<Comments/>
<Description>Inv#: Invoice-106</Description>
<Currency/>
<Clerk>techPubsAdmin</Clerk>
<Amount>50</Amount>
<AllowPartialAuth>false</AllowPartialAuth>
<Terminal>EBizCharge Admin Portal</Terminal>
<Tip>0</Tip>
</Details>
<User/>
<CustomFields/>
<CustomerID>Cbs0001</CustomerID>
<CreditCardData>
<Pares/>
<MagSupport/>
<MagStripe/>
<InternalCardAuth>false</InternalCardAuth>
<CardType>V</CardType>
<CardPresent>false</CardPresent>
<CardNumber>XXXXXXXXXXXX2224</CardNumber>
<CardExpiration>XXXX</CardExpiration>
<CardCode>XXX</CardCode>
<AvsZip>92618</AvsZip>
<AvsStreet>Century</AvsStreet>
<TermType/>
</CreditCardData>
<ClientIP>11.11.11.11</ClientIP>
<CheckTrace/>
<CheckData/>
<BillingAddress>
<City>Irvine</City>
<Company/>
<Country/>
<Email/>
<Fax/>
<FirstName/>
<LastName/>
<Phone/>
<State>CA</State>
<Street>20 Pacifica</Street>
<Street2/>
<Zip>92618</Zip>
</BillingAddress>
<AccountHolder>Test er</AccountHolder>
<Status>Settled</Status>
<TransactionType>Sale</TransactionType>
</TransactionObject>
</Transactions>
<SalesCount>1</SalesCount>
<SalesAmount>50</SalesAmount>
<Limit>1</Limit>
<VoidsCount>0</VoidsCount>
<ErrorsAmount>0</ErrorsAmount>
<DeclinesCount>0</DeclinesCount>
<DeclinesAmount>0</DeclinesAmount>
<CreditsCount>0</CreditsCount>
<CreditsAmount>0</CreditsAmount>
<AuthOnlyCount>0</AuthOnlyCount>
<AuthOnlyAmount>0</AuthOnlyAmount>
<TransactionsReturned>1</TransactionsReturned>
<VoidsAmount>0</VoidsAmount>
</SearchTransactionsResult>
</SearchTransactionsResponse>
</s:Body>
</s:Envelope><s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">
<s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<SearchTransactionsResponse xmlns="http://eBizCharge.ServiceModel.SOAP">
<SearchTransactionsResult>
<SalesAmount>0</SalesAmount>
<ErrorsAmount>0</ErrorsAmount>
<DeclinesAmount>0</DeclinesAmount>
<CreditsAmount>0</CreditsAmount>
<AuthOnlyAmount>0</AuthOnlyAmount>
<VoidsAmount>0</VoidsAmount>
</SearchTransactionsResult>
</SearchTransactionsResponse>
</s:Body>
</s:Envelope>Updated 6 months ago
