Autotask icon

Autotask

Consume Autotask REST API
Join our community

Actions389

Overview

This node operation retrieves multiple Product records from the Autotask system using an advanced filtering mechanism. It allows users to specify complex query criteria in JSON format to filter products, control the number of records returned, and customize the output fields. This is useful for scenarios where precise product data extraction is needed, such as generating reports, syncing product catalogs, or integrating product data with other systems.

Properties

Name Meaning
Get All Determines whether to return all matching product records or limit the results to a specified maximum number.
Max Records Specifies the maximum number of product 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 products. Users should construct this JSON using the Autotask API documentation and helper tools.
Add Picklist Labels Indicates whether to automatically add human-readable '_label' fields for picklist fields in the product data. Empty values will not have labels added.
Add Reference Labels Indicates whether to automatically add human-readable '_label' fields for reference fields in the product data. Empty values will not have labels added.
Select Columns Names or IDs. Allows selection of specific product 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 Determines whether user-defined fields (UDFs) are brought up to the top level of each product object instead of being nested inside a 'userDefinedFields' array.

Output

JSON

  • id - Unique identifier of the product record.
  • fields
    • * - Various product fields as returned by the Autotask API, including standard and user-defined fields.
  • *_label - Optional human-readable labels for picklist and reference fields if enabled.

Dependencies

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

Troubleshooting

  • Invalid JSON in the 'Advanced Filter' property can cause query failures. Ensure the JSON is well-formed 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 fields that do not exist or are misspelled in 'Select Columns' may cause errors or missing data.
  • Network or authentication errors may occur if the Autotask API credentials are invalid or expired. Verify and update credentials as needed.

Links

Discussion