Actions34
- Inventory Counting Actions
- Inventory Gen Entrie Actions
- Inventory Gen Exit Actions
- Inventory Posting Actions
- Item Actions
- Stock Transfer Actions
Overview
This node integrates with the SAP B1 Service Layer 7 API to manage inventory-related resources, specifically here focusing on the Item resource's Update operation. It allows users to update an existing item in the SAP Business One system by specifying the item's primary key and providing a JSON body with the fields to update.
Common scenarios where this node is beneficial include:
- Automating updates to product details such as descriptions, prices, or stock levels.
- Synchronizing item data from external systems into SAP B1.
- Bulk updating multiple items programmatically within workflows.
For example, a user might update the price and description of an item identified by its unique key (DocEntry
) by sending a JSON payload with those fields updated.
Properties
Name | Meaning |
---|---|
DocEntry / Key | The primary key (unique identifier) of the item to update in SAP B1. |
JSON Body | A JSON object containing the fields and values to update for the specified item. |
Output
The node outputs an array of JSON objects corresponding to each input item processed. Each output item contains:
json
: The response from the SAP B1 Service Layer API after attempting the update. This typically includes the updated item data or confirmation of the update.- In case of errors, the
json
field contains anerror
property with the error message describing what went wrong.
No binary data output is produced by this node.
Dependencies
- Requires connection to a SAP B1 Service Layer 7 instance.
- Needs credentials including base URL, username, password, and company database name to authenticate via the SAP B1 login endpoint.
- The node manages session cookies internally to maintain authentication state during requests.
Troubleshooting
- Authentication failures: If login fails, verify that the provided credentials (username, password, company DB) are correct and that the SAP B1 Service Layer is accessible.
- Invalid DocEntry: Errors may occur if the specified
DocEntry
does not exist or is incorrect. Ensure the key matches an existing item. - Malformed JSON Body: The update payload must be valid JSON and conform to SAP B1 API schema for the Item resource. Invalid fields or types will cause errors.
- Network issues: Connection problems or SSL certificate issues can cause request failures. The node disables strict SSL verification (
rejectUnauthorized: false
), but network connectivity must be stable. - API errors: The SAP B1 API may return errors for business logic violations or permission issues. Review the error messages returned in the output for guidance.
Links and References
- SAP Business One Service Layer Documentation
- SAP B1 Service Layer API Reference
- n8n HTTP Request Node Documentation (for understanding underlying request mechanics)