ListSegments
A list of available segments.
テーブル固有の情報
ListSegments ではSELECT、INSERT、UPDATE、およびDELETE がサポートされています。
Select
Select * from ListSegments Select * from ListSegments where ListId = '5152'
Insert
INSERT にはName とListId を指定する必要があります。
INSERT INTO ListSegments (Name, ListID) VALUES ('myNewListSegment', 'myListID')
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | True |
An integer to uniquely identify the segment. |
| Name | String | False |
The name of the segment. |
| MemberCount | Integer | True |
The number of active subscribers currently included in the segment. |
| Type | String | True |
The type of segment: saved, static, or fuzzy. |
| CreatedAt | Datetime | True |
The time and date the segment was created. |
| UpdatedAt | Datetime | True |
The time and date the segment was last updated. |
| Options_Match | String | False |
Match type of 'any' or 'all'. |
| Options_Conditions | String | False |
An array of segment conditions. |
| ListId [KEY] | String | False |
The id for the list. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| EmailList | String |
A comma-separated list of emails that you want to include in this ListSegment. |