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, including executing SQL queries. Specifically for the SQL Query - Get operation, it retrieves data by executing a predefined SQL query or fetching records from the SQLQueries endpoint. This is useful when you want to run custom SQL queries against your SAP database and retrieve specific data sets without manually accessing the database.

Practical scenarios include:

  • Extracting customized reports or datasets that are not directly available via standard SAP endpoints.
  • Running parameterized SQL queries to filter or aggregate data dynamically.
  • Integrating SAP data retrieval into automated workflows for reporting or further processing.

Properties

Name Meaning
Select Comma-separated list of fields to select in the response. Leave empty to get all fields. Example: ItemCode, ItemName, PurchaseItem, SalesItem

Output

The node outputs JSON data representing the result of the SQL query execution or the retrieved record(s). The structure depends on the query but generally includes an array of objects under the .json property, each object corresponding to a row/result from the SQL query.

If binary data were involved (not applicable here), it would be summarized accordingly, but this node focuses on JSON responses from SAP Service Layer.

Dependencies

  • Requires connection credentials to the SAP Service Layer API, including URL, company database name, username, password, and optionally language.
  • Uses HTTPS requests with an agent configured to ignore unauthorized SSL certificates (likely for internal SAP servers).
  • Requires n8n credential configuration for the SAP Service Layer API authentication.

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 requested. Verify the selected Resource and Operation.
  • API errors returned from SAP: These will be included in the output as error messages if "Continue On Fail" is enabled. Otherwise, they throw exceptions.
  • Empty or incorrect results: Ensure the SQL query name and parameters are correct and that the SAP system has the expected data.
  • SSL certificate issues: The node disables strict SSL verification; if connecting externally, ensure proper certificates or adjust settings accordingly.

Links and References

Discussion