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 execute predefined SQL queries on an SAP system. It allows users to run custom SQL queries by specifying the query name and optional parameters, enabling flexible data retrieval or updates directly via SQL.

Common scenarios include:

  • Retrieving specific datasets from SAP using complex SQL queries.
  • Updating records in bulk based on dynamic parameters.
  • Running parameterized reports or batch operations defined as SQL queries in SAP.

For example, a user might execute a query named PlantScannerStockUpdateOnly with a date parameter to update stock information for a particular day.

Properties

Name Meaning
Query Name The name of the SQL query to execute (e.g., PlantScannerGetFirstBatch, PlantScannerStockUpdateOnly). This identifies which predefined SQL query in SAP to run.
Query Parameters Optional string parameters to pass in the body of the SQL query request (e.g., updateDate='20240616'). Leave empty if no parameters are needed.
URL Parameters Optional URL query parameters appended to the request URL (e.g., updateDate=20240614&$skip=400). Leave empty if not required.

Output

The node outputs the JSON response returned by the SAP Service Layer after executing the SQL query. This typically contains the result set or status of the executed query under the json field.

If the query returns tabular data, it will be structured as an array of objects representing rows. If the query performs an update or other action, the output reflects the operation's result accordingly.

No binary data output is produced by this node.

Dependencies

  • Requires connection credentials to the SAP Service Layer API, including URL, company database, username, password, and optionally language.
  • Uses HTTPS requests with disabled SSL certificate verification (rejectUnauthorized: false) to communicate with SAP.
  • Relies on session cookie authentication obtained via a login POST request before executing queries.

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 is requested. Ensure "Execute Query" operation is selected for SQL queries.
  • Invalid query name or parameters: If the specified SQL query does not exist or parameters are malformed, SAP may return errors. Double-check query names and parameter formatting.
  • Network or SSL errors: Since SSL verification is disabled, ensure the SAP endpoint is reachable and trusted.
  • Error responses from SAP: The node captures error messages from SAP and includes them in the output JSON under an error field when continuing on failure.

Links and References

Discussion