CData Python Connector for Stripe

Build 23.0.8839


Creates, updates, deletes, and queries values in a list.

Table Specific Information


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: =.
  • Alias supports the following operator: =.
  • Created 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 ValueLists
SELECT * FROM ValueLists WHERE Id = '123124'
SELECT * FROM ValueLists WHERE Alias = 'customer_email_list'
SELECT * FROM ValueLists WHERE Created >= '2023-07-14T05:36:46.000-04:00'


To create value lists:

INSERT INTO ValueLists (Alias, ItemType, Name) values ('customer_email_li', 'email', 'Customer Email List')


To modify a value lists, specify the list Id and run an Update statement.

UPDATE ValueLists SET Alias ='customer_email_list' WHERE id='123124'


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

DELETE FROM ValueLists WHERE Id='123124'


Name Type ReadOnly References Description
Id [KEY] String True

The Id of the value list.

Alias String False

The name of the value list for use in rules.

Created Datetime True

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.

ItemType String False

The type of items in the value list. Possible values are card_fingerprint, card_bin, email, ip_address, country, string, case_sensitive_string, or customer_id.

ListItemsUrl String True

The URL where this list can be accessed.

Livemode Boolean True

true if the object is in live mode andfalse if in test mode.

Name String False

The name of the value list.

Metadata String False

The set of key/value pairs that you can attach to a value list object.


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

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