Authorizations

Returns a list of Issuing Authorization objects. The objects are sorted in descending order by creation date, with the most recently created object appearing first.

View-Specific Information

SELECT

The connector uses the Stripe API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the connector.


Column	Supported Operators
Id	=
CardId	=
CardCardholderId	=
Status	=
Created	=, >, >=, <, <=

You can select from Authorizations with the following queries:

    SELECT * FROM Authorizations WHERE CardId = 'ic_1Nsse72eZvKYlo2CWBGm2WQ5'
    SELECT * FROM Authorizations WHERE CardCardholderId = 'ich_1NpvWO2eZvKYlo2CAQ7YPOvp'
    SELECT * FROM Authorizations WHERE Id = 'iauth_1ObVV22eZvKYlo2C9UYAEpOT'
	SELECT * FROM Authorizations WHERE Status = 'closed'

Columns


Name	Type	References	Description
Id [KEY]	String		The unique identifier for the authorization.
Amount	Integer		The total amount that was authorized or rejected.
AmountDetailsAtmFee	Integer		The fee charged by the ATM for the cash withdrawal.
AmountDetailsCashbackAmount	Integer		The amount of cash requested by the cardholder.
Approved	Boolean		Indicates whether the authorization has been approved.
AuthorizationMethod	String		Indicates how the card details were provided.
BalanceTransactions	String		A list of balance transactions associated with this authorization.
CardId	String		The unique identifier for the card.
CardObject	String		The string representing the object's type. Objects of the same type share the same value.
CardBrand	String		The brand of the card.
CardCancellation_reason	String		The reason why the card was canceled.
CardCardholderId	String		The unique identifier for the cardholder.
CardCardholderObject	String		The string representing the object's type. Objects of the same type share the same value.
CardCardholderBillingAddressCity	String		City, district, suburb, town, or village.
CardCardholderBillingAddressCountry	String		The two-letter country code.
CardCardholderBillingAddressLine1	String		Address line 1 (for example, street, PO Box, or company name).
CardCardholderBillingAddressLine2	String		Address line 2 (for example, apartment, suite, unit, or building).
CardCardholderBillingAddressPostalCode	String		ZIP or postal code.
CardCardholderBillingAddressState	String		State, county, province, or region.
CardCardholderCompanyTaxIdProvided	Boolean		Indicates whether the company's business Id number was provided.
CardCardholderCreated	Datetime		The time at which the object was created, measured in seconds since the Unix epoch.
CardCardholderEmail	String		The cardholder's email address.
CardIssuingUserTermsAcceptanceDate	Datetime		The Unix timestamp marking when the cardholder accepted the Authorized User Terms.
CardIssuingUserTermsAcceptanceIP	String		The IP address from which the cardholder accepted the Authorized User Terms.
CardIssuingUserTermsAcceptanceUserAgent	String		The user agent of the browser from which the cardholder accepted the Authorized User Terms.
CardCardholderDOBDay	Integer		The day of birth, between 1 and 31.
CardCardholderDOBMonth	Integer		The month of birth, between 1 and 12.
CardCardholderDOBYear	Integer		The four-digit year of birth.
CardCardholderFirstName	String		The first name of this cardholder.
CardCardholderLastName	String		The last name of this cardholder.
CardCardholderVerficationDocBack	String		The back of a document returned by a file upload with a purpose value of identity_document.
CardCardholderVerficationDocFront	String		The front of a document returned by a file upload with a purpose value of identity_document.
CardCardholderLivemode	Boolean		Indicates whether the object exists in live mode. Returns false if the object exists in test mode.
CardCardholderMetadataAggregate	String		The set of key-value pairs that you can attach to the object.
CardCardholderName	String		The cardholder's name. This will be printed on cards issued to them.
CardCardholderPhoneNumber	String		The cardholder's phone number. This is required for all cardholders who will be creating EU cards.
CardCardholderPreferredLocales	String		The cardholder's preferred locales (languages), ordered by preference.
CardCardholderRequirementsDisabledReason	String		The reason the cardholder is disabled. If present, all cards decline authorizations with the cardholder_verification_required reason.
CardCardholderRequirementsPastDue	String		An array of fields that need to be collected in order to verify and re-enable the cardholder.
CardCardholderSpendingControlsAllowedCategories	String		An array of strings containing categories of authorizations to allow.
CardCardholderSpendingControlsBlockedCategories	String		An array of strings containing categories of authorizations to decline.
CardCardholderSpendingControlsSpendingLimits	String		The amount-based rules that limit spending across this cardholder's cards.
CardCardholderSpendingControlsSpendingLimitsCurrency	String		The currency of the amounts within spending_limits.
CardCardholderStatus	String		Specifies whether to permit authorizations on this cardholder's cards.
CardCardholderType	String		The type of cardholder. One of individual or company.
CardCreated	Datetime		The time at which the object was created, measured in seconds since the Unix epoch.
CardCurrency	String		Three-letter ISO currency code, in lowercase.
CardCVC	String		The card's CVC. For security reasons, this is only available for virtual cards and is omitted unless you explicitly request it with the expand parameter.
CardExpMonth	Integer		The expiration month of the card.
CardExpYear	Integer		The expiration year of the card.
CardLast4	String		The last 4 digits of the card number.
CardLivemode	Boolean		Indicates whether the object exists in live mode. Returns false if the object exists in test mode.
CardMetadataAggregate	String		The set of key-value pairs that you can attach to the object.
CardNumber	String		The full unredacted card number.
CardReplacedBy	String		The latest card that replaces this card, if any.
CardReplacementFor	String		The card this card replaces, if any.
CardReplacementReason	String		The reason why the previous card needed to be replaced.
CardShipping	String		Where and how the card will be shipped.
CardCardholderSpendingControlsAllowedMerchantCountries	String		An array of strings representing countries from which authorizations are allowed. Authorizations from merchants in all other countries are declined. Country codes should be ISO 3166 alpha-2 country codes, such as US. Cannot be set with blocked_merchant_countries. Provide an empty value to unset this control.
CardCardholderSpendingControlsBlockedMerchantCountries	String		An array of strings representing countries from which authorizations are declined. Country codes should be ISO 3166 alpha-2 country codes, such as US. Cannot be set with allowed_merchant_countries. Provide an empty value to unset this control.
CardPersonalizationDesign	String		The personalization design object belonging to this card.
CardSpendingControlsAllowedCategories	String		An array of strings containing categories of authorizations to allow. All other categories are blocked. Cannot be set with blocked_categories.
CardSpendingControlsAllowedMerchantCountries	String		An array of strings representing countries from which authorizations are allowed. Authorizations from merchants in all other countries are declined. Country codes should be ISO 3166 alpha-2 country codes, such as US. Cannot be set with blocked_merchant_countries. Provide an empty value to unset this control.
CardSpendingControlsBlockedCategories	String		An array of strings containing categories of authorizations to decline. All other categories are allowed. Cannot be set with allowed_categories.
CardSpendingControlsBlockedMerchantCountries	String		An array of strings representing countries from which authorizations are declined. Country codes should be ISO 3166 alpha-2 country codes, such as US. Cannot be set with allowed_merchant_countries. Provide an empty value to unset this control.
CardSpendingControlsSpendingLimits	String		The amount-based rules that limit spending across any cards this card replaced, including its replacement_for card and that card's replacement_for card, up the chain.
CardSpendingControlsSpendingLimitsCurrency	String		The currency of the amounts within spending_limits. Always the same as the currency of the card.
CardType	String		The type of the card. Possible values: physical, virtual.
CardWalletsApplePayEligible	Boolean		Indicates whether the card is eligible for Apple Pay.
CardWalletsApplePayIneligibleReason	String		The reason the card is ineligible for Apple Pay.
CardWalletsGooglePayEligible	Boolean		Indicates whether the card is eligible for Google Pay.
CardWalletsGooglePayIneligibleReason	String		The reason the card is ineligible for Google Pay.
CardWalletsPrimaryAccountIdentifier	String		Unique identifier for a card used with digital wallets.
Cardholder	String		The cardholder to whom this authorization belongs.
Created	Datetime		The time at which the object was created, measured in seconds since the Unix epoch.
Status	String		The current status of the authorization in its lifecycle. The allowed values are closed, pending, reversed.

Tableau Connector for Stripe

Authorizations

View-Specific Information

SELECT

Columns