Autotask icon

Autotask

Consume Autotask REST API

Actions389

Overview

The 'Get Many (Advanced)' operation for the 'Service Call' resource in the Autotask node allows users to retrieve multiple service call records from the Autotask REST API using advanced filtering criteria. This operation is beneficial when users need to query service calls with complex conditions beyond simple filters, enabling precise data retrieval. For example, a user can fetch all service calls that meet specific status, priority, or date range criteria by providing a JSON filter array. It supports returning all matching records or limiting the number of results, and can enhance the output by adding human-readable labels for picklist and reference fields, as well as flattening user-defined fields for easier access.

Properties

Name Meaning
Get All Determines whether to return all matching service call records or limit the results to a specified maximum number.
Max Records Specifies the maximum number of service call 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 service calls. This allows complex queries using Autotask's REST API filtering syntax.
Add Picklist Labels Indicates whether to automatically add '_label' fields to picklist fields in the output, providing human-readable values for those fields.
Add Reference Labels Indicates whether to automatically add '_label' fields to reference fields in the output, providing human-readable values for those fields.
Select Columns Names or IDs. Allows selection of specific fields (columns) to include in the response. If no fields are selected, all fields are returned. The ID field is always included regardless of selection.
Flatten User-Defined Fields Determines whether user-defined fields (UDFs) are brought up to the top level of each returned object instead of being nested inside a 'userDefinedFields' array.

Output

JSON

  • id - Unique identifier of the service call record.
  • fields
    • * - Selected fields of the service call record as per the 'Select Columns' input; includes all fields if none selected.
    • *_label - Human-readable labels for picklist and reference fields, added if respective options are enabled.
  • userDefinedFields - Array of user-defined fields, unless 'Flatten User-Defined Fields' is enabled, in which case these fields appear at the top level.

Dependencies

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

Troubleshooting

  • Invalid JSON in 'Advanced Filter' will cause the node to fail. Ensure the JSON string is correctly formatted and follows Autotask API filter syntax.
  • Requesting too many records without 'Get All' enabled may result in incomplete data. Use 'Get All' to retrieve all matching records if needed.
  • Selecting invalid or non-existent fields in 'Select Columns' may cause errors or missing data. Use 'Get Field Info' to verify field names.
  • If labels are not appearing, verify that 'Add Picklist Labels' and 'Add Reference Labels' options are enabled and that the fields have valid values.
  • Flattening user-defined fields may cause naming conflicts if UDF names overlap with standard fields; disable flattening if this occurs.

Links

Discussion