PlantScanner - SAP Service Layer icon

PlantScanner - SAP Service Layer

Interact with SAP Service Layer API
Join our community

Actions26

Overview

This node interacts with the SAP Service Layer API to perform various operations on different resources within an SAP environment. Specifically, for the Warehouse resource and the Get operation, it retrieves a single warehouse record by its unique ID. This is useful when you need detailed information about a specific warehouse, such as its code, name, location, or other metadata stored in SAP.

Common scenarios include:

  • Fetching warehouse details to validate or display in an external system.
  • Integrating SAP warehouse data into reporting or inventory management workflows.
  • Automating processes that require confirmation of warehouse existence or attributes before proceeding.

Example: You want to retrieve the warehouse with ID "WH123" to check its address and capacity before scheduling a shipment.

Properties

Name Meaning
ID The unique identifier of the warehouse record to retrieve. This is required.
Select Optional comma-separated list of fields to include in the response. If empty, all fields are returned. Example: WarehouseCode, WarehouseName
Expand Optional comma-separated list of related entities to expand in the response. Example: LocationDetails, Manager

Output

The output is a JSON object representing the requested warehouse record from SAP. It contains the fields of the warehouse entity, filtered by the optional Select parameter if provided. If Expand is used, related entities' data will be included nested inside the main warehouse object.

No binary data is output by this operation.

Example output structure (simplified):

{
  "WarehouseCode": "WH123",
  "WarehouseName": "Main Warehouse",
  "Location": "Building A",
  "Capacity": 10000,
  "Manager": {
    "Name": "John Doe",
    "Contact": "john.doe@example.com"
  }
}

Dependencies

  • Requires connection credentials to the SAP Service Layer API, including:
    • Base URL of the SAP Service Layer endpoint.
    • Company database name.
    • Username and password for authentication.
    • Optional language setting.
  • Uses HTTPS requests with session cookie authentication.
  • No additional external dependencies beyond standard HTTP client libraries bundled with n8n.

Troubleshooting

  • Failed to get session cookie: Indicates login to SAP Service Layer failed. Check credentials and network connectivity.
  • Operation not supported: Using an unsupported operation or resource combination. Verify the selected Resource and Operation.
  • Invalid ID: If the specified warehouse ID does not exist, the API may return an error or empty result.
  • Field selection errors: Incorrect field names in Select or Expand parameters can cause API errors. Confirm field names against SAP metadata.
  • Network or SSL issues: The node disables strict SSL verification (rejectUnauthorized: false) but network/firewall issues can still block requests.

To resolve errors:

  • Double-check all input parameters.
  • Ensure SAP Service Layer credentials are correct and have sufficient permissions.
  • Review SAP API documentation for valid field names and relationships.
  • Enable "Continue On Fail" in the node settings to handle partial failures gracefully.

Links and References

Discussion