TestClocks

Returns the available TestClocks in Stripe and supports creating and deleting them.

Table-Specific Information

SELECT

The add-in 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 add-in.


Column	Supported Operators
Id	=

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 test clock, the FrozenTime column is required:

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

DELETE

To delete a test clock, 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		The date and time at which the object was created, measured in seconds since the Unix epoch.
DeletesAfter	Datetime	True		The date and time at which this clock is scheduled to auto delete.
FrozenTime	Datetime	False		The initial frozen time for this test clock.
Livemode	Boolean	True		Indicates whether the object exists in live mode. The value is true in live mode and false in test mode.
StatusDetailsAdvancingTargetFrozenTime	Datetime	True		The frozen_time that the Test Clock is advancing towards.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.


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