Autotask icon

Autotask

Interact with Kaseya's Autotask PSA REST API to manage companies, tickets, contracts, and more.

Actions524

Company Location → Get Many (Advanced)

AI-generated

Overview

This node operation retrieves multiple company location records from the Autotask PSA system using advanced filtering criteria. It is useful for scenarios where users need to query company locations with specific conditions, such as filtering by attributes or applying complex search filters. For example, a user might want to get all company locations in a certain region or with particular attributes for reporting or integration purposes.

Use Case Examples

  1. Retrieve all company locations with a specific attribute using an advanced JSON filter.
  2. Fetch a limited number of company location records matching complex criteria for data synchronization.

Properties

Name Meaning
Get All Whether to return all results or only up to a given limit.
Max Records Maximum number of records to return when not returning all (range 1-500).
Advanced Filter A JSON string containing a "filter" array with Autotask API query criteria to specify complex search conditions.
Add Picklist Labels Whether to automatically add "_label" fields for picklist fields with human-readable values (no labels added for empty values).
Add Reference Labels Whether to automatically add "_label" fields for reference fields with human-readable values (no labels added for empty values).
Select Columns Names or IDs. Choose which fields to include in the response. If no fields are selected, all fields will be returned. The ID field is always included regardless of selection.
Flatten User-Defined Fields Whether to bring user-defined fields up to the top level of each object, making them accessible as top-level properties instead of nested in the userDefinedFields array.

Output

JSON

  • id - Unique identifier of the company location record.
  • name - Name of the company location.
  • address - Address details of the company location.
  • phone - Phone number associated with the company location.
  • email - Email address associated with the company location.
  • _label - Human-readable labels for picklist or reference fields if enabled.
  • userDefinedFields - Array of user-defined fields related to the company location, or flattened as top-level properties if the flatten option is enabled.

Dependencies

  • An API key credential for Autotask PSA REST API authentication.

Troubleshooting

  • Ensure the advanced filter JSON string is correctly formatted and valid according to Autotask API query criteria to avoid query errors.
  • If no records are returned, verify the filter criteria and consider adjusting the 'Get All' and 'Max Records' settings.
  • If picklist or reference labels are not appearing, check that the corresponding options to add labels are enabled.
  • API rate limits may affect large data retrievals; monitor and handle rate limiting as per Autotask API guidelines.

Links

Discussion