Wiresk

Wiresk

What is a Query Builder

Estimated reading time: 1 min

The Query Builder in Wiresk is a feature design to help users in defining and obtaining data from connected apps in a structured and adaptable manner. You can see it like, a method to “inquire” with your data source about particular questions (queries) and receive precisely the information you require, structured just the way you want.

Query Builders are typically graphical user interfaces (GUIs) that allow users to select and filter data.

Screenshot of Wiresk Flow builder with the setting screen of Odoo method called "Retrieve records using Wiresk's Query Builder. an Arrow shows the location of the Query builder setting.
This Feature is available in connected apps like Odoo, Microsoft Dynamics 365, HubSpot and more, as a Trigger.

The Query Builder breaks down the process of building queries into intuitive steps, using different tabs and parameters for customization:

Narrow down the records being retrieved by specifying conditions.

Example: Retrieve only email threads where the status is “Open” or where the priority is “High.”

Edit Columns: Select the fields or columns of data to include in your query results.

Minimum Columns: At least 1 column must be selected to preview data.

Maximum Columns: Up to 50 columns can be included in the query results.

Error Handling: If no records are found or columns are not configured, you might see the error: “Cannot convert undefined or null to object.”

View a sample of the records your query retrieves before finalizing it.

Default Display: Shows up to 10 records at a time, starting at record 0.

Customization: Adjust the starting record and the number of records displayed as needed.

Requirement: At least 1 column must be selected to enable data preview.

The Query Builder simplifies data retrieval by allowing users to:

  • Customize queries based on specific needs.
  • Visualize and validate data through previews.
  • Organize data using filters and sorting.

Query Builders are a great way for non-technical users to get started with data analysis. They make it easy to access and explore data, and they can help users identify trends and patterns that would otherwise be difficult to see.

On the same topic, see the tutorial on “How to use a Query Builder“.
Explore our User Guide here.
For a complete tutorial on how to create a Flow, see “How to create a Flow in Wiresk”