Tableau Connector for Stripe

Build 21.0.7930

SubscriptionItems

Create, update, delete, and query the available subscription items 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, SubscriptionId support the following operators:=.

To query SubscriptionItems table, the Id of the subscription (SubscriptionId) whose items will be retrieved is required:

SELECT * FROM Subscriptions WHERE SubscriptionId='sub_A9WZGVTbvgBJ4t'

In addition to SubscriptionId, 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 SubscriptionItem by specifying its Id:

SELECT * FROM SubscriptionItems WHERE Id='sit_A9WZGVTbvgBJ4t'

Insert

SubscriptionId and PlanId columns are required to create a new subscription item.

INSERT INTO SubscriptionItems(SubscriptionId,PlanId,IsProrate,ProrationDate,Quantity) VALUES ('sub_A9YR1bLGFLQ5vV','gold $',true,2014-12-12,10)

Update

To update a subscription item, specify the Id column.

UPDATE SubscriptionItems SET PlanId = 'sub_A8TYczJcECr7Ph', IsProrate=false,ProrationDate='2014-12-12', Quantity=12 WHERE Id ='set_g155'

Delete

To delete a subscription item specify the Id of the item.

DELETE FROM SubscriptionItems WHERE Id = 'sit_A9WZGVTbvgBJ4t'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

The Id of the subscription item.

SubscriptionId String False

Subscriptions.Id

The Id of the subscription.

PlanId String False

Plans.Id

The Id of the plan.

Quantity Double False

The quantity of the plan to which the customer should be subscribed.

Created Datetime True

Creation date.

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
IsProrate Boolean

Flag indicating whether to prorate switching plans during a billing cycle.

ProrationDate Date

If set, the proration will be calculated as though the subscription was updated at the given time.

AccountId String

The Id of the connected account to get subscription items for

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