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