hap-cli-data-query

You can query HAP worksheet data by constructing a valid filter-json structure that supports nested AND or OR logic. This approach processes multi-condition, field-type-aware filters to retrieve specific records without manual parameter construction.

Summarize HAP records by applying pivot analysis to group data by dimensions like category or date. You can calculate sums, counts, averages, minimums, maximums, or distinct counts directly through HAP CLI query commands.

Finding specific field IDs and relation row IDs is part of record discovery. This process resolves relation row IDs and queries subtable rows by requiring valid worksheet field identifiers within your HAP CLI query commands.

Yes, you can paginate results and sort records when filtering HAP worksheet data. The query process supports appropriate pagination parameters, sorting configurations, and limiting returned fields to manage large datasets effectively.

Yes, retrieving and aggregating business data requires HAP CLI query commands. You must provide worksheet field identifiers, valid filter-json structures, and appropriate pagination or pivot view parameters to execute accurate queries.

HAP data queries with nested filter conditions fail when the filter-json structure is invalid or field types are mismatched. This approach prevents these errors by building field-type-aware filters and resolving relation row IDs correctly.