Directly import a .json file from your workstation. No external authentication required.
For the general flow of adding a source, see Connect Data Sources.
Prerequisites
Valid .json file: an array of objects
UTF-8 encoding
Setup
Step 1 — Prepare your .json file
The simplest shape is an array of objects at the root (a single object is accepted and gives one row):
[
{"name": "Alice", "address": {"city": "Paris"}, "roles": ["admin"]}
]Nested objects become composed columns (address_city). Arrays are kept as they are in a jsonb column, queryable with ->, ->> and jsonb_array_elements.
Envelopes are read through: {"data": [...]} imports as it is, and when a file holds several collections — a Zabbix export and its hosts, groups, templates — they are listed with their record counts, and every collection you tick becomes its own table.
NDJSON (one object per line) is accepted too, in a file with the .json extension.
Step 2 — Upload in HARVEN
Enter a name for the connector
Drag and drop or select your .json file
Review the detected columns preview
Click Save: the rows are loaded into the table
Fields to fill in HARVEN
Field | Where to find it |
|---|---|
JSON file | Your workstation |
Collected data
(dynamic) — Every key found in the file is imported, including keys absent from the first element
Need help? Contact [email protected].