Overview
This node interacts with the SAP Business One Service Layer specifically for managing projects ("Gestion de Proyectos"). It allows users to perform various operations on project management data such as creating, retrieving, updating, deleting, and canceling projects within SAP B1.
The "Get by Key" operation retrieves a single project based on its unique identifier (DocEntry). This is useful when you need to fetch detailed information about a specific project, for example, to display project details in a dashboard or to use the project data in subsequent workflow steps.
Practical examples:
- Fetching a project by its key to verify its status before performing an update.
- Retrieving project details to generate reports or send notifications.
- Accessing a project record to validate data integrity or audit changes.
Properties
| Name | Meaning |
|---|---|
| DocEntry | The unique numeric identifier of the project to retrieve. Required for this operation. |
Output
The output is an array of JSON objects where each object corresponds to one input item processed. For the "Get by Key" operation, the json field contains the full project data retrieved from SAP B1 Service Layer for the specified DocEntry.
If an error occurs during the request, the output will contain a JSON object with an error field describing the issue.
No binary data is output by this node.
Dependencies
- Requires connection credentials to the SAP Business One Service Layer API, including:
- Base URL of the SAP B1 Service Layer.
- Username and password for authentication.
- 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 endpoint.
Troubleshooting
- Authentication errors: If login fails, check that the username, password, and company database are correct and that the SAP B1 Service Layer is accessible.
- Invalid DocEntry: Providing a non-existent or incorrect
DocEntrywill result in an error or empty response. Verify the key exists in SAP B1. - Network issues: Ensure the n8n instance can reach the SAP B1 Service Layer URL and that SSL certificates are valid or properly handled (the node disables strict SSL verification).
- API errors: The node returns error messages from the SAP B1 API in the output's
errorfield. Review these messages to diagnose issues like permission problems or malformed requests.
Links and References
- SAP Business One Service Layer Documentation
- SAP B1 Project Management API Reference (example placeholder link)