SSIS Components for Stripe

Build 24.0.8963

TestClocks

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

Table Specific Information

Select

Server-Side Query Support

The 本製品 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 本製品.

  • Id supports the following operator: =.

The provider supports the use of all columns as criteria in the WHERE clause of SELECT statements, as long as SupportEnhancedSQL is set to True. If SupportEnhancedSQL property is set to False, you still can retrieve:

SELECT * FROM TestClocks
SELECT * FROM TestClocks WHERE Id = 'clock_1PYNnU2eZvKYlo2CNSmVfWJP'

Insert

FrozenTime column is required to create a new TestClock.

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

Delete

To delete a TestClock specify the Id of the TestClock.

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963