ConnectWise Manage icon

ConnectWise Manage

Consume ConnectWise Manage API

Overview

The node integrates with the ConnectWise Manage API to retrieve multiple purchase orders ("Get Many" operation on the "Purchase Order" resource). It allows users to fetch a list of purchase orders with flexible pagination, ordering, and filtering options. This is useful for scenarios such as synchronizing purchase order data into other systems, generating reports, or automating workflows that depend on procurement data.

For example, a user might want to retrieve all purchase orders sorted by creation date descending, or fetch a specific page of purchase orders limited to 100 entries per request.

Properties

Name Meaning
Return All Whether to return all purchase orders or limit the number of results returned.
Limit Maximum number of purchase orders to return (used if "Return All" is false).
Page Number The page number to retrieve when paginating through purchase orders (starts at 1).
Page Size Number of purchase orders to return per page (max 1000).
Order By Field to order the results by, e.g., "id", "ID desc", or any valid field name with direction.

Note: The "Order By" property controls sorting of the returned purchase orders.

Output

  • The output is an array of JSON objects, each representing a purchase order retrieved from ConnectWise Manage.
  • Each item contains the full JSON representation of a purchase order as returned by the API.
  • There is no binary data output for this operation.

Example output structure (simplified):

[
  {
    "purchaseOrderId": 123,
    "vendorId": 456,
    "orderDate": "2023-01-01T00:00:00Z",
    "status": "Approved",
    ...
  },
  {
    "purchaseOrderId": 124,
    "vendorId": 789,
    "orderDate": "2023-01-02T00:00:00Z",
    "status": "Pending",
    ...
  }
]

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 configured in the credentials.
  • No additional external dependencies are required.

Troubleshooting

  • Common issues:

    • Invalid or missing API credentials will cause authentication failures.
    • Requesting pages beyond available data may return empty arrays.
    • Using unsupported or misspelled "Order By" fields can result in API errors.
    • Exceeding maximum page size (1000) will be rejected by the API.
  • Error messages:

    • "Operation 'getAll' is not supported": Indicates the operation name is incorrect or not implemented for the resource.
    • "Resource 'purchaseOrder' is not supported": The resource name is invalid or not recognized.
    • API request failures will include error details from ConnectWise Manage; check credentials and network connectivity.
    • Pagination parameters must be positive integers; otherwise, errors may occur.
  • Resolution tips:

    • Verify API credentials and permissions.
    • Use valid property values according to the documentation.
    • Handle empty results gracefully in workflows.
    • Enable "Return All" only when expecting manageable data volumes.

Links and References

Discussion