Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the add-in beyond simple SELECT/INSERT/UPDATE/DELETE operations with AdobeCommerce.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from AdobeCommerce, along with an indication of whether the procedure succeeded or failed.
CData Excel Add-In for Adobe Commerce Stored Procedures
| Name | Description |
| CancelCreditMemo | Cancels a specified credit memo. |
| CanDeleteCustomer | Determines whether the customer can be deleted or not. |
| CanDeleteCustomerGroup | Determines whether the customer group can be deleted or not. |
| CheckBulkDeleteJobStatus | Retrieve the status of a request to delete rows. |
| CreateSchema | Creates a schema file for the specified table or view. |
| FireAction | Execute a Magento action, by specifing the action name and order/invoice id. |