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 integrates with the SugarCRM API to perform various operations on SugarCRM resources, specifically here focusing on the Account resource with the Get Many operation. It allows users to retrieve multiple Account records from SugarCRM, optionally filtering or limiting the results using query parameters.
Common scenarios where this node is beneficial include:
- Fetching a list of accounts for reporting or analysis.
- Synchronizing account data between SugarCRM and other systems.
- Automating workflows that require bulk retrieval of account information.
For example, you might use this node to get all accounts created in the last month by specifying appropriate query parameters, or limit the number of accounts retrieved to avoid processing large datasets at once.
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 (used if "Using Fields Below" is selected). |
| Query Parameters (JSON) | Query parameters specified as a JSON object (used 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 (if "Send JSON Body" is true). |
| Return All | Whether to return all matching results (true) or limit the number of results (false). |
| Limit | Maximum number of results to return (used if "Return All" is false). |
Output
The output is an array of JSON objects representing the Account records retrieved from SugarCRM. Each object corresponds to one Account record and contains fields as returned by the SugarCRM API.
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 connection to a SugarCRM instance via an API key credential (an API authentication token).
- The node uses OAuth2 password grant flow internally to obtain access tokens.
- Requires configuration of SugarCRM API credentials including base URL, client ID, client secret, username, and password.
- Network connectivity to the SugarCRM REST API endpoint.
Troubleshooting
Error: No records found or unexpected API response structure
This indicates that either no Account records matched the query parameters or the API response was not as expected. Check your query parameters and ensure the SugarCRM instance has matching data.Authentication errors
If the node fails to authenticate, verify that the provided API credentials are correct and have sufficient permissions.Malformed JSON in query parameters or JSON body
When specifying query parameters or JSON body as raw JSON, ensure the JSON syntax is valid to avoid parsing errors.Limit vs Return All confusion
If you want to retrieve all records, set "Return All" to true. Otherwise, specify a reasonable "Limit" to avoid performance issues.