CData Python Connector for Stripe

Build 23.0.8839

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839