---
title: "Search transactions"
method: GET
path: "/transactions"
tags: ["Transactions"]
---

# Search transactions

`GET /transactions`

Search transactions

## Query parameters

- `transaction_id` string
- `order_id` integer
- `customer_id` integer
- `date_complete_from` string, date-time
- `date_complete_to` string, date-time
- `date_scheduled_from` string, date-time
- `date_scheduled_to` string, date-time
- `transaction_status` 1 | 2 | 3 | 4 | 5 — * `1` - Pending * `2` - Complete * `3` - Scheduled * `4` - Cancelled * `5` - Skipped
- `payment_method_id` 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 — * `1` - Credit Card * `2` - Check * `3` - Google Pay * `4` - Apple Pay * `5` - Cash * `6` - Paypal * `7` - Alternative Payments Sofort * `8` - Alternative Payments POLi * `9` - Alternative Payments SEPA * `10` - ACH * `11` - Afterpay * `12` - Klarna * `13` - SEPA
- `transaction_type_id` 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 — * `1` - Sale * `2` - Refund * `3` - Void * `4` - Chargeback * `5` - Alert * `6` - Auth * `7` - Capture * `8` - COD * `9` - Chargeback Reversal * `10` - Returned Check
- `merchant_id` integer
- `campaign_id` integer
- `gateway_response_id` string
- `transaction_total` string
- `currency_id` integer
- `transaction_cycle` integer
- `transaction_success` boolean
- `transaction_attempt` integer
- `card_bin` string
- `card_last_4` string
- `tracking1-20` string
- `with` 'order' | 'order_revisions' | 'line_items' | 'sale' | 'credits' | 'customer' | 'customer_card' | 'customer_address_billing' | 'customer_address_shipping' | 'shipments' | 'campaign' | 'merchant' | 'route_logs' | 'actions'
- `limit` integer
- `offset` integer
- `sort_by` string
- `order` 'asc' | 'desc'

## Response `200`

OK

- object
  - `total` integer
  - `transactions` object[]
    - `transaction_id` integer
    - `connection_transaction_id` string, nullable
    - `customer_id` integer
    - `order_id` integer
    - `payment_method_id` 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 — * `1` - Credit Card * `2` - Check * `3` - Google Pay * `4` - Apple Pay * `5` - Cash * `6` - Paypal * `7` - Alternative Payments Sofort * `8` - Alternative Payments POLi * `9` - Alternative Payments SEPA * `10` - ACH * `11` - Afterpay * `12` - Klarna * `13` - SEPA
    - `transaction_type_id` 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 — * `1` - Sale * `2` - Refund * `3` - Void * `4` - Chargeback * `5` - Alert * `6` - Auth * `7` - Capture * `8` - COD * `9` - Chargeback Reversal * `10` - Returned Check
    - `transaction_cycle` integer
    - `transaction_attempt` integer
    - `transaction_declined` boolean
    - `merchant_id` integer
    - `transaction_merchant_descriptor` string
    - `response_code` integer, nullable
    - `transaction_3ds_verified_status` string, nullable
    - `gateway_response_id` string, nullable
    - `gateway_auth_code` string, nullable
    - `gateway_response_code` string, nullable
    - `gateway_response_description` string, nullable
    - `gateway_response_avs` string, nullable
    - `gateway_response_cvv` string, nullable
    - `processor_response_text` string, nullable
    - `currency_id` integer
    - `transaction_price` string
    - `transaction_discount_total` string
    - `transaction_shipping` string
    - `transaction_sub_total` string
    - `transaction_tax` string
    - `transaction_fee` string
    - `customer_balance_applied` string
    - `gift_card_applied` string
    - `transaction_total` string
    - `order_discount_total` string
    - `check_number` string, nullable
    - `check_amount` string
    - `dunning_cycle_id` integer, nullable
    - `dunning_cycle_total` string
    - `quantity_discount_cycle_id` integer, nullable
    - `quantity_discount_cycle_total` string
    - `discount_cycle_id` integer, nullable
    - `discount_cycle_total` string
    - `date_scheduled` string, date-time
    - `date_complete` string, date-time, nullable
    - `date_cancelled` string, date-time, nullable
    - `date_skip` string, date-time, nullable
    - `date_batch` string, date-time, nullable
    - `date_deposit` string, date-time, nullable
    - `date_request` string, date-time, nullable
    - `date_response` string, date-time, nullable
    - `rebill_date` string, date-time, nullable
    - `original_attempt_date` string, date-time, nullable
    - `transaction_parent_id` integer, nullable
    - `parent_date_complete` string, date-time, nullable
    - `transaction_initial_id` integer, nullable
    - `is_prepaid` boolean
    - `customer_card_type_id` null | 1 | 2 | 3 | 4 | 5 | 6 | 7, nullable — * `1` - Mastercard * `2` - Visa * `3` - Discover * `4` - American Express * `5` - Digital Wallet * `6` - ACH * `7` - SEPA
    - `customer_card_bin` string
    - `chargeback_date` string, date-time, nullable
    - `chargeback_code` string, nullable
    - `chargeback_reference_id` string, nullable
    - `chargeback_case_id` string, nullable
    - `transaction_total_usd` string
    - `transaction_shipping_usd` string
    - `transaction_tax_usd` string
    - `transaction_price_usd` string
    - `transaction_discount_total_usd` string
    - `customer_balance_applied_usd` string
    - `transaction_fee_usd` string
    - `gift_card_applied_usd` string
    - `date_created` string, date-time
    - `created_by` integer
    - `modified_by` integer
    - `date_modified` string, date-time
    - `transaction_notes` string, nullable
    - `order` object
      - `order_id` integer
      - `connection_order_id` string, nullable
      - `campaign_id` integer
      - `status_type_id` null | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10, nullable — * `1` - Active * `2` - Cancelled * `3` - Complete * `4` - Partial * `5` - Declined * `6` - Archive * `7` - Rejected * `8` - Removed * `9` - Paused * `10` - Expired
      - `customer_card_id` integer, nullable
      - `customer_id` integer
      - `customers_address_billing_id` integer, nullable
      - `customers_address_shipping_id` integer, nullable
      - `date_created` string, date-time, nullable
      - `date_modified` string, date-time, nullable
      - `date_authorized` string, date-time, nullable
      - `date_auto_capture` string, date-time, nullable
      - `date_ordered` string, date-time, nullable
      - `date_capture` string, date-time, nullable
      - `is_test` boolean
      - `ip_address` string, nullable
      - `order_discount` string
      - `order_pixel` boolean
      - `cart_token` string, nullable
      - `order_pixel_block` string, nullable
      - `order_notes` string, nullable
      - `created_by` integer
      - `modified_by` integer
      - `tracking1` string, nullable
      - `tracking2` string, nullable
      - `tracking3` string, nullable
      - `tracking4` string, nullable
      - `tracking5` string, nullable
      - `tracking6` string, nullable
      - `tracking7` string, nullable
      - `tracking8` string, nullable
      - `tracking9` string, nullable
      - `tracking10` string, nullable
      - `tracking11` string, nullable
      - `tracking12` string, nullable
      - `tracking13` string, nullable
      - `tracking14` string, nullable
      - `tracking15` string, nullable
      - `tracking16` string, nullable
      - `tracking17` string, nullable
      - `tracking18` string, nullable
      - `tracking19` string, nullable
      - `tracking20` string, nullable
      - `user_agent` string, nullable
    - `order_revisions` object[]
      - `order_revision_id` integer
      - `orders_revision_type_id` integer, nullable
      - `order_revision_value` string
      - `order_notes` string
      - `modified_by` integer
      - `date_modified` string, date-time
    - `customer` object
      - `customer_id` integer
      - `connection_customer_id` string, nullable
      - `connection_id` integer
      - `first_name` string
      - `last_name` string
      - `email` string
      - `ip_address` string
      - `phone` string
      - `birthday` string, date, nullable
      - `gender` string
      - `pronoun_id` null | 1 | 2 | 3 | 4, nullable — * `1` - he/him * `2` - she/her * `3` - they/them * `4` - rather not say
      - `active_subscriber` boolean
      - `is_blacklist` boolean
      - `is_fraud` boolean
      - `date_created` string, date-time
      - `date_modified` string, date-time
      - `created_by` integer
      - `modified_by` integer
      - `customer_notes` string, nullable
      - `tracking1` string, nullable
      - `tracking2` string, nullable
      - `tracking3` string, nullable
      - `tracking4` string, nullable
      - `tracking5` string, nullable
      - `tracking6` string, nullable
      - `tracking7` string, nullable
      - `tracking8` string, nullable
      - `tracking9` string, nullable
      - `tracking10` string, nullable
      - `tracking11` string, nullable
      - `tracking12` string, nullable
      - `tracking13` string, nullable
      - `tracking14` string, nullable
      - `tracking15` string, nullable
      - `tracking16` string, nullable
      - `tracking17` string, nullable
      - `tracking18` string, nullable
      - `tracking19` string, nullable
      - `tracking20` string, nullable
      - `customer_cards` object[]
        - `customer_card_id` integer
        - `card_type_id` null | 1 | 2 | 3 | 4 | 5 | 6 | 7, nullable — * `1` - Mastercard * `2` - Visa * `3` - Discover * `4` - American Express * `5` - Digital Wallet * `6` - ACH * `7` - SEPA
        - `card_number` string
        - `card_exp_month` integer
        - `card_exp_year` integer
        - `card_prepaid` boolean
        - `date_created` string, date-time
        - `date_modified` string, date-time
        - `created_by` integer
        - `modified_by` integer
      - `customer_addresses` object[]
        - `customer_address_id` integer
        - `fname` string
        - `lname` string
        - `organization` string
        - `address1` string
        - `address2` string
        - `city` string
        - `country` string
        - `state` string
        - `zipcode` string
        - `address_valid` boolean
        - `date_created` string, date-time
        - `date_modified` string, date-time
        - `created_by` integer
        - `modified_by` integer
    - `customer_card` object
      - `customer_card_id` integer
      - `card_type_id` null | 1 | 2 | 3 | 4 | 5 | 6 | 7, nullable — * `1` - Mastercard * `2` - Visa * `3` - Discover * `4` - American Express * `5` - Digital Wallet * `6` - ACH * `7` - SEPA
      - `card_number` string
      - `card_exp_month` integer
      - `card_exp_year` integer
      - `card_prepaid` boolean
      - `customer_card_merchant_token` string, nullable
      - `date_created` string, date-time
      - `date_modified` string, date-time
      - `created_by` integer
      - `modified_by` integer
    - `customer_address_billing` object
      - `customer_address_id` integer
      - `fname` string
      - `lname` string
      - `organization` string
      - `address1` string
      - `address2` string
      - `city` string
      - `country` string
      - `state` string
      - `zipcode` string
      - `address_valid` boolean
      - `date_created` string, date-time
      - `date_modified` string, date-time
      - `created_by` integer
      - `modified_by` integer
    - `customer_address_shipping` object
      - `customer_address_id` integer
      - `fname` string
      - `lname` string
      - `organization` string
      - `address1` string
      - `address2` string
      - `city` string
      - `country` string
      - `state` string
      - `zipcode` string
      - `address_valid` boolean
      - `date_created` string, date-time
      - `date_modified` string, date-time
      - `created_by` integer
      - `modified_by` integer
    - `merchant` object
      - `merchant_id` integer
      - `merchant_name` string
      - `gateway_id` integer
      - `currency_id` integer — Default currency
      - `merchant_mid_id` string
      - `merchant_descriptor` string
      - `merchant_phone` string
      - `merchant_url` string
      - `merchant_active` boolean
      - `merchant_processor` string, nullable
      - `merchant_mcc_code` string, nullable
      - `merchant_processing_limit` string
      - `merchant_processing_inforce` boolean
      - `merchant_daily_rebills_limit` string
      - `merchant_state` string, nullable
      - `merchant_tax` string
      - `merchant_mtd_revenue` string
      - `merchant_mtd_transactions` integer
      - `merchant_mtd_initial` integer
      - `merchant_processing_perc` string
      - `primary_merchant_category_id` integer
      - `secondary_merchant_category_id` integer
      - `merchant_notes` string, nullable
      - `date_created` string, date-time
      - `created_by` integer
      - `date_modified` string, date-time
      - `modified_by` integer
      - `merchant_currencies` object[]
        - `currency_id` integer
        - `currency_value` string
      - `merchant_payment_methods` object[]
        - `payment_method_id` integer
        - `payment_method_name` string
      - `merchant_card_types` object[]
        - `card_type_id` integer
        - `card_type_name` string
      - `primary_merchant_category` object, nullable
        - `merchant_category_id` integer
        - `merchant_category_name` string
      - `secondary_merchant_category` object, nullable
        - `merchant_category_id` integer
        - `merchant_category_name` string
    - `campaign` object
      - `campaign_id` integer
      - `campaign_name` string
    - `sale` object
      - `sale_id` integer
      - `order_id` integer
      - `customer_id` integer
      - `customer_name` string
      - `status` string
      - `cycle` integer
      - `currency_id` integer
      - `price` string
      - `discount_total` string
      - `shipping` string
      - `sub_total` string
      - `tax` string
      - `gift_card_applied` string
      - `total` string
      - `date_sale` string, date-time, nullable
      - `date_attempt` string, date-time, nullable
    - `credits` object[]
      - `transaction_id` integer
      - `connection_transaction_id` string, nullable
      - `customer_id` integer
      - `order_id` integer
      - `payment_method_id` 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 — * `1` - Credit Card * `2` - Check * `3` - Google Pay * `4` - Apple Pay * `5` - Cash * `6` - Paypal * `7` - Alternative Payments Sofort * `8` - Alternative Payments POLi * `9` - Alternative Payments SEPA * `10` - ACH * `11` - Afterpay * `12` - Klarna * `13` - SEPA
      - `transaction_type_id` 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 — * `1` - Sale * `2` - Refund * `3` - Void * `4` - Chargeback * `5` - Alert * `6` - Auth * `7` - Capture * `8` - COD * `9` - Chargeback Reversal * `10` - Returned Check
      - `transaction_cycle` integer
      - `transaction_attempt` integer
      - `transaction_declined` boolean
      - `merchant_id` integer
      - `transaction_merchant_descriptor` string
      - `response_code` integer, nullable
      - `transaction_3ds_verified_status` string, nullable
      - `gateway_response_id` string, nullable
      - `gateway_auth_code` string, nullable
      - `gateway_response_code` string, nullable
      - `gateway_response_description` string, nullable
      - `gateway_response_avs` string, nullable
      - `gateway_response_cvv` string, nullable
      - `processor_response_text` string, nullable
      - `currency_id` integer
      - `transaction_price` string
      - `transaction_discount_total` string
      - `transaction_shipping` string
      - `transaction_sub_total` string
      - `transaction_tax` string
      - `transaction_fee` string
      - `customer_balance_applied` string
      - `gift_card_applied` string
      - `transaction_total` string
      - `order_discount_total` string
      - `check_number` string, nullable
      - `check_amount` string
      - `dunning_cycle_id` integer, nullable
      - `dunning_cycle_total` string
      - `quantity_discount_cycle_id` integer, nullable
      - `quantity_discount_cycle_total` string
      - `discount_cycle_id` integer, nullable
      - `discount_cycle_total` string
      - `date_scheduled` string, date-time
      - `date_complete` string, date-time, nullable
      - `date_cancelled` string, date-time, nullable
      - `date_skip` string, date-time, nullable
      - `date_batch` string, date-time, nullable
      - `date_deposit` string, date-time, nullable
      - `date_request` string, date-time, nullable
      - `date_response` string, date-time, nullable
      - `rebill_date` string, date-time, nullable
      - `original_attempt_date` string, date-time, nullable
      - `transaction_parent_id` integer, nullable
      - `parent_date_complete` string, date-time, nullable
      - `transaction_initial_id` integer, nullable
      - `is_prepaid` boolean
      - `customer_card_type_id` null | 1 | 2 | 3 | 4 | 5 | 6 | 7, nullable — * `1` - Mastercard * `2` - Visa * `3` - Discover * `4` - American Express * `5` - Digital Wallet * `6` - ACH * `7` - SEPA
      - `customer_card_bin` string
      - `chargeback_date` string, date-time, nullable
      - `chargeback_code` string, nullable
      - `chargeback_reference_id` string, nullable
      - `chargeback_case_id` string, nullable
      - `transaction_total_usd` string
      - `transaction_shipping_usd` string
      - `transaction_tax_usd` string
      - `transaction_price_usd` string
      - `transaction_discount_total_usd` string
      - `customer_balance_applied_usd` string
      - `transaction_fee_usd` string
      - `gift_card_applied_usd` string
      - `date_created` string, date-time
      - `created_by` integer
      - `modified_by` integer
      - `date_modified` string, date-time
      - `transaction_notes` string, nullable
    - `line_items` object[]
      - `line_item_id` integer
      - `customer_id` integer
      - `order_id` integer
      - `order_offer_id` integer
      - `offer_id` integer
      - `offer_name` string
      - `offer_quantity` integer
      - `item_id` integer
      - `item_name` string
      - `item_quantity` integer
      - `campaign_id` integer
      - `campaign_name` string
      - `transaction_status` string
      - `line_item_cycle` integer
      - `currency_id` integer
      - `is_test` boolean
      - `is_upsell` boolean
      - `status_type_id` null | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10, nullable — * `1` - Active * `2` - Cancelled * `3` - Complete * `4` - Partial * `5` - Declined * `6` - Archive * `7` - Rejected * `8` - Removed * `9` - Paused * `10` - Expired
      - `discount_code` string, nullable
      - `line_item_price` string
      - `line_item_discount_total` string
      - `line_item_shipping` string
      - `line_item_sub_total` string
      - `line_item_tax` string
      - `customer_balance_applied` string
      - `gift_card_applied` string
      - `line_item_total` string
      - `line_item_price_usd` string
      - `line_item_discount_total_usd` string
      - `line_item_shipping_usd` string
      - `line_item_tax_usd` string
      - `customer_balance_applied_usd` string
      - `gift_card_applied_usd` string
      - `line_item_total_usd` string
      - `date_complete` string, date-time, nullable
      - `linked_order_offer_id` integer, nullable
      - `linked_transaction_cycle` integer, nullable
      - `linked_transaction_attempt` integer, nullable
      - `linked_status_type_id` null | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10, nullable — * `1` - Active * `2` - Cancelled * `3` - Complete * `4` - Partial * `5` - Declined * `6` - Archive * `7` - Rejected * `8` - Removed * `9` - Paused * `10` - Expired
      - `linked_is_recurring` boolean, nullable
      - `line_item_shipments` object[]
        - `shipment_item_id` integer
        - `quantity` integer
        - `item_id` integer
        - `item_name` string
        - `item_description` string, nullable
        - `item_additional_description` string, nullable
        - `item_image` string, nullable
        - `shipment_item_sku` string, nullable
        - `items_option_variation_id` integer, nullable
    - `shipments` object[]
      - `shipment_id` integer
      - `connection_shipment_id` string, nullable
      - `customer_id` integer
      - `order_id` integer
      - `shipment_prepaid_cycle` integer
      - `shipment_status_id` 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 — * `1` - Pending Post * `2` - Pending Tracking * `3` - Cancelled * `4` - Shipped * `5` - Error * `6` - Delivered * `7` - Declined * `8` - Pending Transaction * `9` - Skipped
      - `transaction_charge_id` integer
      - `connection_id` integer, nullable
      - `fulfillment_id` string, nullable
      - `shipment_tracking_id` string, nullable
      - `carrier_id` null | 1 | 2 | 3 | 4 | 5 | 6 | 8 | 9, nullable — * `1` - USPS * `2` - UPS * `3` - FedEx * `4` - DHL eCommerce * `5` - UPS Mail Innovations * `6` - Canada Post * `8` - Australia Post * `9` - Hermes
      - `shipping_profile_id` integer, nullable
      - `date_cancel` string, date-time, nullable
      - `date_scheduled` string, date-time
      - `date_complete` string, date-time, nullable
      - `date_scan` string, date-time, nullable
      - `date_deliver` string, date-time, nullable
      - `date_return` string, date-time, nullable
      - `date_skip` string, date-time, nullable
      - `date_rma` string, date-time, nullable
      - `shipment_rma` string, nullable
      - `cancel_type_id` integer, nullable
      - `skip_type_id` integer, nullable
      - `shipping_reship_type_id` null | 1 | 2 | 3 | 4, nullable — * `1` - Did not receive package * `2` - Damaged Items * `3` - Items Incorrect * `4` - Quantity Incorrect
      - `shipment_parent_type_id` null | 1 | 2 | 3 | 4, nullable — * `1` - Reship * `2` - Reward * `3` - Gift * `4` - Free
      - `date_created` string, date-time
      - `created_by` integer
      - `date_modified` string, date-time
      - `modified_by` integer
      - `shipment_notes` string, nullable
      - `connection_request_text` string, nullable
      - `connection_response_text` string, nullable
      - `shipment_items` object[]
        - `shipment_item_id` integer
        - `quantity` integer
        - `item_id` integer
        - `item_name` string
        - `item_description` string, nullable
        - `item_additional_description` string, nullable
        - `item_image` string, nullable
        - `shipment_item_sku` string, nullable
        - `items_option_variation_id` integer, nullable
      - `customer_address_billing` object
        - `customer_address_id` integer
        - `fname` string
        - `lname` string
        - `organization` string
        - `address1` string
        - `address2` string
        - `city` string
        - `country` string
        - `state` string
        - `zipcode` string
        - `address_valid` boolean
        - `date_created` string, date-time
        - `date_modified` string, date-time
        - `created_by` integer
        - `modified_by` integer
      - `customer_address_shipping` object
        - `customer_address_id` integer
        - `fname` string
        - `lname` string
        - `organization` string
        - `address1` string
        - `address2` string
        - `city` string
        - `country` string
        - `state` string
        - `zipcode` string
        - `address_valid` boolean
        - `date_created` string, date-time
        - `date_modified` string, date-time
        - `created_by` integer
        - `modified_by` integer
      - `campaign` object
        - `campaign_id` integer
        - `campaign_name` string
      - `connection` object, nullable
        - `connection_id` integer
        - `connection_name` string
      - `tracking_history` object[]
        - `tracking_history_id` integer
        - `carrier_id` integer, nullable
        - `date` string, date-time, nullable
        - `category_id` integer, nullable
        - `category_name` string, nullable
        - `status_id` integer, nullable
        - `status_text` string, nullable
      - `actions` object
        - `can_change_address` boolean
        - `can_process` boolean
        - `can_reschedule` boolean
        - `can_rma` boolean
        - `can_skip` boolean
        - `can_swap` boolean
        - `can_unskip` boolean
    - `route_logs` object[]
      - `route_log_id` integer
      - `route_id` integer
      - `order_id` integer
      - `merchant_id` integer
      - `card_type_id` null | 1 | 2 | 3 | 4 | 5 | 6 | 7, nullable — * `1` - Mastercard * `2` - Visa * `3` - Discover * `4` - American Express * `5` - Digital Wallet * `6` - ACH * `7` - SEPA
      - `card_type_name` string
      - `reason` string
      - `date_complete` string, date-time
      - `date_created` string, date-time
      - `created_by` integer
    - `actions` object
      - `can_process` boolean
      - `can_reorder` boolean
      - `can_reschedule` boolean
      - `can_skip` boolean
      - `can_unskip` boolean

## Other responses

- `401` — Unauthorized response
- `403` — Forbidden response
- `500` — Error response

---

[API](https://skmtc.net/vrio/apis/crm-configuration.md) · [All operations](https://skmtc.net/vrio/apis/crm-configuration/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/vrio/crm-configuration/versions/62037010356e/schema)