Querying Data

Querying data in Mind One means accessing the records stored in sheets — from the interface, via export, or through the API. Every role with access to the platform can query data; edit permissions depend on the assigned role.

Navigating to a sheet

Data is accessed through the sidebar navigation menu:

1. Select the relevant workspace.
2. Click the sheet you want to view.
3. The table view opens with the sheet’s records.

You can also reach a sheet from a group: select the group from the menu and access the sheet from its list of associated sheets.

Table view

Records are shown in a spreadsheet-like table with:

• Columns corresponding to the sheet’s fields.
• Pagination to browse records when the volume is high.
• Validation indicators on cells with errors or values pending correction.
• The sheet’s sync status (Synced, Syncing, Error, Skipped).

Sorting

Click a column header to sort records by that field. A second click reverses the order.

Search

Use the table’s search bar to filter records by text. The search applies across every visible field in the sheet.

Sheets with partitions

When a sheet has partition fields, the data is segmented across dimensions — the sheet acts like a data cube. Before viewing the records, you must select the partition values:

1. Open the sheet.
2. Partition selectors appear — one for each defined partition field.
3. Select the desired value for each dimension.
4. The table shows the records corresponding to that combination.

You can change the selection at any time to query another segment of the cube.

Exporting data

From the sheet view you can download the data in different formats.

Excel (.xlsx)

Downloads all visible records as Excel, with options:

• Enabled dropdowns: cells with value lists include Excel data validation.
• Value list display: export the key or the label.

PDF

Exports the sheet to PDF for sharing or archiving.

Querying via the API

Mind One’s public API lets you access records programmatically.

Listing a sheet’s records:

GET /api/v1/public/datagrids/{datagridId}/rows?page=1&limit=50
Authorization: Bearer mk_your_api_key

The response includes paginated records with pagination metadata (total, page, pageSize, totalPages).

See the API Documentation for the full list of available endpoints and parameters.

Permissions

Every role can query the data in the workspaces and sheets they have access to.

Sheets inherit the workspace’s security: if you’re assigned to a workspace, you see all its sheets (and the tenant owner sees everything).

Related

• Sheets — Structure, fields and management of master data.
• Workspaces — Navigating and organizing data by domain.
• Groups — Access to sheets grouped by business process.
• API Documentation — Programmatic access to records.