Uploads a file to the EBay account.

Stored Procedure Specific Information

This procedure associates the specified file with the specified task ID and uploads the input file. After the file has been uploaded, the processing of the file begins.

The inputs required to upload a file are the following: TaskID and FilePath.

Upload a file

You can follow the procedure below to submit a successful upload file procedure:

1. Use the Tasks table to create a new Task. You can use the following query:
   

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

2. You can get newly generated TaskID either from the generated keys, or by using the Tasks table again to select.
   

       Statement stat = conn.createStatement();
       stat.executeUpdate("INSERT INTO [Tasks] (FeedType, MarketplaceID, SchemaVersion) VALUES ('LMS_ADD_ITEM', 'EBAY_US', '1149')", Statement.RETURN_GENERATED_KEYS);
       ResultSet rs = stat.getGeneratedKeys();
       while (rs.next()) {
         for (int i = 1; i <= rs.getMetaData().getColumnCount(); i++) {
           System.out.println(rs.getMetaData().getColumnName(i) + "=" + rs.getString(i));
         }
       }

   or
   

   SELECT * FROM [Tasks] WHERE FeedType = 'LMS_ADD_ITEM' AND CreationDate > '2021-11-16 09:19:00'

3. Use this task id as input together with the FilePath of the file to be uploade, in the UploadFile stored procedure.
   

       CallableStatement callableStatement = conn.prepareCall("UploadFile");
       callableStatement.setString("TaskID", "task-5-1XXXXX");
       callableStatement.setString("FilePath", "C:\\Users\\User\\Documents\\upload.csv");
   
       boolean ret = callableStatement.execute();
       if (!ret) {
         int count = callableStatement.getUpdateCount();
         if (count != -1) {
           System.out.println("Affected rows: " + count);
         }
       } else {
         ResultSet rs = callableStatement.getResultSet();
         while (rs.next()) {
           for (int i = 1; i <= rs.getMetaData().getColumnCount(); i++) {
             System.out.println(rs.getMetaData().getColumnName(i) + "=" + rs.getString(i));
           }
         }
       }

4. Then your file should be processing. To track the status you can execute a SELECT query in the Tasks table with the TaskID, and check the Status column.
   

   SELECT Status FROM [Tasks] WHERE TaskID = '{Generated Task ID}'

Input

Result Set Columns