ValueListItems
Creates, deletes, and queries the Values list items.
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: =.
- Created supports the following operators: >, >=, <, <=, =.
- Value supports the following operators: =, LIKE.
- ValueList supports the following operator: =.
- AccountId supports the following operator: =.
You can select from the ValueListItems table with the following queries:
SELECT * FROM ValueListItems SELECT * FROM ValueListItems WHERE Id = '123124' SELECT * FROM ValueListItems WHERE Created >= '2023-07-14T05:36:46.000-04:00' SELECT * FROM ValueListItems WHERE Value = 'This is the value.' SELECT * FROM ValueListItems WHERE ValueList = 'rsl_1MGcyqSC4snQ'
Insert
To create value list items:
INSERT INTO ValueListItems (Value, ValueList) values ('This is the list item.', 'rsl_1MGcyqSC4snQ')
Delete
To delete value list items, specify the list item Id:
DELETE FROM ValueListItems WHERE Id='123124'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | True |
The Id of the value list items. | |
Created | Datetime | True |
The 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. | |
Livemode | Boolean | True |
true if the object exists in live mode and false if in test mode. | |
Value | String | False |
The value of the item. | |
ValueList | String | False |
The Id of the value list. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
AccountId | String |
The Id of the connected account to get value list for. |