Catalogs
Returns catalogs owned by the user account associated with the operation.
Table Specific Information
Select
The server 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 server.
- 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.
The allowed values are RETAIL, HOTEL, CREATIVE_ASSETS. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| AdAccountId | String | Unique identifier of an ad account. |