SSIS Components for Shopify

Build 24.0.9060

TenderTransactions

Returns a list of TenderTransactions associated with the shop.

View-Specific Information

Select

The component 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 component processes other filters client-side within the component.

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)

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060