ConnectWise Manage icon

ConnectWise Manage

Consume ConnectWise Manage API

Actions102

Overview

The node integrates with the ConnectWise Manage API to perform various operations on different resources, including invoices. Specifically, for the Invoice - Get Many operation, it retrieves multiple invoice records from the ConnectWise Manage system. This is useful for scenarios where you need to fetch a list of invoices for reporting, synchronization, or further processing in an automation workflow.

Typical use cases include:

  • Retrieving all invoices within a certain page or limit for batch processing.
  • Fetching invoices ordered by specific fields such as ID or date.
  • Paginating through large sets of invoices efficiently.
  • Integrating invoice data into other systems like accounting or CRM platforms.

For example, you might use this node to get the first 100 invoices ordered by their creation date descending, then process each invoice to update your internal financial records.

Properties

Name Meaning
Return All Whether to return all matching invoices or only up to a specified limit.
Limit Maximum number of invoices to return when "Return All" is false.
Page Number The page number of results to retrieve (starts at 1).
Page Size Number of invoices to return per page (minimum 1, maximum 1000).
Order By Field to order the results by, e.g., "id" or "ID desc" to sort by invoice ID descending.

Note: The Order By property appears twice in the provided properties but serves the same purpose — specifying the sorting field and direction for the returned invoices.

Output

The output consists of JSON objects representing individual invoices retrieved from ConnectWise Manage. Each item corresponds to one invoice record with its full set of fields as returned by the API.

  • When multiple invoices are returned, each invoice is output as a separate item.
  • If binary data were involved (e.g., document downloads), it would be included in a binary property, but for the "Get Many" invoice operation, only JSON data is returned.

Example output structure (simplified):

{
  "invoiceId": 12345,
  "company": { /* company details */ },
  "amount": 1500.00,
  "status": "Approved",
  "dateCreated": "2023-01-15T12:34:56Z",
  ...
}

Dependencies

  • Requires an active connection to the ConnectWise Manage API.
  • Needs an API authentication credential configured in n8n (an API key or token).
  • The node uses the base URL from the credential configuration to construct API requests.
  • No additional external dependencies beyond the ConnectWise Manage API.

Troubleshooting

  • Common Issues:

    • Invalid or missing API credentials will cause authentication failures.
    • Incorrect Order By field names may result in API errors or unexpected ordering.
    • Requesting pages beyond available data returns empty results.
    • Exceeding the maximum allowed Page Size (1000) will likely cause errors.

  • Error Messages:

    • "Operation 'getAll' is not supported": Indicates the operation name is incorrect or unsupported for the resource.
    • "Resource 'invoice' is not supported": Means the resource name is invalid or not implemented.
    • API request failures often include error details logged in the node's debug console.
    • Network or connectivity issues will throw generic API request failure errors.

  • Resolutions:

    • Verify API credentials and permissions.
    • Use valid field names for ordering and filtering.
    • Adjust pagination parameters within allowed limits.
    • Enable "Continue On Fail" in the node settings to handle partial failures gracefully.

Links and References

This summary is based solely on static analysis of the provided source code and property definitions without runtime execution.

Discussion