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.
Table Specific Information
Select
Server-Side Query Support
The 本製品 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 本製品.
- Id supports the following operator: =.
- CardId supports the following operator: =.
- CardCardholderId supports the following operator: =.
- Status supports the following operator: =.
- Created supports the following operator: =.
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'
Columns
Name | Type | References | Description |
Id [KEY] | String | Unique identifier for the object. | |
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 | Whether the authorization has been approved. | |
AuthorizationMethod | String | How the card details were provided. | |
BalanceTransactions | String | List of balance transactions associated with this authorization. | |
CardId | String | Unique identifier for the object. | |
CardObject | String | String representing the objects 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 | Unique identifier for the object. | |
CardCardholderObject | String | String representing the objects type. Objects of the same type share the same value. | |
CardCardholderBillingAddressCity | String | City, district, suburb, town, or village. | |
CardCardholderBillingAddressCountry | String | Two-letter country code | |
CardCardholderBillingAddressLine1 | String | Address line 1 | |
CardCardholderBillingAddressLine2 | String | Address line 2 | |
CardCardholderBillingAddressPostalCode | String | ZIP or postal code. | |
CardCardholderBillingAddressState | String | State, county, province, or region. | |
CardCardholderCompanyTaxIdProvided | Boolean | Whether the companys business ID number was provided. | |
CardCardholderCreated | Datetime | Time at which the object was created. Measured in seconds since the Unix epoch. | |
CardCardholderEmail | String | The cardholders 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 | Has the value true if the object exists in live mode or the value false if the object exists in test mode. | |
CardCardholderMetadataAggregate | String | The set of key/value pairs that you can attach to a an object. | |
CardCardholderName | String | The cardholders name. This will be printed on cards issued to them. | |
CardCardholderPhoneNumber | String | The cardholders phone number. This is required for all cardholders who will be creating EU cards. | |
CardCardholderPreferredLocales | String | The cardholders preferred locales (languages), ordered by preference. | |
CardCardholderRequirementsDisabledReason | String | If disabled_reason is present, all cards will decline authorizations with cardholder_verification_required reason. | |
CardCardholderRequirementsPastDue | String | Array of fields that need to be collected in order to verify and re-enable the cardholder. | |
CardCardholderSpendingControlsAllowedCategories | String | Array of strings containing categories of authorizations to allow. | |
CardCardholderSpendingControlsBlockedCategories | String | Array of strings containing categories of authorizations to decline. | |
CardCardholderSpendingControlsSpendingLimits | String | Limit spending with amount-based rules that apply across this cardholders cards. | |
CardCardholderSpendingControlsSpendingLimitsCurrency | String | Currency of the amounts within spending_limits. | |
CardCardholderStatus | String | Specifies whether to permit authorizations on this cardholder’s cards. | |
CardCardholderType | String | One of individual or company. | |
CardCreated | Datetime | 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 cards CVC. For security reasons, this is only available for virtual cards, and will be 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 | Has the value true if the object exists in live mode or the value false if the object exists in test mode. | |
CardMetadataAggregate | String | The set of key/value pairs that you can attach to a an 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 | Array of strings containing representing countries from which authorizations will be allowed. Authorizations from merchants in all other countries will be declined. Country codes should be ISO 3166 alpha-2 country codes (e.g. US). Cannot be set with blocked_merchant_countries. Provide an empty value to unset this control. | |
CardCardholderSpendingControlsBlockedMerchantCountries | String | Array of strings containing representing countries from which authorizations will be declined. Country codes should be ISO 3166 alpha-2 country codes (e.g. 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 | Array of strings containing categories of authorizations to allow. All other categories will be blocked. Cannot be set with blocked_categories. | |
CardSpendingControlsAllowedMerchantCountries | String | Array of strings containing representing countries from which authorizations will be allowed. Authorizations from merchants in all other countries will be declined. Country codes should be ISO 3166 alpha-2 country codes (e.g. US). Cannot be set with blocked_merchant_countries. Provide an empty value to unset this control. | |
CardSpendingControlsBlockedCategories | String | Array of strings containing categories of authorizations to decline. All other categories will be allowed. Cannot be set with allowed_categories. | |
CardSpendingControlsBlockedMerchantCountries | String | Array of strings containing representing countries from which authorizations will be declined. Country codes should be ISO 3166 alpha-2 country codes (e.g. US). Cannot be set with allowed_merchant_countries. Provide an empty value to unset this control. | |
CardSpendingControlsSpendingLimits | String | Limit spending with amount-based rules that apply across any cards this card replaced (i.e., its replacement_for card and that card’s replacement_for card, up the chain). | |
CardSpendingControlsSpendingLimitsCurrency | String | Currency of the amounts within spending_limits. Always the same as the currency of the card. | |
CardType | String | The type of the card. Possible enum values: physical, virtual. | |
CardWalletsApplePayEligible | Boolean | Apple Pay Eligibility. | |
CardWalletsApplePayIneligibleReason | String | Reason the card is ineligible for Apple Pay. | |
CardWalletsGooglePayEligible | Boolean | Google Pay Eligibility. | |
CardWalletsGooglePayIneligibleReason | String | 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. |