Tableau Connector for Stripe

Build 21.0.7930

Products

Query the available products 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, Active, Created, Shippable, Type, Url support the following operators : IN,<,>>=, <, <=, =.

The following query retrieves all products:

SELECT * FROM Products

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:

-a Product by specifying its Id:

SELECT * FROM Products WHERE Id='12345678'

-a Product by specifying its Ids:

SELECT * FROM Products WHERE Id IN ('12345678','123456789','123456788',)

-Products that can be shipped:

SELECT * FROM Products WHERE Shippable='true'

-Products for a given URL:

SELECT * FROM Products WHERE URL='/v1/skus?product=1234\u0026active=true'

-Active Products:

SELECT * FROM Products WHERE Active=True

-Products created after a certain date (Created may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range):

SELECT * FROM Products WHERE Created>'12/1/2015'

Columns

Name Type References Description
Id [KEY] String ID of product.
Active Boolean Whether or not the product is currently available for purchase.
AttributesAggregate String A list of up to 5 attributes that each SKU can provide value.
Caption String A short one-line description of the product, meant to be displayable to the customer.
Created Datetime The time when product is created.
Description String The product's description, meant to be displayable to the customer.
Name String The product's name, meant to be displayable to the customer.
PackageDimensionsHeight Double The height dimension of this product for shipping purposes.
PackageDimensionsLength Double The length dimension of this product for shipping purposes.
PackageDimensionsWeight Double The weight dimension of this product for shipping purposes.
PackageDimensionsWidth Double The width dimension of this product for shipping purposes.
Shippable Boolean Whether this product is a shipped good.
StatementDescriptor String Extra information about a charge for the credit card statement of the customer.
Updated Datetime The last updated time.
Type String The type of the product..
Skus String A sublist of active SKUs associated with this product.
Url String The URL of a publicly-accessible webpage for this product.

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 to get products for.

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