GetUploadUserListStatus
Get the upload status of the user list.
Table Specific Information
SELECT
The connector will use the Yahoo! Ads API to process WHERE clause conditions built with the following column and operator. The AccountId, AudienceListId is required to make a request and the rest of the filter is executed client-side within the connector.
- UploadJobId supports the '=,IN'.
- JobStatus supports the '=,IN'.
- AudienceListId supports the '='.
- AccountId supports the '='.
For example:
SELECT * FROM GetUploadUserListStatus WHERE AccountId = '25647' AND AudienceListId = '25647'
Columns
| Name | Type | References | Description |
| UploadJobId [KEY] | String | Upload job ID. | |
| JobStatus | String | Status of the upload job .The user list will usually be reflected within a few hours after the status becomes RECEIVED.If the status is INVALID_FILE, there is a problem with the file contents, the file format is incorrect, or the file size exceeds the upper limit (1,073,741,824 bytes).If the status is FAILED, it means that the job did not complete successfully due to a problem other than the file contents.
使用できる値は次のとおりです。RECEIVING, RECEIVED, INVALID_FILE, FAILED, UNKNOWN | |
| ReceivedDate | Datetime | Job completion date and time. | |
| AudienceListId | Int64 |
AudienceLists.AudienceListId | Audience list ID. |
| UploadSubmitDate | Datetime | Upload date and time. | |
| UploadType | String | Kind of upload method.
使用できる値は次のとおりです。IDFA, AAID, MAIL_ADDRESS, UNKNOWN | |
| AccountId | Int64 | Account ID. |