PlantScanner - SAP Service LayerInstall

Overview

This node integrates with the SAP Service Layer API, enabling users to perform various operations on SAP resources such as items, production orders, warehouses, and SQL queries. Specifically, for the SQL Query resource with the Get All operation, the node fetches multiple records from the SAP system by executing a query that retrieves all matching SQL query records, optionally filtered or limited by parameters.

Common scenarios where this node is beneficial include:

• Retrieving large sets of data from SAP using custom SQL queries.
• Extracting specific fields from SQL query results for reporting or further processing.
• Automating data synchronization between SAP and other systems by fetching updated records.

Practical example:

• A user wants to get all SQL query records related to inventory updates, selecting only certain fields like QueryName and Description. They can specify these fields in the "Select" property to optimize the response size.

Properties

Output

The output is an array of JSON objects representing the SQL query records retrieved from the SAP Service Layer. Each object contains the fields requested via the "Select" property or all fields if none specified.

Example output structure (simplified):

[
  {
    "QueryName": "PlantScannerStockUpdateOnly",
    "Description": "Stock update query",
    "OtherField1": "...",
    "OtherField2": "..."
  },
  {
    "QueryName": "AnotherQuery",
    "Description": "Another description",
    "OtherField1": "...",
    "OtherField2": "..."
  }
]

No binary data output is produced by this operation.

Dependencies

• Requires valid credentials for the SAP Service Layer API, including URL, company database name, username, password, and optionally language.
• Uses HTTPS requests with disabled SSL certificate verification (rejectUnauthorized: false), which may require appropriate network security considerations.
• The node depends on the SAP Service Layer being accessible and properly configured to accept API calls.

Troubleshooting

• Failed to get session cookie: Indicates login to SAP Service Layer failed. Verify credentials and network connectivity.
• Operation not supported: Occurs if an unsupported operation or resource is selected. Ensure "SQL Query" resource and "Get All" operation are chosen.
• Empty or incomplete data returned: Check the "Select" property syntax and ensure the requested fields exist in the SAP SQL query schema.
• Network or SSL errors: Since SSL verification is disabled, some environments might block connections; verify network policies and consider enabling proper SSL certificates.
• API rate limits or timeouts: Large data requests might be throttled or timeout; use filters or pagination if supported.

Links and References

• SAP Service Layer API Documentation (official SAP docs)
• OData Query Options (for understanding $select, $filter, $expand, etc.)