Getting started
This walkthrough takes you from a fresh install to updating host tags in Zabbix. It assumes ZbxWizz is installed and that you have an API token ready.
Typical flow:
Import (Zabbix / CSV / Excel / JS)
│
▼
Edit sheet (filter · transform · pull)
│
▼
Export (CSV / Excel / charts) or Push to Zabbix
1. Connect to Zabbix
- Click the Zabbix logo (top right)
- Enter:
- API URL:
api_jsonrpc.phpwhen served from the Zabbix frontend, or a full URL otherwise - API Token: from Users → API tokens
- API query mode: start with Sequential for write tests
- API URL:
- Click Save config
The logo turns bright red when the connection test (host.get with limit: 1) succeeds.
2. Import hosts
-
Data → Import → From Zabbix
-
Resource:
host -
In the request editor, paste:
{ "limit": 5, "selectTags": ["tag", "value"] } -
Run the import (Execute)
Five hosts appear in the table. Nested fields (like tags) are stored as JSON strings in the cells; the original object is also kept on the row as data.csv for transforms.
Safety default: if you omit
limiton a.getcall, ZbxWizz injectslimit: 5and may warn when the result hits that ceiling. Always set an explicit limit when you need more rows.
3. Transform a column
Add a tag to every visible host.
-
Open the column index menu on the tags column
-
Choose Transform
-
Enter:
json(obj(data.csv.tags).concat({"tag":"zbxwizz","value":"was here"})) -
Check the live preview, then apply
The expression runs on each visible row in that column. Filtered-out rows are skipped.
4. Select rows to update
- Check individual row checkboxes, or
- Use the header checkbox to toggle all visible rows
Pull and Push only process rows that are both selected and visible.
The footer shows Total, Selected, and Visible counts.
5. Push back to Zabbix
-
Zabbix → Push
-
Configure:
- Resource:
host - Operation:
update
- Resource:
-
In the request editor (adjust the tags column index if needed):
{ "hostid": "${flds.hostid}", "tags": ${cols[1]} } -
Check the preview — it should show valid JSON with
hostidandtags -
Confirm and execute
Verify the new tag in the Zabbix UI under Data collection → Hosts.
What you learned
| Concept | Used here |
|---|---|
| Import template | JSON params for host.get |
| Transform expression | JavaScript with data.csv, obj(), json() |
| Push template | JSON with ${flds.*} and ${cols[N]} |
| Row selection | Only selected + visible rows are pushed |
Next steps
- User interface — menus, sheets, filters, persistence
- Zabbix operations — Pull, Push, query modes, safety
- Transformations — full expression reference
- Examples — import items, bulk rename, charts, host groups
Spreadsheet alternative
If you prefer editing outside the app:
- Import from Zabbix
- Data → Export → CSV (or Excel)
- Edit in Excel / LibreOffice
- Data → Import → CSV (or Excel)
- Push as above
Ensure the host ID column is named hostid, or change ${flds.hostid} in the push template to match your column name.