Autotask icon

Autotask

Consume Autotask REST API

Actions389

Overview

This node operation retrieves multiple project tasks from the Autotask system using an advanced filtering mechanism. It allows users to specify complex query criteria in JSON format to filter tasks according to their needs. This is useful for scenarios where users need to extract a customized list of project tasks based on specific conditions, such as status, assigned resources, dates, or other task attributes. For example, a project manager could use this to get all tasks assigned to a particular team within a date range or all tasks with a certain priority level.

Properties

Name Meaning
Get All Determines whether to return all matching project tasks or limit the number of results.
Max Records Specifies the maximum number of project task 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 to filter project tasks. This allows for complex and precise filtering based on Autotask's query syntax.
Add Picklist Labels If enabled, adds human-readable '_label' fields for picklist fields in the output, making it easier to understand picklist values.
Add Reference Labels If enabled, adds human-readable '_label' fields for reference fields in the output, improving readability of referenced entities.
Select Columns Names or IDs. Allows selection of specific 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 brought to the top level of each task object instead of being nested inside a userDefinedFields array, simplifying access.

Output

JSON

  • id - Unique identifier of the project task.
  • name - Name or title of the project task.
  • status - Current status of the task.
  • assignedResourceId - ID of the resource assigned to the task.
  • assignedResourceId_label - Human-readable label for the assigned resource (if Add Reference Labels is enabled).
  • priority - Priority level of the task.
  • priority_label - Human-readable label for the priority picklist (if Add Picklist Labels is enabled).
    userDefinedFields - Individual user-defined field values if Flatten User-Defined Fields is enabled. - Additional fields selected via Select Columns or returned by default.

Dependencies

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

Troubleshooting

  • Invalid JSON in the Advanced Filter property will cause errors. Ensure the JSON string is well-formed and follows Autotask API query syntax.
  • Requesting too many records without pagination or limits may cause timeouts or API throttling.
  • If no results are returned, verify that the filter criteria correctly match existing project tasks.
  • Enabling Add Picklist Labels or Add Reference Labels requires that the referenced data is accessible; otherwise, labels may be missing.
  • Selecting invalid or non-existent columns in Select Columns may cause errors or empty fields in the output.

Links

Discussion