SAP B1 Service Layer 3 - CRM icon

SAP B1 Service Layer 3 - CRM

Interact with SAP B1 Service Layer 3 - CRM

Overview

This node interacts with the SAP Business One Service Layer 3 CRM API to perform various operations on CRM resources, including Quotations. Specifically, the "Update" operation for the Quotation resource allows users to modify an existing quotation in SAP B1 by sending a PATCH request with updated data.

Common scenarios where this node is beneficial include:

  • Automating updates to quotations based on external triggers or workflows.
  • Synchronizing quotation data between SAP B1 and other systems.
  • Programmatically adjusting quotation details such as pricing, quantities, or statuses without manual intervention.

For example, a sales automation workflow could update a quotation's terms or add notes when certain conditions are met, streamlining the sales process.

Properties

Name Meaning
DocEntry / Key The unique identifier (DocEntry) of the quotation to update. Required to specify which quotation to modify.
JSON Body A JSON object containing the fields and values to update in the quotation. This is the body sent in the PATCH request.

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 operation. This typically includes the updated quotation data or confirmation of success.
  • In case of errors, the json field contains an error property with the error message.

No binary data is output by this node.

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 POST request to obtain session cookies used for subsequent API calls.
  • The environment must allow HTTPS requests to the SAP B1 Service Layer endpoint.
  • No additional external libraries beyond n8n's built-in HTTP request helper are required.

Troubleshooting

  • Authentication failures: If login fails, verify that the base URL, username, password, and company database are correct and that the SAP B1 Service Layer is accessible.
  • Invalid DocEntry: Providing a non-existent or incorrect DocEntry will result in an error from the API indicating the resource was not found.
  • Malformed JSON Body: Ensure the JSON body is valid and conforms to the expected schema for a quotation update in SAP B1; otherwise, the API may reject the request.
  • Network issues: Connection timeouts or SSL errors can occur if the SAP B1 server is unreachable or has invalid certificates. The node disables strict SSL verification (rejectUnauthorized: false) but network connectivity must be stable.
  • API errors: Any error returned by the SAP B1 API will be captured and output in the error field. Review the error message for clues on how to fix the request.

Links and References

Discussion