Query the merchant-level settings for Square online checkout. This is a read-only single-row view.

Table Specific Information

Select

The connector will execute all filters to this table client-side, in memory.

Retrieve the merchant-level checkout settings:

SELECT * FROM CheckoutMerchantSettings

Columns

Name	Type	Description
MerchantId	String	The Square-assigned merchant ID for these settings.
PaymentMethodsApplePayEnabled	Boolean	Indicates whether Apple Pay is enabled for the merchant's checkout experience.
PaymentMethodsGooglePayEnabled	Boolean	Indicates whether Google Pay is enabled for the merchant's checkout experience.
PaymentMethodsCashAppPayEnabled	Boolean	Indicates whether Cash App Pay is enabled for the merchant's checkout experience.
PaymentMethodsAfterpayEnabled	Boolean	Indicates whether Afterpay/Clearpay is enabled for the merchant's checkout experience.
AfterpayOrderEligibilityRangeMinAmount	Integer	The minimum order amount in smallest currency denomination for Afterpay/Clearpay eligibility.
AfterpayOrderEligibilityRangeMinCurrency	String	The currency for the minimum order eligibility amount, in ISO 4217 format.
AfterpayOrderEligibilityRangeMaxAmount	Integer	The maximum order amount in smallest currency denomination for Afterpay/Clearpay eligibility.
AfterpayOrderEligibilityRangeMaxCurrency	String	The currency for the maximum order eligibility amount, in ISO 4217 format.
AfterpayItemEligibilityRangeMinAmount	Integer	The minimum item amount in smallest currency denomination for Afterpay/Clearpay eligibility.
AfterpayItemEligibilityRangeMinCurrency	String	The currency for the minimum item eligibility amount, in ISO 4217 format.
AfterpayItemEligibilityRangeMaxAmount	Integer	The maximum item amount in smallest currency denomination for Afterpay/Clearpay eligibility.
AfterpayItemEligibilityRangeMaxCurrency	String	The currency for the maximum item eligibility amount, in ISO 4217 format.
UpdatedAt	String	A read-only timestamp in RFC 3339 format indicating when these settings were last updated.