Feeds
Returns feeds owned by the user account associated with the operation.
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 本製品.
- Id supports the '=' operator.
- AdAccountId supports the '=' operator.
- CatalogId supports the '=' operator.
SELECT * FROM Feeds WHERE Id = '2542622901002' SELECT * FROM Feeds WHERE AdAccountId = '549768233165' SELECT * FROM Feeds WHERE CatalogId = '4842503688348'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | ID of the feed. | |
| Name | String | A human-friendly name associated to a given feed. | |
| CreatedAt | Datetime | CreatedAt time. | |
| UpdatedAt | Datetime | UpdatedAt time. | |
| CatalogType | String | Type of the catalog entity.
使用できる値は次のとおりです。RETAIL, HOTEL, CREATIVE_ASSETS | |
| Format | String | The file format of a feed.
使用できる値は次のとおりです。TSV, CSV, XML | |
| Location | String | The URL where a feed is available for download. This URL is what Pinterest will use to download a feed for processing. | |
| Status | String | Status for catalogs entities. Present in catalogs_feed values. When a feed is deleted,the response will inform DELETED as status.
使用できる値は次のとおりです。ACTIVE, INACTIVE | |
| DefaultCurrency | String | Currency Codes from ISO 4217. | |
| DefaultLocale | String | The locale used within a feed for product descriptions. | |
| DefaultCountry | String | Country ID from ISO 3166-1 alpha-2. | |
| DefaultAvailability | String | Default availability for products in a feed.
使用できる値は次のとおりです。IN_STOCK, OUT_OF_STOCK, PREORDER | |
| CredentialsUsername | String | The required username for downloading a feed. This field is OPTIONAL. Use this if your feed file requires username and password. | |
| CredentialsPassword | String | The required password for downloading a feed. This field is OPTIONAL. Use this if your feed file requires username and password. | |
| PreferredProcessingScheduleTime | String | A time in format HH:MM with leading 0 (zero). This field is OPTIONAL. Use this to configure the preferred time for processing a feed. | |
| PreferredProcessingScheduleTimezone | String | The timezone considered for the processing schedule time. This field is OPTIONAL.Use this to configure the preferred time for processing a feed. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| AdAccountId | String | Unique identifier of an ad account. | |
| CatalogId | String | Filter entities for a given catalog_id. If not given, all catalogs are considered. |