AvantGuard - DNSFilter icon

AvantGuard - DNSFilter

AvantGuard - DNSFilter

Actions277

Overview

This node operation, "Distributors Msps Index," retrieves a list of Managed Service Providers (MSPs) associated with distributors. It allows filtering and querying MSPs based on various criteria such as creation date, cancellation status, distributor ID, MSP name, and other attributes. This is useful for scenarios where you need to analyze or report on MSPs managed by distributors, track their statuses, or integrate MSP data into workflows.

Practical examples include:

  • Fetching all active MSPs created within a specific time range.
  • Listing MSPs filtered by distributor SKU or status.
  • Retrieving canceled MSPs only for audit or cleanup purposes.
  • Paginating through large sets of MSP records for batch processing.

Properties

Name Meaning
Additional Query Parameters Optional filters and parameters to refine the MSP search query. These include:
- Canceled At From/To: Unix timestamp range for cancellation time (requires canceled filter).
- Created At From/To: Unix timestamp range for creation time.
- Distributor Id: Case-insensitive pattern to filter by distributor ID.
- Distributor Sku: Case-sensitive exact match for distributor SKU.
- Distributor Status: Case-sensitive exact match for distributor status.
- External Id: Case-insensitive pattern for external ID.
- Include Canceled: Boolean to include canceled MSPs (default true). Ignored if Only Canceled is true.
- Msp Name: Case-insensitive pattern to filter MSP names.
- Only Canceled: Boolean to filter only canceled MSPs (default true).
- Page: JSON object specifying page number and size (defaults to 1 and 1500 respectively).
- Parent Organization Name: Case-insensitive pattern for parent organization name.
- Transferred At From/To: Unix timestamp range for transfer time.
- Trial End: Exact ISO8601 date string to filter trial end date.
- Updated At From/To: Unix timestamp range for last update time.

Output

The node outputs JSON data representing the list of MSPs matching the query parameters. Each item in the output typically contains detailed information about an MSP, including identifiers, status, timestamps, and related distributor information.

If binary data were involved, it would be summarized here, but this operation focuses on JSON data retrieval.

Dependencies

  • Requires an API key credential for authenticating requests to the external service managing distributor and MSP data.
  • The node uses HTTP requests to communicate with the external API endpoint.
  • No additional environment variables are explicitly required beyond the API authentication setup.

Troubleshooting

  • Empty results: Ensure that the query parameters are correctly set and that the filters do not exclude all records unintentionally (e.g., conflicting date ranges or mutually exclusive flags like include_canceled and only_canceled).
  • Authentication errors: Verify that the API key credential is valid and has sufficient permissions.
  • Rate limiting or API errors: Check the external service's API limits and error messages; implement retries or backoff as needed.
  • Invalid parameter formats: For date/time filters, ensure timestamps are Unix epoch numbers and dates are in ISO8601 format where required.

Links and References

  • Refer to the external API documentation for detailed descriptions of each query parameter and response structure.
  • n8n documentation on how to configure API credentials and use HTTP request nodes may help in setting up this node properly.

Discussion