SAP B1 Service Layer 7 - Inventario icon

SAP B1 Service Layer 7 - Inventario

Interact with SAP B1 Service Layer 7 - Inventario

Actions34

Overview

This node integrates with the SAP Business One Service Layer (version 7) to manage inventory-related resources, specifically including "Item" resources. The "Get by Key" operation for the "Item" resource allows users to retrieve detailed information about a specific item in the SAP B1 system by providing its primary key.

Typical use cases include:

  • Fetching detailed data of a particular inventory item for reporting or processing.
  • Integrating SAP B1 item data into other systems or workflows.
  • Validating item existence or attributes before performing further operations like updates or deletions.

For example, a user might want to get all details of an item identified by a unique key (DocEntry) to display it in a custom dashboard or to verify stock levels before creating a sales order.

Properties

Name Meaning
DocEntry / Key Primary key of the item resource to fetch. This is a string representing the unique identifier of the item in SAP B1.

Output

The output is a JSON object containing the full response from the SAP B1 Service Layer for the requested item. It includes all available fields and properties of the item as stored in SAP B1.

The structure corresponds directly to the SAP B1 API's item entity representation, which typically includes fields such as item code, description, quantity on hand, price, warehouse info, and other relevant inventory details.

No binary data output is produced by this operation.

Example output snippet (simplified):

{
  "ItemCode": "A1000",
  "ItemName": "Sample Item",
  "OnHand": 150,
  "Price": 25.5,
  ...
}

Dependencies

  • Requires connection to SAP Business One Service Layer version 7.
  • Needs credentials including base URL, username, password, and company database name.
  • The node authenticates via a login POST request to obtain session cookies used in subsequent requests.
  • No additional external dependencies beyond the SAP B1 Service Layer API.

Troubleshooting

  • Authentication errors: If login fails, check that the provided credentials (username, password, company DB) are correct and that the SAP B1 Service Layer endpoint is reachable.
  • Invalid DocEntry: Providing a non-existent or incorrect DocEntry will likely result in an error or empty response. Verify the key value before running the node.
  • Network issues: Ensure the SAP B1 server is accessible from the n8n environment and that SSL certificates are valid or properly handled (the node disables strict SSL verification).
  • Permission issues: The user account must have sufficient permissions to read item data in SAP B1.
  • Error messages: Errors returned from the SAP B1 API are passed through in the output JSON under an error field. Review these messages for clues on misconfiguration or invalid parameters.

Links and References

This summary focuses on the "Item" resource with the "Get by Key" operation as requested.

Discussion