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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| MarketplaceID | String |
MarketplaceID of your Ebay account. |
| SchemaVersion | String |
The schema version number associated with the task. |