Actions19
- Bank Page Actions
- External Reconciliation Cancel Actions
- External Reconciliation Reconcile Actions
- Incoming Payment Actions
- Vendor Payment Actions
Overview
This node integrates with the SAP B1 Service Layer 6 focused on bank management operations, specifically handling vendor payments among other resources. The "Get by Key" operation for the "Vendor Payment" resource retrieves detailed information about a specific vendor payment document identified by its unique key (DocEntry). This is useful in scenarios where you need to fetch exact payment details for auditing, reconciliation, or further processing within an automated workflow.
Practical example:
A finance team automates their payment approval process and wants to retrieve the full details of a vendor payment by its document ID to verify amounts and statuses before proceeding with approval or cancellation.
Properties
| Name | Meaning |
|---|---|
| DocEntry | Identifier of the document (vendor payment) to retrieve. This is a required string input. |
Output
The output is a JSON object representing the vendor payment data retrieved from the SAP B1 Service Layer. It contains all fields and nested information related to the specified vendor payment document as returned by the SAP API.
- The output is structured as an array of items, each with a
jsonproperty containing the vendor payment details. - If an error occurs during the request, the output will contain an
errorfield with the error message. - No binary data output is produced by this operation.
Dependencies
- Requires connection to SAP B1 Service Layer 6 via an API endpoint.
- Needs credentials including base URL, username, password, and company database name.
- The node performs a login request to obtain session cookies used for subsequent API calls.
- The environment must allow HTTPS requests to the SAP B1 Service Layer with certificate verification disabled (
rejectUnauthorized: false).
Troubleshooting
- Authentication errors: If login fails, check that the provided credentials (username, password, company DB) are correct and that the SAP B1 Service Layer is accessible.
- Document not found: If the specified
DocEntrydoes not exist, the API may return an error or empty response. Verify the document ID is valid. - Network issues: Ensure the n8n instance can reach the SAP B1 Service Layer URL and that no firewall or proxy blocks the requests.
- Invalid JSON body: Although not applicable for "Get by Key," other operations require a valid JSON body; malformed JSON will cause errors.
- Session cookie missing: The node relies on cookies set by the login response. If these are not present, subsequent requests will fail.
Links and References
If you need details on other operations or resources, feel free to ask!