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 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.
- Id support the following operator: =.
- CardId support the following operator: =.
- CardCardholderId support the following operator: =.
- Status support the following operator: =.
- Created support the following operator: =.
The provider supports the use of all columns as criteria in the WHERE clause of SELECT statements, as long as SupportEnhancedSQL is set to True. If SupportEnhancedSQL property is set to False, you still can retrieve:
To query the Authorizations we can try the below queries.
SELECT * from Authorizations
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. |