ValueLists
Creates, updates, deletes, and queries values in a list.
Table Specific Information
Select
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: =.
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 Id:
UPDATE ValueLists SET Alias ='customer_email_list' WHERE Id='123124'
Delete
To delete a value list, specify the list Id:
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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
AccountId | String |
The Id of the connected account to get value list for. |