SAP B1 Service Layer 3 - CRM

Overview

This node interacts with the SAP Business One Service Layer 3 CRM API to manage CRM-related entities such as Activities, Business Partners, Orders, Quotations, and Sales Opportunities. Specifically, for the Activities - Delete operation, it deletes an existing activity record identified by a unique key (DocEntry) from the SAP B1 system.

Common scenarios where this node is beneficial include:

• Automating cleanup of outdated or incorrect activity records in SAP B1.
• Integrating external systems that trigger deletion of activities based on business logic.
• Maintaining data consistency by programmatically removing activities no longer relevant.

Example: Automatically delete an activity in SAP B1 when a related task is completed or canceled in another system.

Properties

Output

The node outputs a JSON object representing the response from the SAP B1 Service Layer after attempting to delete the specified activity. Typically, this will be either:

• A confirmation of successful deletion (often an empty object or status message).
• An error object containing details if the deletion failed.

The output is structured as:

{
  "json": { /* response from SAP B1 Service Layer */ },
  "pairedItem": { "item": <index_of_input_item> }
}

No binary data is produced by this operation.

Dependencies

• Requires connection credentials to the SAP Business One Service Layer API, including:
  • Base URL of the SAP B1 Service Layer.
  • Username and password for authentication.
  • Company database name.
• The node performs a login request to obtain session cookies used for subsequent API calls.
• The SAP B1 Service Layer must be accessible from the n8n environment.

Troubleshooting

• Authentication errors: If login fails, verify the provided username, password, and company database are correct and that the SAP B1 Service Layer endpoint is reachable.
• Invalid DocEntry: Deletion will fail if the specified DocEntry does not exist or is invalid. Confirm the key corresponds to an existing activity.
• Permission issues: Ensure the user account has sufficient permissions to delete activities in SAP B1.
• Network/SSL errors: The node disables SSL verification (rejectUnauthorized: false), but network connectivity issues or firewall restrictions may still block requests.
• Error messages: The node returns error messages from the SAP B1 API in the output JSON under error. Use these messages to diagnose issues such as missing parameters or invalid operations.

Links and References

• SAP Business One Service Layer API Documentation
• SAP B1 Service Layer Authentication
• n8n HTTP Request Node Documentation (for understanding underlying request handling)