Actions10
- Employees Info Actions
- Project Management Time Sheet Actions
Overview
This node interacts with the SAP B1 Service Layer specifically for Project Management Time Sheets. The "Get by Key" operation retrieves a single time sheet record identified by its unique key (DocEntry). This is useful when you need to fetch detailed information about a specific time sheet entry, such as for review, reporting, or further processing in an automation workflow.
Practical examples include:
- Retrieving a particular employee's time sheet entry to verify hours worked.
- Fetching a time sheet record before updating or deleting it.
- Integrating SAP time sheet data into other systems or dashboards by pulling individual records on demand.
Properties
| Name | Meaning |
|---|---|
| DocEntry | The unique numeric identifier (key) of the time sheet record to retrieve. Required. |
Output
The node outputs JSON data representing the requested time sheet record from SAP B1 Service Layer. The structure corresponds directly to the SAP entity for Project Management Time Sheet and includes all fields returned by the API for that record.
If an error occurs (e.g., invalid key or connectivity issues), the output JSON will contain an error field with the error message.
The node does not output binary data.
Dependencies
- Requires connection credentials to the SAP B1 Service Layer API, including:
- Base URL of the SAP B1 Service Layer instance.
- Username and password for authentication.
- Company database name.
- The node performs a login request to obtain session cookies used for subsequent API calls.
- No additional external dependencies beyond the SAP B1 Service Layer API and valid credentials.
Troubleshooting
Common Issues:
- Invalid
DocEntryvalue: If the key does not exist, the API may return an error or empty response. - Authentication failures: Incorrect credentials or expired sessions can cause login or request failures.
- Network or SSL issues: The node disables strict SSL verification (
rejectUnauthorized: false), but network problems can still occur.
- Invalid
Error Messages:
- Errors are returned in the output JSON under the
errorproperty. - Typical messages include authentication errors, resource not found, or connection timeouts.
- Errors are returned in the output JSON under the
Resolutions:
- Verify the
DocEntryis correct and exists in SAP. - Check credentials and ensure the user has permission to access the time sheet data.
- Confirm network connectivity to the SAP B1 Service Layer endpoint.
- Review SAP logs if available for more detailed error diagnostics.
- Verify the
Links and References
- SAP Business One Service Layer Documentation
- n8n HTTP Request Node Documentation (for understanding underlying request mechanics)