Tableau Connector for Stripe

Build 21.0.7930

Accounts

Create, update, delete, and query the Accounts you manage in Stripe.

Table Specific Information

Select

Server-Side Query Support

The connector will use 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 operators:=.

The provider supports all columns to be used as criteria in the Where clause of Select statement, as long as SupportEnhancedSQL is set to True. If SupportEnhancedSQL property is set to False, you still can retreive an Account by specifying its Id:

SELECT * FROM Accounts WHERE Id='MyId'

Insert

To create a new account, Email is required if Managed is not specified or is set to false and RequestedCapabilities is required. RequestedCapabilities is an aggregate column. See the example below on how to insert into this column.

INSERT INTO Accounts (RequestedCapabilities, Country, Email, Managed) VALUES ('{"0": "card_payments","1": "transfers"}', 'US','test@sab.com',false)

Update

To update an Account, specify Id of the Account:

UPDATE Accounts SET BusinessName='My Business Name', BusinessPrimaryColor='#666666', SupportPhone='+355696977888' WHERE Id='acct_1A0XVyFF36eOzuU5'

Delete

To delete an Account, specify the Id of the account.

DELETE FROM Account WHERE Id = 'acct_1A0XVyFF36eOzuU5'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

The unique identifier for the account.

BusinessName String False

The publicly visible name of the business.

BusinessPrimaryColor String False

A CSS hex color value representing the primary branding color for this account.

BusinessUrl String False

The publicly visible website of the business.

ChargesEnabled Boolean True

Whether or not the account can create live charges.

Country String False

The country of the account.

CurrenciesSupportedAggregate String False

Supported currencies.

DebitNegativeBalances Boolean False

Whether or not Stripe will attempt to reclaim negative account balances from the bank account for this account.

DeclineChargeOnAvsFailure Boolean False

Whether or not Stripe should automatically decline charges with an incorrect zip/postal code.

DeclineChargeOnCvcFailure Boolean False

Whether or not Stripe should automatically decline charges with an incorrect CVC.

DefaultCurrency String False

The currency this account has chosen to use as the default.

DetailsSubmitted Boolean False

Whether or not account details have been submitted yet. Standalone accounts cannot receive transfers before this is true.

DisplayName String False

The display name for this account. This is used on the Stripe dashboard to help you differentiate between accounts.

Email String False

The primary email address of the user.

ExternalAccountsAggregate String False

External accounts (bank accounts and/or cards) currently attached to this account.

LegalEntity String False

Information regarding the owner of this account, including verification status.

Managed Boolean False

Whether or not the account is managed by your platform. Returns null if the account was not created by a platform.

ProductDescription String False

An internal-only description of the product or service provided. This is used by Stripe in the event the account gets flagged for potential fraud.

StatementDescriptor String False

The text that will appear on credit card statements.

SupportEmail String False

The publicly shareable email address that can be reached for support for this account.

SupportPhone String False

The publicly visible support phone number for the business.

SupportUrl String False

The publicly shareable URL that can be reached for support for this account

Timezone String False

The timezone used in the Stripe dashboard for this account.

TosAcceptance String False

Who accepted the Stripe terms of service, and when they accepted it.

TransferSchedule String False

When payments collected will be automatically paid out to the bank account of the account holder.

Verification String True

The state of the information requests for the account, including what information is needed and by when it must be provided.

TransfersEnabled Boolean True

Whether or not Stripe will send automatic transfers for this account.

MetadataAggregate String False

The account metadata object.

Capabilities String False

The account metadata object.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
AccountId String

The Id of the connected account

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930