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 within ConnectWise Manage. Specifically, for the Expense resource with the Get Many operation, it retrieves multiple expense records from the system.

This operation is useful when you want to fetch a list of expenses for reporting, auditing, or further processing in your workflow. For example, you might use this node to:

  • Retrieve all expenses submitted within a certain period.
  • Fetch a paginated list of expenses ordered by date or amount.
  • Integrate expense data into an accounting or ERP system.

The node supports pagination and ordering, allowing flexible retrieval of large datasets.

Properties

Name Meaning
Return All Whether to return all results or only up to a given limit (boolean).
Limit Maximum number of results to return if not returning all (number, minimum 1).
Page Number The page number to retrieve, starting at 1 (number, minimum 1).
Page Size Number of results per page, between 1 and 1000 (number).
Order By Field to order results by, e.g., "id", "ID desc" (string).

These properties control how many expense records are fetched and in what order. If "Return All" is true, the node will paginate through all available pages automatically up to a maximum page size of 1000 per request.

Output

The output is an array of JSON objects, each representing an expense record retrieved from ConnectWise Manage. Each item corresponds to one expense entity with fields as returned by the API, such as expense ID, description, amount, date, and other relevant expense details.

If the node is configured to return all results, the output will include all matching expenses across multiple pages.

No binary data is output for this operation.

Dependencies

  • Requires an API key credential for authenticating with the ConnectWise Manage API.
  • The node makes HTTP requests to the ConnectWise Manage REST API endpoint specified in the credentials.
  • Proper permissions in ConnectWise Manage are required to read expense data.

Troubleshooting

  • Common Issues:

    • Invalid or missing API credentials will cause authentication failures.
    • Requesting a page number beyond the available range may return empty results.
    • Using invalid field names in "Order By" can result in API errors.
    • Exceeding the maximum allowed page size (1000) will be rejected.

  • Error Messages:

    • "Operation 'getAll' is not supported": Indicates the operation name is incorrect or unsupported for the resource.
    • "Resource 'expense' is not supported": The resource name is invalid or not implemented.
    • API request failures will throw errors with messages from the ConnectWise Manage API; check the error response body for details.
    • Missing required parameters like page number or limit when "Return All" is false may cause errors.

  • Resolutions:

    • Verify API credentials and permissions.
    • Use valid property values according to the documentation.
    • Handle pagination carefully, especially when "Return All" is false.
    • Review API limits and adjust page size accordingly.

Links and References

Discussion