Halo PSA icon

Halo PSA

Consume Halo PSA API

Actions795

SQL Import → Delete Undefined

AI-generated

Overview

This node integrates with the Halo PSA API to perform various operations on different resources. Specifically, for the SQL Import resource and the Delete Undefined operation, it deletes an entry identified by a given ID from the SQL import data in Halo PSA.

Common scenarios where this node is useful include automating cleanup tasks in Halo PSA, such as removing undefined or unwanted SQL import records based on their IDs. For example, if you have imported data into Halo PSA and want to programmatically delete certain entries that are no longer needed or were incorrectly imported, this node can be used to automate that process.

Properties

Name Meaning
Id The numeric identifier of the SQL import record to delete. This property is required.

Output

The node outputs JSON data representing the response from the Halo PSA API after attempting the deletion. The structure typically contains confirmation of the deletion or details about the deleted record. If an error occurs, the output JSON will contain an error field with the error message.

No binary data output is produced by this operation.

Dependencies

  • Requires valid credentials to authenticate with the Halo PSA API. These credentials must include:

    • Base URL of the Halo PSA instance.
    • Tenant identifier.
    • Client ID.
    • Client Secret.

  • The node uses these credentials to set appropriate HTTP headers for API requests.

  • Network access to the Halo PSA API endpoint is necessary.

Troubleshooting

  • Common Issues:

    • Missing or invalid credentials will cause the node to throw an error indicating "No credentials returned!".
    • Providing an invalid or non-existent ID may result in an API error response.
    • Network connectivity issues can prevent successful API calls.

  • Error Messages:

    • "No credentials returned!": Ensure that the API authentication credentials are correctly configured in n8n.
    • "Resource SQL Import not found" or "Operation Delete Undefined not found for resource SQL Import": Indicates misconfiguration of resource or operation parameters.
    • API errors returned from Halo PSA (e.g., 404 Not Found if the ID does not exist) will be included in the output JSON under the error key if "Continue On Fail" is enabled.

  • Resolution Tips:

    • Verify that the provided ID corresponds to an existing SQL import record.
    • Confirm that the API credentials are valid and have sufficient permissions.
    • Check network connectivity and API endpoint accessibility.

Links and References

Discussion