PlantScanner - SAP Service Layer icon

PlantScanner - SAP Service Layer

Interact with SAP Service Layer API
Join our community

Actions26

Overview

This node integrates with the SAP Service Layer API to perform various operations on SAP resources. Specifically, for the Product Tree resource with the Get All operation, it retrieves multiple production tree records from SAP, supporting filtering, pagination (skip), field selection, and expansion of related entities.

This node is beneficial in scenarios where you need to automate data retrieval from SAP's production trees, such as synchronizing product structure data into other systems, reporting, or triggering workflows based on product tree information.

Example use cases:

  • Fetch all product trees created or modified after a certain date.
  • Retrieve product trees including detailed related entities like components or attachments.
  • Paginate through large sets of product trees by skipping a number of records.

Properties

Name Meaning
Filters OData filter string to limit which product trees are returned. Example: WarehouseCode eq 'WH001' or CreationDate ge '2024-03-20'
Skip Number of records to skip for pagination purposes.
Select Comma-separated list of fields to include in the response. Leave empty to get all fields. Example: ItemCode, ItemName, PurchaseItem, SalesItem
Expand Comma-separated list of related entities to expand/include in the response. Example: DocumentLines, Attachments2

Output

The output is an array of JSON objects representing the product tree records retrieved from SAP. Each object contains the fields requested via the Select property or all fields if none specified. If Expand is used, related entities will be included as nested objects or arrays within each product tree record.

No binary data output is produced by this operation.

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.

  • The node uses HTTPS requests with certificate verification disabled (rejectUnauthorized: false), which may require appropriate network security considerations.

Troubleshooting

  • Failed to get session cookie: Indicates login to SAP Service Layer failed. Check credentials and network connectivity.
  • Operation not supported: Occurs if an unsupported operation or resource is selected. Verify correct Resource and Operation settings.
  • OData filter syntax errors: Invalid filter strings can cause request failures. Ensure filters follow OData syntax rules.
  • Empty or incomplete results: May happen if filters exclude all records or if pagination skips beyond available data.
  • SSL/TLS issues: Since HTTPS agent disables certificate validation, some environments may block connections. Adjust network/security settings accordingly.

Links and References

Discussion