CData Python Connector for Stripe

Build 23.0.8839

ValueListItems

Creates, deletes, and queries the Values list items.

Table Specific Information

Select

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: =.
  • Created supports the following operator: >,>=,<,<=,=.
  • Value supports the following operator: =,LIKE.
  • ValueList supports the following operator: =.
  • AccountId 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 the PaymentMethods:

SELECT * FROM ValueListItems
SELECT * FROM ValueListItems WHERE Id = '123124'
SELECT * FROM ValueListItems WHERE Created >= '2023-07-14T05:36:46.000-04:00'
SELECT * FROM ValueListItems WHERE Value = 'This is the value.'
SELECT * FROM ValueListItems WHERE ValueList = 'rsl_1MGcyqSC4snQ'

Insert

To create value list items:

INSERT INTO ValueListItems (Value, ValueList) values ('This is the list item.', 'rsl_1MGcyqSC4snQ')

Delete

To delete a value list ites, specify the list item Id and run a delete statement.

DELETE FROM ValueListItems WHERE Id='123124'

Columns

Name Type ReadOnly References Description
Id [KEY] String True

The Id of the value list items.

Created Datetime True

The time at which the object was created. Measured in seconds since the Unix epoch.

CreatedBy String True

The name or email address of the user who created this value list.

Livemode Boolean True

true if the object exists in live mode and false if in test mode.

Value String False

The value of the item.

ValueList String False

The Id of the value list.

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 value list for.

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