ODBC Driver for eBay

Build 24.0.8963

Tasks

Retrieves all the tasks for the marketplace you specify using the MarketplaceId query parameter.

Select

FeedType is required filter in the Select query. You can follow the query below to obtain the required values through SQL:

SELECT * FROM [Tasks] WHERE FeedType = 'LMS_ADD_ITEM'

Some of the fields are named with the suffix Aggr. These fields display the content of the JSON tag with the same name that is returned from the API endpoint.

Insert

FeedType, MarketplaceID and SchemaVersion are required in the Insert query. You can follow the query below to obtain the required values through SQL:

INSERT INTO [Tasks] (FeedType, MarketplaceID, SchemaVersion) VALUES ('LMS_ADD_ITEM', 'EBAY_US', '1149')

Columns

Name Type ReadOnly Description
TaskId [KEY] String True

The ID of the task that was submitted in the request.

Status String True

The enumeration value that indicates the state of the task that was submitted in the request.

FeedType String False

The feed type associated with the task.

CreationDate Datetime True

The date the task was created.

UploadSummaryAggr String True

This container provides summary information on an upload feed (not applicable for download feed types).

Pseudo-Columns

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

Name Type Description
MarketplaceID String

MarketplaceID of your Ebay account.

SchemaVersion String

The schema version number associated with the task.

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