CustomerListUpload
Get the metadata for a customer list upload by its ID.
Table Specific Information
Select
The add-in 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 add-in. AdAccountId, CustomerListId, and Id are required columns to access this table.
- AdAccountId supports the '=' operator.
- CustomerListId supports the '=' operator.
- Id supports the '=,IN' operator.
SELECT * FROM CustomerListUpload WHERE AdAccountId = '549755885175' AND CustomerListId = '2542620905475' AND Id = '2680059592705'
SELECT * FROM CustomerListUpload WHERE AdAccountId = '549755885175' AND CustomerListId = '2542620905475' AND Id IN ('2680059592705','2542620905475')
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Unique identifier of the customer list upload. | |
| AdAccountId | String |
AdAccounts.Id | Unique identifier of an ad account. |
| CustomerListId | String | Unique identifier of the customer list associated with this upload. | |
| Operation | String | Operation type for the upload.
The allowed values are ADD, REMOVE. | |
| State | String | Workload processing state of the upload.
The allowed values are NOT_STARTED, RUNNING, PAUSED, SUCCEEDED, FAILED. | |
| CreationTime | Datetime | Customer list upload creation time. Epoch (seconds). | |
| UpdatedTime | Datetime | Customer list upload last updated time. Epoch (seconds). | |
| RecordCountsProcessed | Integer | Number of records processed. | |
| RecordCountsValid | Integer | Number of valid records processed. | |
| RecordCountsInvalid | Integer | Number of invalid records processed. | |
| ErrorCounts | String | Error counts by error code. Each entry contains error_code, message, and count. |