Autotask icon

Autotask

Consume Autotask REST API
Join our community

Actions389

Overview

This node operation retrieves multiple Configuration Item Billing Product Association records from the Autotask REST API using advanced filtering options. It is useful for users who need to query and extract detailed billing product association data linked to configuration items, applying complex filters to refine the results. For example, a user can fetch all billing product associations that meet specific criteria such as date ranges, status, or linked configuration item attributes, enabling detailed reporting or integration workflows.

Properties

Name Meaning
Fields Defines which fields to map and include in the output for the Configuration Item Billing Product Association resource.
Get All Determines whether to return all matching records or limit the number of records returned.
Max Records Specifies the maximum number of records to return when 'Get All' is false. Valid range is 1 to 500.
Advanced Filter A JSON string containing a 'filter' array with Autotask API query criteria to apply complex filtering on the data.
Add Picklist Labels Whether to automatically add human-readable '_label' fields for picklist fields in the output.
Add Reference Labels Whether to automatically add human-readable '_label' fields for reference fields in the output.
Select Columns Names or IDs. Allows selection of specific fields to include in the response. If none selected, all fields are returned. The ID field is always included.
Flatten User-Defined Fields Whether to bring user-defined fields (UDFs) up to the top level of each object instead of nested inside a userDefinedFields array.

Output

JSON

  • id - Unique identifier of the Configuration Item Billing Product Association record.
  • configurationItemId - Identifier of the linked configuration item.
  • billingProductId - Identifier of the associated billing product.
  • userDefinedFields - Array of user-defined fields related to the record, unless flattened to top-level properties.
  • _label - Human-readable labels for picklist or reference fields, added if enabled.
  • otherFields - Additional fields as specified by the selected columns or fields to map.

Dependencies

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

Troubleshooting

  • Invalid JSON in the 'Advanced Filter' property can cause query failures. Ensure the JSON string is well-formed and follows Autotask API filter syntax.
  • Requesting more than 500 records without enabling 'Get All' may result in truncated results or errors. Use 'Get All' to retrieve all records or limit 'Max Records' appropriately.
  • Selecting fields that do not exist or are not accessible may cause errors or empty fields in the output. Use 'Get Field Info' to verify available fields.
  • If picklist or reference labels are not appearing, verify that 'Add Picklist Labels' and 'Add Reference Labels' are enabled and that the fields have valid values.

Links

Discussion