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, for the Inventory Counting resource and the Get by Key operation, it retrieves a single inventory counting record identified by its primary key (DocEntry). This is useful when you need to fetch detailed information about a specific inventory counting document in SAP B1.

Common scenarios include:

  • Retrieving the status or details of a particular inventory counting document before processing or updating it.
  • Validating inventory counting data during automated workflows.
  • Integrating SAP B1 inventory counting data into other systems or reports.

Example: You want to get the inventory counting document with DocEntry = "1234" to check its current status or line items.

Properties

Name Meaning
DocEntry / Key Primary key of the inventory counting document to retrieve. Example: "1234"

Output

The output is a JSON object representing the inventory counting document retrieved from SAP B1. It contains all fields and nested data as returned by the SAP B1 Service Layer API for that document.

The structure typically includes:

  • Document metadata (e.g., DocEntry, DocDate, Status)
  • Line items or counted inventory details
  • Any custom fields defined in SAP B1 for inventory counting

If an error occurs (e.g., invalid key or connectivity issues), the output JSON will contain an error field with the error message.

No binary data is output by this operation.

Dependencies

  • Requires connection to an SAP Business One Service Layer endpoint (version 7).
  • Requires 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.
  • The node uses HTTP methods GET, POST, PATCH, DELETE depending on operation; for "Get by Key" it uses GET.

Troubleshooting

  • Authentication errors: If login fails, verify the SAP B1 Service Layer URL, username, password, and company DB are correct.
  • Invalid DocEntry: If the specified key does not exist, the API will return an error which appears in the output's error field.
  • Network issues: Ensure the SAP B1 Service Layer endpoint is reachable from n8n and that SSL certificates are valid or properly configured (the node disables strict SSL verification).
  • Permission issues: The user must have sufficient permissions in SAP B1 to read inventory counting documents.

Links and References

Discussion