ValueLists
Represents radar value lists used in rules, including the list name, alias, item type, and creator details.
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.
| 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. |