SAP B1 Service Layer 1 - Gestion icon

SAP B1 Service Layer 1 - Gestion

Interact with SAP B1 Service Layer 1 - Gestion

Overview

This node integrates with the SAP Business One Service Layer to set currency exchange rates. It is designed to send a POST request to the SAP B1 API endpoint responsible for updating or defining currency rates within the system.

Common scenarios where this node is beneficial include:

  • Automating the update of currency exchange rates in SAP B1 based on external financial data feeds.
  • Synchronizing currency rates across multiple systems by pushing updated rates into SAP B1.
  • Managing multi-currency financial transactions by ensuring up-to-date exchange rates are available in SAP B1.

For example, a finance team could use this node in an n8n workflow to daily update the USD to EUR exchange rate in SAP B1 by fetching rates from a financial API and then setting them via this node.

Properties

Name Meaning
Body Input Mode How to provide the request body data. Options: JSON (enter full JSON body), Fields (enter individual fields).
JSON Body Complete JSON object to send as the request body (shown if Body Input Mode is JSON).
Currency Currency code (e.g., USD) to set the rate for (shown if Body Input Mode is Fields).
Rate Exchange rate value to assign to the currency (shown if Body Input Mode is Fields).
Rate Date Date for the currency rate in format YYYYMMDD (e.g., 20250704) (shown if Body Input Mode is Fields).
Additional Fields Optional additional key-value pairs to include in the request body (shown if Body Input Mode is Fields).

Output

The node outputs an array of JSON objects corresponding to each input item processed. Each output item contains:

  • json: The JSON response returned by the SAP B1 Service Layer after attempting to set the currency rate. This typically includes confirmation or details about the operation's success.
  • In case of errors, the json field contains an error property with the error message.

No binary data is produced by this node.

Dependencies

  • Requires valid credentials for SAP Business One Service Layer, including base URL, username, password, and company database name.
  • The node performs a login request to obtain session cookies before making the currency rate update call.
  • The SAP B1 Service Layer API must be accessible from the environment where n8n runs.
  • No additional external dependencies beyond the SAP B1 API and its authentication.

Troubleshooting

  • Authentication failures: If login fails, verify that the provided SAP B1 credentials (username, password, company DB) are correct and that the Service Layer URL is reachable.
  • Invalid request body: When using the Fields mode, ensure all required fields (Currency, Rate, RateDate) are correctly formatted. The date must be in YYYYMMDD format.
  • API errors: Errors returned from the SAP B1 API will appear in the output under the error property. Check the message for clues, such as invalid currency codes or permission issues.
  • Network issues: Ensure that the network allows outbound requests to the SAP B1 Service Layer endpoint and that SSL certificates are valid or properly handled (the node disables strict SSL verification).

Links and References

Discussion