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 allows interaction with the SugarCRM API, specifically supporting operations on a custom or "Other" resource endpoint. It enables users to retrieve single records or multiple records from any custom SugarCRM module by specifying the custom endpoint name. The node supports sending query parameters either as individual fields or as a JSON object to filter or modify the data retrieval.
Common scenarios include:
- Fetching data from custom modules in SugarCRM that are not covered by standard resources.
- Retrieving specific records by ID or querying multiple records with filters.
- Integrating SugarCRM custom data into workflows for reporting, automation, or synchronization with other systems.
Example use case:
- A user wants to get all records from a custom SugarCRM module named
CustomModule_cwith specific filtering criteria sent as query parameters.
Properties
| Name | Meaning |
|---|---|
| Custom Endpoint | The API endpoint name of the custom SugarCRM module to interact with (e.g., CustomModule_c). |
| Send Query Parameters | Whether to include query parameters in the GET request to filter or modify results. |
| Specify Query Parameters | How to specify query parameters: either using individual fields below or a JSON object. |
| Query Parameters | List of key-value pairs representing query parameters when specifying them using fields. |
| Query Parameters (JSON) | Query parameters specified as a JSON object string. |
Output
The node outputs JSON data representing the retrieved SugarCRM records:
- For the Get operation, the output is a single record object matching the requested ID and query parameters.
- For the Get Many operation, the output is an array of record objects matching the query parameters and limit settings.
- Each record corresponds to the structure returned by the SugarCRM API for the specified custom endpoint.
- No binary data output is produced by this node.
Dependencies
- Requires connection credentials to SugarCRM API including base URL and authentication details.
- Needs an API authentication token obtained via OAuth2 password grant flow.
- The node uses the SugarCRM REST API version
v11_11. - Proper configuration of the SugarCRM API credentials in n8n is necessary.
Troubleshooting
- No records found or unexpected API response structure: This error occurs if the API returns no records or the response format is not as expected. Verify the custom endpoint name and query parameters are correct.
- Authentication errors: If the node fails to authenticate, check that the API credentials (client ID, client secret, username, password, and base URL) are correctly configured.
- Invalid JSON in query parameters or JSON body: When specifying query parameters or JSON bodies as JSON strings, ensure they are valid JSON to avoid parsing errors.
- Missing required properties: The "Custom Endpoint" property is mandatory for the "Other" resource; ensure it is provided.