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. The connector processes other filters client-side within the connector.
- Id supports the '=,IN' comparison operators.
- Test supports the '=,!=' comparison operators.
- ProcessedAt supports the '=,!=,<,>,>=,=<' comparison operators.
For example, the following queries are processed server side:
SELECT * FROM TenderTransactions
SELECT * FROM TenderTransactions WHERE Id = 'Val1'
SELECT * FROM TenderTransactions WHERE Test = true
SELECT * FROM TenderTransactions WHERE ProcessedAt = '2023-01-01 11:10:00'
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) |