ValueLists

Represents radar value lists used in rules, including the list name, alias, item type, and creator details.

Table-Specific Information

SELECT

The provider 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 provider.


Column	Supported Operators
Id	=
Alias	=
Created	>, >=, <, <=, =
AccountId	=

You can select from the ValueLists table with the following queries:

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 a value list:

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

UPDATE

To modify a value list, specify the list's Id:

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

DELETE

To delete a value list, specify the list's Id:

DELETE FROM ValueLists WHERE Id = '123124'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The unique identifier for the value list.
Alias	String	False		The name of the value list for use in rules.
Created	Datetime	True		The time at which the value list 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. The allowed values are account, card_fingerprint, card_bin, email, ip_address, country, string, case_sensitive_string, customer_id.
ListItemsUrl	String	True		The URL where this list can be accessed.
Livemode	Boolean	True		Indicates whether the object exists in live mode. Has the value true if the object exists in live mode, or the value false if the object exists 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 the value list.

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

ADO.NET Provider for Stripe