Actions40
- Account Actions
- Contact Actions
- Meter Actions
- Opportunity Actions
- Other Actions
- Purchase Line Item Actions
- Revenue Line Item Actions
- Website Registration Actions
Overview
This node interacts with the SugarCRM API to retrieve multiple purchase line item records ("Get Many" operation on the "Purchase Line Item" resource). It allows users to fetch many records at once, optionally applying query parameters to filter or customize the data returned. This is useful for scenarios such as synchronizing purchase line items from SugarCRM into another system, generating reports, or performing bulk data analysis.
For example, a user might want to retrieve all purchase line items related to a specific product or within a certain date range by specifying query parameters. The node supports returning either all matching records or limiting the number of results.
Properties
| Name | Meaning |
|---|---|
| Send Query Parameters | Whether to send query parameters with the request (true/false). |
| Specify Query Parameters | How to specify query parameters: "Using Fields Below" (individual name-value pairs) or "JSON" (raw JSON object). |
| Query Parameters | List of query parameters as individual name-value pairs (shown if "Using Fields Below" is selected). |
| Query Parameters (JSON) | Query parameters specified as a JSON object (shown if "JSON" option is selected). |
| Send JSON Body | Whether to send a JSON body with the request (true/false). |
| JSON Body | JSON body content to send with the request (shown if "Send JSON Body" is true). |
| Return All | Whether to return all results or only up to a given limit (true/false). |
| Limit | Maximum number of results to return if "Return All" is false (minimum 1). |
Output
The output is an array of JSON objects representing the purchase line item records retrieved from SugarCRM. Each object corresponds to one record and contains fields as returned by the SugarCRM API for purchase line items.
If no records are found, the node throws an error indicating "No records found or unexpected API response structure."
The node does not output binary data.
Dependencies
- Requires valid credentials for SugarCRM API access, including base URL and authentication details.
- Uses OAuth2 password grant flow to obtain an access token before making API requests.
- Requires network connectivity to the SugarCRM instance's REST API endpoint.
Troubleshooting
Error: No records found or unexpected API response structure
This indicates that the API returned no records or the response format was not as expected. Verify that query parameters are correct and that there are matching purchase line items in SugarCRM.Authentication errors
If the node fails to authenticate, check that the provided API credentials (client ID, client secret, username, password) are correct and have sufficient permissions.Malformed JSON input
When specifying query parameters or JSON body as raw JSON, ensure the JSON syntax is valid to avoid parsing errors.Limit vs Return All
If you expect more records but only get limited results, verify that "Return All" is enabled or increase the "Limit" value accordingly.