HaloPSA plugin

Monitor clients, tickets, quotes, invoices, reports and assets from HaloPSA.

Click the following link for additional content such as blogs, videos, use cases, and more:

HaloPSA

Adding a data source

To add a data source click on the + next to Data Sources on the left-hand menu in SquaredUp. Search for the data source and click on it to open the Configure data source page.

Before you start

  1. Decide which authentication method to use.
    The HaloPSA Agent and Application are configured differently for each. SquaredUp supports two authentication methods:
    • Client credentials using Client ID and Secret (Recommended)
    • Basic using Username & Password
  2. Configure an Agent account in HaloPSA
  3. Register an application in HaloPSA
  4. Configure the data source in SquaredUp

Configuring an Agent in HaloPSA

The Agent will need permissions for what you want SquaredUp to show. The Agent is used with both methods of authentication.

  1. Log in to HaloPSA as an administrator.
  2. Navigate to Configuration > Teams & Agents > Agents.
    This will take you to:https://<companyName>.com/config/agents/agents
  3. Click +New
  4. Details tab:
    Complete the mandatory elements of the form.
  5. If using Username & Password authentication the Agent should have the option is an API-Only agent unchecked.
  6. Click Save.
  7. Click on the Permissions tab.
    Under Feature Access set Read Only permissions for the information you want to display. You must give read access to customers, but then further permissions required depend on what you'd like to show in SquaredUp:
    • read:customers (mandatory)
    • read:tickets
    • read:quotes
    • read:invoices
    • read:reporting
    • read:assets

    After updating permissions, Edit your HaloPSA data source and click Test and update, then refresh the tile on your dashboard.

    Optionally, you may also wish to set further Agent permissions if tiles are unexpectedly showing No data. For example, for tickets:
    Permissions tab: Can view Unassigned Tickets: yes

    Permissions tab: Can view Tickets that are assigned to other Agents: yes

    Departments & Teams tab: Membership level to all Departments: View all (Can view all tickets in all Departments)

    See Halo: Agents Guide

  8. Click Save.

For more information see HaloPSA: Agents

Registering an application in HaloPSA

Registering the application generates the client credentials needed to configure the data source in SquaredUp. The application will need permissions for what you want SquaredUp to show (along with the Agent permissions).

  1. Log in to HaloPSA as an administrator.
  2. Navigate to Configuration > Integrations > HaloPSA API > View Applications.
    This will take you to:https://<companyName>.com/config/integrations/api/applications
  3. Click +New
  4. Details tab:
    1. Application Name:
      Enter a name for the registered application. For example, SquaredUp.
    2. Authentication Method:
      Choose the authentication method you prefer. We recommend using a client id and secret, but we also support username and password.
      1. Select Client ID and Secret (Services)
        1. Copy the Client Secret and save it somewhere safe.
        2. Leave the Login Type as Agent.
        3. Select the Agent to log in as from the drop down list.
      2. If you prefer, you might want to use Username & Password.
        1. Select Username & Password.
        2. Ensure Allow Agent Logins is selected.
  5. Permissions tab:
    Set the permissions for the information you want to display. You must give read access to customers, but then further permissions required depend on what you'd like to show in SquaredUp:
    • read:customers (mandatory)
    • read:tickets
    • read:quotes
    • read:invoices
    • read:reporting
    • read:assets

    After updating permissions, Edit your HaloPSA data source and click Test and update, then refresh the tile on your dashboard.

  6. Click Save to register the application. It is added to the list on the Applications page.

Configuring the data source

  1. Display name:
    Enter a name for your data source. This helps you to identify this data source in the list of your data sources.

  2. HaloPSA server URL:
    The address where your environment is located. You'll see this in the address bar of HaloPSA, usually in this format: https://yourcompany.halopsa.com
  3. Authentication:
    1. If you chose Client ID and Secret in HaloPSA, then select Client credentials in SquaredUp:
      1. Client id:
        Enter the Client id for the application you registered in HaloPSA.
      2. Client secret:
        Enter the Client secret for the application you registered in HaloPSA. If you forgot to save it you can Generate it again in HaloPSA.
    2. If you chose Username & Password in HaloPSA, then select Basic in SquaredUp:
      1. Client id:
        Enter the Client id for the app you registered in HaloPSA.
      2. Username:
        Enter the username of your HaloPSA Agent. This must be an Agent, not a User.
      3. Password:
        Enter the password for the Username you entered.
  4. Specific tenant:
    The tenant will be automatically extracted from the server URL (e.g. 'company1' from 'https://company1.halopsa.com'), but you can manually specify a tenant ID by checking this option and entering a tenant id in the box.
    The tenant can be found in HaloPSA from Configuration > Integrations > HaloPSA API
  5. (Optional) Restrict access to this data source:
    You can enable this option if you only want certain users or groups to have access to the data source, or the permission to link it to new workspaces. See data source access control for more information.

  6. Click Test and add to validate the data source configuration. SquaredUp will now attempt to connect to SquaredUp using the provided authentication method.

    • Testing passed – a success message will be displayed and then the configuration will be saved.
    • Testing passed with warnings – warnings will be listed and potential fixes suggested. You can still use the data source with warnings. Select Save with warnings if you believe that you can still use the data source as required with the warnings listed. Alternatively, address the issues listed and then select Rerun tests to validate the data source configuration again. If the validation now passes, click Save.
    • Testing Failed – errors will be listed and potential fixes suggested. You cannot use the data source with errors. You are able to select Save with errors if you believe that a system outside of SquaredUp is causing the error that you need to fix. Alternatively, address the issues listed and then select Rerun tests to validate the data source configuration again. If the validation now passes, click Save.

    You can edit data source configurations at any time from Settings > Data Sources.

Testing and troubleshooting

Test
Error if failed
Troubleshooting
Check HaloPSA URL is valid
Please check server URL and try again later.
Check the HaloPSA URL is correct.
You'll see this in the address bar of HaloPSA, usually in this format, although this may have been changed: https://yourcompany.halopsa.com
Credentials check
Invalid client credentials. Check your client ID.
Check the Client ID for the application you created in HaloPSA.
If you've just created the application, check that you have clicked Save.
Credentials check
Invalid client credentials. Check your client secret.
Check the Client secret for the application in HaloPSA.
If you've just created the application, check that you have clicked Save.
You can edit the application and regenerate the secret if you need to.
Permissions check
You do not have permission to access <permission>. Contact your HaloPSA administrator.
Check that both the application and the Agent have permission to what what you want SquaredUp to show.
Clients - as a minimum both the application and the Agent need the permission read:customers
  • read:customers (mandatory)
  • read:tickets
  • read:quotes
  • read:invoices
  • read:reporting
  • read:assets

After updating permissions, Edit your HaloPSA data source and click Test and update, then refresh the tile on your dashboard.

Check username and password are valid
Invalid credentials. Check your username and password.
Check that the Agent username and password are correct.
Check Agent
Invalid grant.
Check that the Agent configuration in HaloPSA does not have is an API-Only agent checked.

Next Steps

Now that you have successfully added the data source you can create dashboards, view the data streams, or explore any indexed objects.

Data streams

Data stream
Description
Assets (by Client)
Returns a detailed inventory of physical or digital assets associated with a client or organization.
Invoices (by Client)
Returns HaloPSA invoices filtered by client.
Quotes (by Client)
Returns HaloPSA quotes/quotations filtered by client.
Tickets (by Client)
Returns HaloPSA tickets filtered by client.

Configurable data streams

The following data streams installed with this plugin have configurable Parameters.

Data stream
Description
Parameters
Client Details
Returns detailed information for a specific HaloPSA client.
  • Client ID:
    Enter the ID of the client to retrieve details for.
Clients
Returns a list of your HaloPSA clients with related data such as the name, status, type and email.
  • Client status:
    Select the status of a client to filter by.
Invoices
Returns HaloSPA invoices.
  • Invoice status:
    Select an invoice status to filter by.
  • Include custom fields & Include ticket details:
    Optionally, you can include custom fields and ticket details, but this may slow down the query
  • Timeframe based on:
    Use the dropdown list to select which date field to use for timeframe filtering.
Report data
Returns data for a specific report.
  • Report:
    Select a report from the dropdown list.
  • Report parameters:
    Optionally, enter additional parameters to filter by.
Report List
Lists available reports in HaloPSA.
  • Search:
    Specify the name of a report to filter by.
Tickets
Returns your support and service tickets managed within HaloPSA. This data stream is available as both a global data stream and a data stream that is scoped to Client/s.
  • Ticket status:
    Select a ticket status to filter by.

Was this article helpful?


Have more questions or facing an issue?