Actions7
Overview
This node enables interaction with SAP Business One through a Unified MCP Server, supporting two connection types: direct database access and service layer API calls. Specifically, the Data - Update operation allows updating records in a database table or via the service layer.
Typical use cases include:
- Updating specific rows in a database table by specifying conditions.
- Modifying existing business objects (e.g., Business Partners, Items) in SAP Business One using the service layer.
- Automating data synchronization or correction workflows where updates to SAP Business One data are required.
For example, you might update customer information in a "Customers" table directly via the database connection or update an order record through the service layer API.
Properties
| Name | Meaning |
|---|---|
| Connection Type | Type of connection to use: • Direct Database (db) • Service Layer (sl) |
| Table | Name of the database table to update (required for Direct Database connection). |
| Data | JSON object containing the fields and values to update in the record. |
| Condition | SQL WHERE clause condition to specify which records to update (required for Direct Database). |
| Condition Parameters | JSON object providing parameters for the WHERE condition placeholders (optional). |
Output
The node outputs an array of items, each containing a json property with the response from the MCP server:
- For Direct Database updates, the output JSON typically contains the result of the update operation (success status, affected rows, etc.).
- For Service Layer updates, the output JSON contains the updated record or confirmation of the update.
- No binary data is output by this node.
Dependencies
- Requires an active connection to the Unified MCP Server with valid credentials including an API URL and authentication token/session.
- The node depends on the MCP API endpoints for database or service layer operations.
- Proper permissions on the SAP Business One system to perform update operations.
- n8n credential configuration must include the MCP API credentials with session management handled internally.
Troubleshooting
Common issues:
- Incorrect or missing table name when using direct database connection.
- Malformed JSON in the Data or Condition Parameters fields causing parsing errors.
- Invalid or expired session ID when using the service layer connection.
- Improperly formatted WHERE condition leading to no records being updated.
- Insufficient permissions on the SAP Business One side to perform updates.
Error messages:
"error": "Invalid session"— Indicates the session has expired; re-login may be required."error": "Syntax error in SQL statement"— Check the WHERE condition syntax and parameter usage."error": "Table not found"— Verify the table name is correct and accessible.- Network or connectivity errors — Ensure the MCP server URL is reachable and credentials are valid.
To resolve errors, verify all input parameters, ensure proper JSON formatting, and confirm that the MCP server credentials are up to date.
Links and References
- SAP Business One Service Layer Documentation
- Unified MCP Server API Reference (replace with actual URL if available)
- n8n Documentation on Custom Nodes