Power BI Connector for Yahoo! Ads

Build 24.0.9062

GetUploadUserListStatus

Get the upload status of the user list.

Table Specific Information

SELECT

The 本製品 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 本製品.

  • 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062