CustomerListUpload
Get the metadata for a customer list upload by its ID.
Table Specific Information
Select
The provider 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 provider. 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. |