Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the component beyond simple SELECT/INSERT/UPDATE/DELETE operations with eBay.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from eBay, along with an indication of whether the procedure succeeded or failed.
CData SSIS Components for eBay Stored Procedures
| Name | Description |
| AddItem | Create and publish a new Item Listing on an eBay site. |
| CompleteSale | Do various tasks after the creation of a single line item or multiple line item order. For example, complete a sale and leave feedback. |
| CreateInventoryTask | This procedure creates an inventory-related download task for a specified feed type with optional filter criteria. |
| CreateOrderTask | This procedure creates an order download task with filter criteria for the order report. |
| GetOAuthAccessToken | Gets the OAuth access token from eBay. |
| GetOAuthAuthorizationURL | Gets the eBay authorization URL. Access the URL returned in the output in an Internet browser. This requests the access token that can be used as part of the connection string to eBay. |
| GetResultFile | This procedure retrieves the generated file that is associated with the specified task ID. The response of this call is a compressed or uncompressed CSV, XML, or JSON file, with the applicable file extension (for example: csv.gz). |
| RefreshOAuthAccessToken | Refreshes the OAuth access token used for authentication with EBay. |
| SetUserNotes | Add, replace, and delete My eBay notes for items that are being tracked in the My eBay Selling and Buying areas. |
| UploadFile | Uploads a file to the EBay account. |