Autotask icon

Autotask

Consume Autotask REST API
Join our community

Actions389

Overview

The 'Get Many (Advanced)' operation for the 'Ticket' resource in the Autotask node allows users to retrieve multiple ticket records from the Autotask REST API using advanced filtering criteria. This operation is beneficial when users need to query tickets based on complex conditions beyond simple filters, such as combining multiple field criteria in a JSON filter array. For example, a user can fetch all tickets assigned to a specific technician with a certain status and created within a date range. It supports returning all matching records or limiting the number of results, and can enrich the output with human-readable labels for picklist and reference fields.

Properties

Name Meaning
Get All Determines whether to return all matching ticket records or limit the results to a specified maximum number.
Max Records Specifies the maximum number of ticket records to return when 'Get All' is false. The value must be between 1 and 500.
Advanced Filter A required JSON string containing a 'filter' array that defines the Autotask API query criteria for filtering tickets. This allows complex queries using Autotask's REST API filtering syntax.
Add Picklist Labels If enabled, adds additional fields with '_label' suffix containing human-readable values for picklist fields in the ticket data.
Add Reference Labels If enabled, adds additional fields with '_label' suffix containing human-readable values for reference fields in the ticket data.
Select Columns Names or IDs. Allows selection of specific ticket fields to include in the response. If no fields are selected, all fields are returned. The ID field is always included.
Flatten User-Defined Fields If enabled, user-defined fields (UDFs) are moved to the top level of each ticket object instead of being nested inside a 'userDefinedFields' array.

Output

JSON

  • id - Unique identifier of the ticket.
  • fieldName - Various ticket fields as specified by the selected columns or all fields if none selected.
  • fieldName_label - Human-readable label for picklist or reference fields if 'Add Picklist Labels' or 'Add Reference Labels' is enabled.
  • userDefinedFields - Array of user-defined fields associated with the ticket, unless 'Flatten User-Defined Fields' is enabled.
  • userDefinedFieldName - User-defined fields promoted to top-level properties if 'Flatten User-Defined Fields' is enabled.

Dependencies

  • Requires an Autotask API key credential for authentication to access the Autotask REST API.

Troubleshooting

  • Invalid JSON in 'Advanced Filter' property can cause query failures. Ensure the JSON string is correctly formatted and follows Autotask API filter syntax.
  • Requesting too many records without pagination or 'Get All' enabled may lead to timeouts or API limits being hit.
  • Selecting fields that do not exist or are misspelled in 'Select Columns' may result in incomplete data or errors.
  • If labels are not appearing as expected, verify that 'Add Picklist Labels' and 'Add Reference Labels' are enabled and that the fields support labels.
  • API authentication errors may occur if the Autotask API key credential is missing, invalid, or expired.

Links

Discussion