TestClocks

Create, delete, and query the available TestClocks in Stripe.

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 supports the following operator: =.

You can select from the TestClocks table with the following queries:

SELECT * FROM TestClocks WHERE Name = 'TestName'
SELECT * FROM TestClocks WHERE Status = 'active'
SELECT * FROM TestClocks WHERE Created > '2024-01-01'
SELECT * FROM TestClocks WHERE DeletesAfter < '2025-01-01'
SELECT * FROM TestClocks WHERE Id = 'clock_1PYNnU2eZvKYlo2CNSmVfWJP'

Insert

To create a new TestClock, the FrozenTime column is required:

INSERT INTO TestClocks (FrozenTime, Name) VALUES ('2024-07-03', 'TestName')

Delete

To delete a TestClock, specify the Id:

DELETE FROM TestClocks WHERE Id = 'clock_1PYNnU2eZvKYlo2CNSmVfWJP'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Unique identifier for the object.
Name	String	False		The custom name supplied at creation.
Status	String	True		The status of the Test Clock.
Created	Datetime	True		Time at which the object was created. Measured in seconds since the Unix epoch.
DeletesAfter	Datetime	True		Time at which this clock is scheduled to auto delete.
FrozenTime	Datetime	False		The initial frozen time for this test clock.
Livemode	Boolean	True		Has the value true if the object exists in live mode or the value false if the object exists in test mode.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
AccountId	String	The Id of the connected account to get coupons for.

Tableau Connector for Stripe