TenderTransactions
Returns a list of TenderTransactions associated with the shop.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following columns and operators:
- Id supports the '=,IN' comparison operators.
- Test supports the '=,!=' comparison operators.
- ProcessedAt supports the '=,!=,<,>,>=,=<' comparison operators.
The connector processes other filters client-side within the connector.
For example, the following queries are processed server-side:
SELECT * FROM TenderTransactions WHERE Id='VALUE'
SELECT * FROM TenderTransactions WHERE Test='true'
SELECT * FROM TenderTransactions WHERE ProcessedAt<'2000-01-01 01:00:00.0'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | A globally-unique ID. | |
| Test | Bool | Whether the transaction is a test transaction. | |
| PaymentMethod | String | Information about the payment method used for the transaction. | |
| ProcessedAt | Datetime | Date and time when the transaction was processed. | |
| RemoteReference | String | The remote gateway reference associated with the tender transaction. | |
| AmountAmount | Decimal | Decimal money amount. | |
| AmountCurrencyCode | String | Currency of the money. | |
| TenderTransactionCreditCardDetailsCreditCardCompany | String | The name of the company that issued the customer's credit card. Example: 'Visa'. | |
| TenderTransactionCreditCardDetailsCreditCardNumber | String | The customer's credit card number, with all digits except the last 4 redacted. Example: '???? ???? ???? 1234' | |
| UserId | String | A globally-unique ID.(This column is available only with a ShopifyPlus subscription) |