ValueLists

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

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: =.
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'

Insert

To create value lists:

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

Update

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

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

Delete

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

DELETE FROM ValueLists WHERE Id='123124'

Columns


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.

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.

CData Python Connector for Stripe