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 provider 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 provider.
| 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. |