Halo PSA icon

Halo PSA

Consume Halo PSA API

Actions795

Custom Table → List Of Custom Table

AI-generated

Overview

This node integrates with the Halo PSA API to perform various operations on different resources. Specifically, for the Custom Table resource and the List Of Custom Table operation, it retrieves a list of custom tables from the Halo PSA system based on optional filtering criteria.

Typical use cases include:

  • Fetching custom table definitions or metadata for reporting or synchronization.
  • Filtering custom tables by access control level, usage, or other flags to automate workflows that depend on specific table configurations.
  • Integrating Halo PSA custom table data into other systems or dashboards.

For example, you might use this node to get all custom tables marked as "system only" or those configured for webhook mapping, then process or export that data further in your workflow.

Properties

Name Meaning
Access Control Level Filter custom tables by their access control level.
Customonly Filter to include only custom tables (true/false).
Isconfig Filter tables that are marked as configuration tables (true/false).
Iswebhookmapping Filter tables that have webhook mappings enabled (true/false).
Systemonly Filter to include only system tables (true/false).
Usage Filter tables by their usage type or category.

All these properties are optional query parameters sent to the API to refine the list of custom tables returned.

Output

The node outputs an array of JSON objects, each representing a custom table matching the filter criteria. The structure corresponds directly to the API response for custom tables, typically including fields such as table name, ID, access control level, usage, and flags like customonly, isconfig, etc.

No binary data output is produced by this operation.

Example output snippet (simplified):

[
  {
    "id": "123",
    "name": "Example Custom Table",
    "access_control_level": "Admin",
    "customonly": true,
    "isconfig": false,
    "iswebhookmapping": true,
    "systemonly": false,
    "usage": "General"
  },
  ...
]

Dependencies

  • Requires valid credentials for the Halo PSA API, including base URL, tenant identifier, client ID, and client secret.
  • The node uses HTTP requests to communicate with the Halo PSA REST API.
  • No additional external services beyond Halo PSA are required.

Troubleshooting

  • No credentials returned!
    This error indicates missing or invalid API credentials. Ensure that the API key credential is properly configured in n8n.

  • Resource or Operation not found
    If the specified resource or operation does not exist, verify that the correct resource ("Custom Table") and operation ("List Of Custom Table") names are used.

  • API request failures
    Network issues, incorrect base URL, or invalid authentication tokens can cause request errors. Check connectivity and credential validity.

  • JSON parsing errors
    If using advanced JSON parameters, ensure they are well-formed JSON strings.

  • Continue On Fail behavior
    When enabled, the node will return error messages in the output JSON instead of stopping execution, useful for debugging partial failures.

Links and References

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

Discussion