FeedFtp

Create, Read or Update FTP setting information.

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

AccountId supports the '='.
FeedId supports the '=,IN'.

For example, the following queries are processed server side:

SELECT * FROM FeedFtp WHERE AccountId = '123436'

Insert

Insert can be executed by specifying the AccountId, FeedId, FeedUrl, ScheduleScheduleDailyTime, ScheduleScheduleHourlyInterval, ScheduleScheduleType, ScheduleScheduleWeeklyScheduleWeek, ScheduleScheduleWeeklyTime, UserName and UserPassword columns. The columns that are not read-only can be inserted optionally.

INSERT INTO FeedFtp (AccountId, UserName, UserPassword, FeedId, FeedUrl, ItemListUploadType, ScheduleDailyTime, ScheduleHourlyInterval, ScheduleType, ScheduleWeeklyScheduleWeek, ScheduleWeeklyTime) VALUES ('123436', '1002504155', 'Admin', 'Admin', 1132453, 'www.feedftp.com', 'UPDATE_ALL', 500, 10, 'DAILY', 'SUN', '10')

Update

Update can be executed by specifying the AccountId and FeedId in the WHERE Clause. The columns that are not read-only can be Updated. For example:

UPDATE FeedFtp SET UserName = 'Admin@123', UserPassword = 'password' WHERE AccountId = '1002504155' AND FeedId = '1132453'

Columns


Name	Type	ReadOnly	References	Description
FeedId [KEY]	Int64	True	DisplayAdsFeeds.FeedId	Feed ID.
AccountId	Int64	True	DisplayAdsAccounts.AccountId	Account ID.
ActiveStatus	String	False		Displays status of FTP schedule.The default value in ADD operation will be ACTIVE. 使用できる値は次のとおりです。INACTIVE, ACTIVE, UNKNOWN デフォルト値はACTIVEです。
FeedUrl	String	False		URL of item list file.
ItemListUploadType	String	False		Displays the upload type of Item List file. 使用できる値は次のとおりです。UPDATE_PART, UPDATE_ALL, UNKNOWN
ScheduleDailyTime	Int64	False		Execution time.
ScheduleHourlyInterval	Int64	False		Interval of the execution time.
ScheduleType	String	False		Displays the schedule type of Periodic Upload. 使用できる値は次のとおりです。HOURLY, DAILY, WEEKLY, UNKNOWN
ScheduleWeeklyScheduleWeek	String	False		Serves the days of the week. 使用できる値は次のとおりです。SUN, MON, TUE, WED, THU, FRI, SAT, UNKNOWN
ScheduleWeeklyTime	Int64	False		Execution time.
UserName	String	False		User name.
UserPassword	String	False		Password.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
ReferenceNumber	String	This column will be used in Bulk operations to get specific values from the Temp tables.