Actions88
- Purchase Credit Note Actions
- Purchase Invoice Actions
- Purchase Delivery Note Actions
- Purchase Down Payment Actions
- Purchase Order Actions
- Purchase Quotation Actions
- Purchase Request Actions
- Purchase Return Actions
- Purchase Tax Invoice Actions
Overview
This node integrates with the SAP Service Layer to manage purchase-related entities, specifically here focusing on Purchase Quotations. The "Get by Key (Select)" operation retrieves a single purchase quotation identified by its unique key (DocEntry), allowing users to specify which fields to return via an OData $select query parameter.
Typical use cases include:
- Fetching detailed information about a specific purchase quotation for review or processing.
- Retrieving only relevant fields from a purchase quotation to optimize data transfer and processing.
- Integrating SAP purchase quotation data into workflows for reporting, auditing, or triggering downstream actions.
For example, you might want to get the DocEntry, CardCode, and DocTotal fields of a purchase quotation with DocEntry 123 to display summary info in a dashboard.
Properties
| Name | Meaning |
|---|---|
| DocEntry | The unique identifier (number) of the purchase quotation to retrieve. Required. |
| Select | Comma-separated list of fields to return from the purchase quotation (used as $select). |
Example values for Select: DocEntry,CardCode,DocTotal
Output
The node outputs JSON data representing the purchase quotation record retrieved from SAP Service Layer. The structure corresponds to the selected fields of the purchase quotation entity.
Output format example (simplified):
{
"DocEntry": 123,
"CardCode": "C0001",
"DocTotal": 1500.00
}
If no Select fields are specified, the full purchase quotation object is returned.
No binary data output is produced by this operation.
Dependencies
- Requires connection credentials to SAP Service Layer API, including:
- Base URL of the SAP Service Layer endpoint.
- Username and password for authentication.
- Company database name.
- The node authenticates by sending a login POST request to
/Loginand uses session cookies for subsequent requests. - Network access to the SAP Service Layer must be configured and allowed.
- No additional external dependencies beyond standard HTTP requests.
Troubleshooting
- Authentication errors: If login fails, verify the SAP Service Layer credentials (username, password, company DB) and network connectivity.
- Invalid DocEntry: If the specified
DocEntrydoes not exist, the API may return an error or empty result. - Malformed Select string: Ensure the
Selectproperty contains valid field names separated by commas without extra spaces or invalid characters. - Permission issues: The user account used must have sufficient permissions to read purchase quotations.
- SSL issues: The node disables strict SSL verification (
rejectUnauthorized: false), but if your environment requires strict SSL, adjust accordingly. - API endpoint changes: Confirm that the SAP Service Layer version and endpoints match those expected by the node.
Error messages returned by the node will include the error message from the SAP Service Layer API, helping diagnose issues.
Links and References
- SAP Business One Service Layer Documentation
- OData Query Options
- n8n HTTP Request Node Documentation (for understanding underlying HTTP calls)
This summary focuses on the Purchase Quotation resource and the Get by Key (Select) operation as requested.