Catalogs
Fetch catalogs owned by the operation user_account
Table Specific Information
Select
The 本製品 will use the Pinterest API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.
- AdAccountId supports the '=' operator.
SELECT * FROM Catalogs WHERE AdAccountId = '549768233165'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | ID of the catalog entity. | |
| Name | String | A human-friendly name associated to a catalog entity. | |
| CreatedAt | Datetime | CreatedAt time. | |
| UpdatedAt | Datetime | UpdatedAt time. | |
| CatalogType | String | Type of the catalog entity.
使用できる値は次のとおりです。RETAIL, HOTEL, CREATIVE_ASSETS |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| AdAccountId | String | Unique identifier of an ad account. |