iMIS IQA Query icon

iMIS IQA Query

Execute iMIS IQA queries and return iterable JSON results

Execute Query

AI-generated

Summary

Execute an iMIS IQA query by specifying its full path, optionally paginating through the results and transforming them into JSON objects. Return the results either as individual workflow items per row or as a single item containing all results and metadata.

Inputs

  • Query Name (required) — The full path to the IQA query to execute (e.g., $/Common/Queries/Value Lists/MemberTypeList).
  • Split Results — Choose to split each query result row into separate workflow items or return all results in a single item.
  • Additional Options — Additional parameters including Limit (max number of results), Offset (number of rows to skip for pagination), and Query Parameters (positional parameters to pass to the IQA query).

Output shape

List of JSON items representing IQA query results, either one item per row or a single item containing all rows and metadata.

Pagination is handled internally to bypass iMIS 500-row page limits, automatically fetching all data up to the Limit or entire result set if no limit is set. Metadata about the query execution (e.g., total count, pages fetched, execution timestamp) accompanies the results. Errors per item can be optionally captured when continuing on fail.

Examples

Example 1: Fetch members from an iMIS query with pagination and return each member as a separate item

Set Query Name to the target IQA query full path; keep Split Results true; optionally specify Limit and Offset under Additional Options.

Example 2: Run an IQA query with parameters and get all results in one item

Provide Query Name, pass required Query Parameters in order under Additional Options, and set Split Results to false.

Links

Discussion