ADO.NET Provider for Yahoo! Ads

Build 24.0.9062

DisplayAdsAuditLogs

Create or Read the download result information of operation history data file.

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 is required to make a request and the rest of the filter is executed client-side within the 本製品.

  • AccountId supports the '='.
  • JobId supports the '=,IN'.
  • JobStatus supports the '=,IN'.
For example:
SELECT * FROM DisplayAdsAuditLogs WHERE AccountId = '1002504155'


SELECT * FROM DisplayAdsAuditLogs WHERE AccountId = '1002504155' AND JobId = '4508692'

INSERT

Insert can be executed by specifying the AccountId columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.

INSERT INTO DisplayAdsAuditLogs (AccountId) VALUES ('1002504155')

Columns

Name Type ReadOnly References Description
JobId [KEY] Int64 True

The operation history job ID.

AccountId Int64 True

DisplayAdsAccounts.AccountId

Account ID.

JobStartDate Date False

The job start date .

JobEndDate Date False

The job end date .

JobName String False

The operation history job name.

JobUserName String False

The user name who executes the operation history job.

CampaignIds String False

Campaign ID of the download object.

DateRangeStartDate Datetime False

Start date. Entry format : Ymd format Default value : Current date Available range : Current date Enter the date after Start date.e.g.: The oldest date selectable as of April 30 is March 1.

DateRangeEndDate Datetime False

End date. Entry format : Ymd format Default value : Current date Available range : Current date Enter the date after Start date.Maximum length of date range between Start and End is 1 month

JobStatus String False

Serves process status of download job.

使用できる値は次のとおりです。IN_PROGRESS, COMPLETED, SYSTEM_ERROR, UNKNOWN

Lang String False

Serves the language of download data.

使用できる値は次のとおりです。JA, EN, UNKNOWN

Progress Int64 False

Displays progress in integers from 1 to 100.

SourceType String False

Serves update tool type of the download data.

使用できる値は次のとおりです。CAMPAIGN_MANAGEMENT_TOOL, API, YAHOO_JAPAN, ALL, UNKNOWN

Encoding String False

It describes the encoding type (character encoding) for Operation History file. The default value will be SJIS.

使用できる値は次のとおりです。SJIS, UTF8, UNKNOWN

Output String False

It specifies the file format of acruiqred operation history data. The default value will be CSV.

使用できる値は次のとおりです。ZIPPED_CSV, ZIPPED_TSV, CSV, TSV, UNKNOWN

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