SugarCRM icon

SugarCRM

Interact with SugarCRM API

Actions40

Overview

This node interacts with the SugarCRM API to retrieve a single Revenue Line Item record by its ID. It is useful when you need to fetch detailed information about a specific revenue line item stored in SugarCRM, such as for reporting, data synchronization, or further processing within an automation workflow.

Typical use cases include:

  • Retrieving details of a particular revenue line item to display or process in another system.
  • Fetching a record before updating or deleting it.
  • Integrating SugarCRM revenue data into dashboards or reports.

Properties

Name Meaning
ID The unique identifier of the Revenue Line Item record to retrieve.
Send Query Parameters Whether to send additional query parameters with the request (true/false).
Specify Query Parameters How to specify query parameters if sending them: either "Using Fields Below" or "JSON".
Query Parameters List of name-value pairs specifying query parameters (used if "Using Fields Below" selected).
Query Parameters (JSON) Query parameters specified as a JSON object (used if "JSON" option selected).

Output

The output is a JSON object representing the retrieved Revenue Line Item record from SugarCRM. The structure corresponds directly to the SugarCRM API response for a single record and includes all fields available for that record.

If multiple items were processed, each output item corresponds to one input item, containing the respective record's JSON data.

No binary data output is produced by this operation.

Dependencies

  • Requires a configured API authentication credential for SugarCRM with appropriate permissions.
  • The node uses OAuth2 password grant flow to obtain an access token from SugarCRM.
  • Network access to the SugarCRM instance's REST API endpoint is required.

Troubleshooting

  • Error: No records found or unexpected API response structure
    This error may occur if the provided ID does not exist or the API response is malformed. Verify the ID is correct and that the SugarCRM instance is accessible.

  • Authentication errors
    Ensure the API credentials (client ID, client secret, username, password) are valid and have sufficient permissions.

  • Invalid JSON in query parameters or custom JSON body
    If using JSON input for query parameters, ensure the JSON syntax is correct to avoid parsing errors.

  • Network or connectivity issues
    Confirm that the SugarCRM API URL is reachable from the n8n environment.

Links and References

Discussion