Import and export query definitions (JSON) in web view Query

Building a query in web view means clicking in every criterion by hand. For queries with many conditions, nested AND/OR groups and summary fields with date filters, that takes a lot of time and is easy to get wrong. It's especially frustrating when the same logic already exists in another query, or when a colleague has written down the criteria and someone else has to rebuild them line by line.

The Query API already represents queries as JSON (select fields, filter fields with query_field_ids, operators, values). Please make that available in the UI as well:

Export definition: a button on a saved query that downloads its criteria, output fields and sort order as a JSON file.

Import definition: create a new query from such a JSON file. RE validates the fields and values and flags anything that doesn't exist in this database (e.g. a constituent code that isn't set up) before saving.

API: an endpoint to create or update a saved query from the same JSON format, so queries can be built and maintained from Power Automate or scripts.

Benefits: reuse complex criteria as templates instead of rebuilding them; share queries between colleagues, or between a sandbox and the live database; keep track of how a query was defined (documentation, versioning); fewer errors from retyping long criteria lists.

Related ideas: "Merge or copy query criteria", "Copy and Paste Query Criteria", "Add an option to duplicate a query", "Create Reference for the Query_Field_IDs Accessible Via Query API".

  • Josef Stolz
  • Nov 11 2026
  • Attach files